Migrate from MYSQL to MSSQL Server 2005

  • Hi

    I need Procedure to migrate MYSQL database to MSSQL Server 2005.

    also any third party or native tools details, if we have.

    Regrds

    Lee

  • Using Sql Server Import/Export wizard you can easily import the data into sql server. You can also try Linked Server with MySQL - Linked server with MySQL

    Or you can use MySQL Migration Toolkit 1.1, it is available here -MySQL GUI Tools Downloads

    John Smith

  • Lee From Bangalore (2/23/2009)


    I need Procedure to migrate MYSQL database to MSSQL Server 2005.

    This is a very well documented matter, you may want to start by checking this TechNet document http://technet.microsoft.com/en-us/library/cc966396.aspx

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply