question

SwapnilSalunke-4731 avatar image
0 Votes"
SwapnilSalunke-4731 asked CarrinWu-MSFT commented

Copying data from SQL Server to Sybase IQ

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.

sql-server-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Carrin,

Thanks for the input. We spoke to our DBA the option to linked server has been ruled out due to data size.


Regards,
Swapnil

0 Votes 0 ·
CarrinWu-MSFT avatar image CarrinWu-MSFT SwapnilSalunke-4731 ·

Hi @SwapnilSalunke-4731,

Sybase IQ supports BCP through the LOAD TABLE FORMAT BCP option. Sybase IQ also supports bulk loading of remote data using the LOAD TABLE USING CLIENT FILE option. Please get more details from Import and export methods and bcp Utility


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.