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.
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.
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.
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
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.
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.
11 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index