Database Migration(Sybase -> SQL Server 2000)

• ATLDBA

  SSC Veteran

  Points: 277

  More actions

  March 19, 2003 at 7:38 am

  #58345

  What is the best way to migrate a Sybase database into SQL Server 2000. Using DTS, I do not see an option for Sybase. Thanks!

  Carpe diem!

  
  Carpe diem!

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 20, 2003 at 2:27 pm

  #451628

  In the DTS wizard, select "Other" for your data source and create a new DSN using a Sybase ODBC driver (assuming you have one).

  Greg

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 20, 2003 at 3:02 pm

  #451631

  Check the white paper as following.

  http://www.microsoft.com/sql/techinfo/deployment/70/sybasemigration.asp