March 28, 2011 at 12:30 am
I need to transfer data (10 gb) from SQL server to Sybase database on daily basis.
Which one is faster approach??
1) Pulling data from SQL server to Sybase through ECDA connection in sybase server
2) Transferring or Pushing Data to sybase through linked server in SQL server 2005
March 30, 2011 at 4:08 am
I understand that ECDA is a sybase gateway - that can be used for replication (is this your intention?).
1) Pulling data from SQL Server - you would rely on ECDA interface - how would you do this?
2) Transfer via linked server
3) SQL Server integration Services. Check out http://www.databasejournal.com/features/mssql/article.php/3594201/SQL-Server-2005-Integration-Services---Import-and-Export-Wizard.htm
One issue with connecting from Windows 64bit with SQL Server is the Sybase driver - if you have this then ok (and found that it works) otherwise an other solution is to use a 32bit windows 2003 server as SSIS server and use the drivers there.
Have you thought of this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply