Efficiently push and pull data in SQL Server
What is the most efficient way to 'PUSH' data from Sybase to MS SQL server or 'PULL' data into MS SQL server from Sybase?

    Requires Free Membership to View

    When you register, you’ll also receive targeted emails from my team of award-winning editorial writers.  Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

I was able to access Sybase ASE Data at one client site provided I installed the Sybase Client drivers on my machine running SQL Server. If I remember correctly, this provided me with Sybase ASE ODBC Drivers. I accessed Sybase data both through replication and in DTS Packages under SQL Server 2000.

This was first published in October 2006