'bcp' is built for working with Sybase databases. It does not work with
non-Sybase databases (ok, ok, ok ... you may get some versions to work
with MS-SQL Server) ... in this case you're better off with the tool(s)
provided by the target database vendor or a 3rd party product. For
example, if I were trying to get data out of Sybase and into Oracle I
might use 'bcp' (Sybase utility) to get the data out of Sybase and
'sqlloader' (Oracle utility) to get the data into Oracle.
I don't have direct information on 3rd party products but there have
been several posts here in the Sybase newsgroups about folks using 3rd
party tools that provide a 'pipe' for getting data between databases ...
either search the old posts or hope someone pops in on this thread and
provides some suggestions.
Of course, it would also be convenient to know if you're looking to do
this once (e.g., switching database platforms) or if this will be an
ongoing need (e.g., replication between databases)??
Iron Horse Consulting, Ltd.