Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009

    Question Unanswered: Sybase to SQL 2000 Migrations Tools?


    Are there any migrations tools for Sybase to SQL Server 2000 beside using the DTS from SQL ?

  2. #2
    Join Date
    Mar 2009
    Sydney, Australia

    You can export all:
    - DDL using ddlgen or any DBA type tool (DBArtisan, SybaseCentral)
    - data using bcp out (character format)
    Then import it in on the other side using the MS equivalent. This method is very useful because it will allow you to be warned of the differences (eg. during the DDL import) and resolve them, one by one, using the MS equivalent option of your choice. Likewise the data: you have an opporunity to make changes in an interim database on the MS side, before deciding that it is ready for app access.

    This method is much faster than the OLE DB/ODBC that DTS uses.
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

  3. #3
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Click on this link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts