none
Sybase ASE 12.5.4 table(s) not migrating

    問題

  • I am trying to migrate a Sybase ASE 12.5.4 database to SS 2008. I was able to create the objects in SqlServer, but the data isn't migrating.  The thing I find strange is that in the Sybase metadata explorer, on the data tab, I can see the data fine. It's not showing any errors either.

    The Data Migration Report has a single line, status = red "x", From = dbname.dbo.thetablename, To = blank, Total Rows = blank, Migrated Rows = blank, Success Rate = "N/A", Duration = blank.


    OUTPUT:
    Migrating data...
    Analyzing metadata...
    Preparing table fc2.dbo.AcceptDeclineReport...
    Preparing data migration package...
    Starting data migration Engine
    Starting data migration...
    Data migration operation has finished.
        0 table(s) successfully migrated.
        0 table(s) partially migrated.
        1 table(s) failed to migrate.

    2011年9月2日 下午 06:48

解答

  • I found the cause of the issue on this. It was caused due to source and target database were different cases, they need to be the same in order to migrate the database. An example is source database "dbname" and target database "DBNAME" will fail to migrate data. It took me a little while to figure out the issue. grr.


    • 已標示為解答 pdegagne 2012年3月29日 下午 03:59
    • 已編輯 pdegagne 2012年3月29日 下午 04:01
    2012年3月29日 下午 03:59

所有回覆

  • How are you trying to migrate the data? I would recommend installing the drivers to connect to a Sybase database on your production server and create a SSIS package to migrate the data over.


    Joie Andrew "Since 1982"
    2011年9月3日 下午 08:03
  • Hi pdegagne,

    The following blogs may help you to migrating the data from Sybase to SQL Server:

    How to migrate data fast from Sybase to SQL Server 

    Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project

    Hope this helps.


    Best Regards,
    Stephanie Lv

    Forum Support
    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    • 已標示為解答 Stephanie Lv 2011年9月14日 下午 12:27
    • 已取消標示為解答 pdegagne 2012年3月29日 下午 03:56
    2011年9月7日 下午 12:17
  • I found the cause of the issue on this. It was caused due to source and target database were different cases, they need to be the same in order to migrate the database. An example is source database "dbname" and target database "DBNAME" will fail to migrate data. It took me a little while to figure out the issue. grr.


    • 已標示為解答 pdegagne 2012年3月29日 下午 03:59
    • 已編輯 pdegagne 2012年3月29日 下午 04:01
    2012年3月29日 下午 03:59