locked
Migrating SybaseIQ to SQL Server via SSMA? RRS feed

  • Question

  • Hi all,

    anyone who tried to migrate from Sybase IQ to SQL Server via SQL Server Migration Assistant (SSMA)? As from the product Website only Sybase ASE is officially supported. I'm looking especially for a way to migrate Stored Procs.

    BR Dirk

    Friday, March 7, 2014 11:18 AM

Answers

  • Hi Dirk,

    Indeed, SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase ASE version 11.9 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure. If you want to migrate T/SQL Stored Procedures from Sybase IQ to SQL Server, maybe need to use the third-party tools, such as SQLWays or other tools.   

    There is a detail about SQLWays Tool, you can review the following article.

    http://www.ispirer.com/products/sybase-to-sql-server-migration

    Note: Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and please be cautious and ensure you have completely understood the risk before retrieving any software from the Internet.

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Dirk_G_66 Monday, March 10, 2014 11:22 AM
    Monday, March 10, 2014 9:16 AM

All replies

  • Hello,

    The answer is no, but you still can do it using the instructions provided on the following article:

    http://blogs.msdn.com/b/ssma/archive/2013/02/01/can-t-migrate-from-sybase-asa-to-sql-server-using-ssma.aspx

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Sofiya Li Monday, March 10, 2014 8:59 AM
    Friday, March 7, 2014 2:35 PM
  • Hi Dirk,

    Indeed, SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase ASE version 11.9 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure. If you want to migrate T/SQL Stored Procedures from Sybase IQ to SQL Server, maybe need to use the third-party tools, such as SQLWays or other tools.   

    There is a detail about SQLWays Tool, you can review the following article.

    http://www.ispirer.com/products/sybase-to-sql-server-migration

    Note: Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and please be cautious and ensure you have completely understood the risk before retrieving any software from the Internet.

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Dirk_G_66 Monday, March 10, 2014 11:22 AM
    Monday, March 10, 2014 9:16 AM