0

url reference How to import Sybase .db file into SQL Server database?

Please tell me how to transfer data from sybase to sql server database.

2
  • Please don't repost the same question multiple times. And please don't add your email address into posts unless you are begging for spam.
    – Hannah Vernon
    Sep 10, 2015 at 2:40
  • One way you can accomplish the transfer might be to use bcp to copy individual tables from Sybase into SQL Server. Another might be to use Linked Servers from SQL Server to the Sybase Server.
    – Hannah Vernon
    Sep 10, 2015 at 2:42

1 Answer 1

4

Method 1: You can use ODBC connections to create an SSIS package which will fetch the data from SYBASE database onto SQL server. On how to use or create such SSIS Package read Extracting data from Sybase SQL Anywhere using SSIS through ODBC. Then Schedule the above created package via SQL agent job to update data on SQL server as per schedule which meets the requirement.

Method 2: You can create a Linked server which fetches the required data from Sybase to SQL as described here.

And then create a job executing the task that refresh data from SQL Anywhere onto SQL Server using OPENQUERY

Not the answer you're looking for? Browse other questions tagged or ask your own question.