Copying data from SQL Server to Sybase IQ

ssalun 26 Reputation points
2021-03-22T13:38:28.907+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,631 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-03-23T02:56:28.843+00:00

    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. Erland Sommarskog 100.8K Reputation points MVP
    2021-03-24T22:25:47.173+00:00

    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.

    0 comments