Complexity of migrating data

  • Hi All, can someone tell me the complexity of converting a MySQL Database into a MS SQL Database? Is there a guideline I can use? I just installed MySQL on windows, created a dummy DB with some tables and I am trying to figure out the way to migrate the data to MS SQL. Any help will be highly appreciated.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • New Born DBA (4/30/2015)


    Hi All, can someone tell me the complexity of converting a MySQL Database into a MS SQL Database? Is there a guideline I can use? I just installed MySQL on windows, created a dummy DB with some tables and I am trying to figure out the way to migrate the data to MS SQL. Any help will be highly appreciated.

    It's been a while but last time it was straight forward dump of the MySql to flat files (CSV), bcp into the SQL Server and then finish with constraints, indexes etc.

    😎

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

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