Copying data from SQL Server to Sybase IQ

Question

Hi,

I have a requirement to copy data from SQL Server to Sybase IQ server.
Please note this is going to be batch script so don't need solution using SSIS.

Could you please advise.

Thanks.

Answer 1

Hi @SwapnilSalunke-4731,

If you don't want to use SSIS, please try to create a linked server between SQL Server and Sybase IQ, and then use script to copy data. For the steps, please refer to Connect to Sybase IQ Data as a Linked Server.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

BCP could be an option. This is a command-line tool, so you could easily use it in a batch file. If you have never worked with BCP, I have an article here: http://www.sommarskog.se/bulkload.html.

It does not discuss Sybase IQ, though, since I am not familiar with that product. But I googled quickly, and it seems that there is a BCP for Sybase IQ.