locked
Migration Problem RRS feed

  • Question

  • I am trying to migrate a Sybase database to SQL formate using the SQL server migration assistant for Sybase v5.2.  My Sybase database is running on a virtual machine NT machine and the migration program is on an XP machine.  First on the xp machine I created my ODBC for Sybase app but it would not connect to the virtual database.  Then I thought maybe I should install the migration program on the virtual machine.  That doesn't work either as the migration program says it can't work on NT.  Can someone please tell where to go next.
    Tuesday, April 9, 2013 7:53 PM

All replies

  • Is NT system accessible from XP? Can you ping its IP over network? You definitely need to configure Sybase client on XP, and create successful connection to the Sybase server on NT. Which Sybase version are you running? Do you have test connection option in your ODBC driver?

    Dmitry

    http://www.sqlines.com - Database migration tools for SQL Server

    Thursday, April 11, 2013 10:43 PM
  • Hello,

    To migrate Sybase to SQL Server, you can try to using SSMA. SQL Server Migration Assistant (SSMA) for Sybase is a comprehensive environment that helps us quickly migrate Sybase Adaptive Server Enterprise (ASE) databases to SQL Server. By using SSMA for Sybase, we can review database objects and data, assess databases for migration, migrate database objects to SQL Server, and then migrate data to SQL Server.

    To download SSMA, please refer to:http://www.microsoft.com/en-us/download/details.aspx?id=28765

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Friday, April 12, 2013 8:57 AM
  • Yes I am configuring the Sybase client on Xp and yes I have the test connection option, but it is not connecting to the virtual NT Sybase or ping the server.  I am using Sybase 12.5.2
    Friday, April 12, 2013 6:56 PM
  • So you cannot even ping the NT system? Your need to resolve this first, maybe networking is disabled on the virtual machine or network adapter is not configured properly. Once you have a network connection, find out the Sybase port, I believe you will be able to connect using SSMA.

    Dmitry

    http://www.sqlines.com


    • Edited by Dmitry Tolpeko Friday, April 12, 2013 7:14 PM
    • Proposed as answer by Fanny Liu Tuesday, April 16, 2013 8:54 AM
    • Unproposed as answer by precioustr Tuesday, April 16, 2013 5:28 PM
    Friday, April 12, 2013 7:13 PM