MySQL to MSSQL

 
When changing your SQL platform from My SQL to MS SQL we always recommend that a local copy is made of your MySQL database before it gets deleted, regardless of whether or not you are planning on converting the database for your new platform.

The instructions below describe how to backup your MySQL database to your local PC by using phpMyAdmin. There are, however, many ways this can be done.

Backup your MySQL database by using phpMyAdmin in MyAccount

1.        Log on to MyAccount

2.        Click on SQL-admin

3.        Open the administrative tool phpMyAdmin

4.        Click Export 

Read here for additional information about phpMyAdmin.

Converting a MySQL database to MS SQL

There are many professional tools on the market with varying functionality and within a wide price range. You just have to find one that fits your needs and wallet.

Restore a MS SQL database from a backup file

Here follows a description of how a basic backup file (.BAK file) is uploaded by using MS Enterprise Manager:

1.     Open Enterprise Manager

2.     Connect to your database by using your SQL specific login details. Login details are found in MyAccount under MS SQL -> Get Started.

3.     Right click on your database name

4.     Choose All Tasks -> Backup Restore

5.     Make sure that the database name matches the one in MyAccount

6.     Choose From Device

7.     Choose Disk

8.     Choose Add and find the *.BAK file (Your Backup file) on your PC.

9.     The option Force restore over existing database should be deselected, unless you really know that this is what you want.

10.   Click on the tab Options and make sure that the data file and log file is given the correct filenames on the server. Example:
g:\mssql\data\MSSQL\data\_Data.MDF
g:\mssql\data\MSSQL\data\_Log.LDF

11.   Click OK to start restoring the database.

 

NOTE

-       When converting a database from one format to another, you are guaranteed that tables and columns are transferred correctly. However, indexes, primary keys etc, might have to be set up again.

-       Remember to change all database connections as they will become obsolete

-       Functionality specific for an earlier format might have to be recreated as this might not be supported by MS SQL or the converting tool used when converting a database.