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.