We have to transfer Data from Sybase to SQL Server database and are planning to use bcp. Is the queryout functionality also available in Sybase since we just need to select some rows of a table or is there any other option that can be used on Sybase that is equivalent to queryout of SQL Server?
To see what options bcp has in Sybase, run bcp /? at the command line. If you have both Sybase and SQL client tools installed, then make sure you navigate to the bcp.exe for Sybase, otherwise you might get the SQL options. They may behave the same though.
You can run sybase bcp and let it generate the format files for you, then edit the format files to say SQLCHAR instead of SYBCHAR and use SQL's BCP to load the files.
--Ken I want to die in my sleep like my grandfather, not screaming in terror like his passengers.
Sybase-->SQL Server
Posted - 09/28/2004 : 15:45:02
