Миграция структуры и данных MySQL на MS SQl Server при помощи SSMA

  • SSMA — Microsoft Sql Server Migration Assistant

1. Где взять SSMA?
http://www.microsoft.com/en-us/download/details.aspx?id=28764

2. Как инсталлировать SSMA?
After the download, you must extract the installation files before you can install SSMA for MySQL.

Installing the SSMA for MySQL

  1. Double-click SSMA for MySQL exe.
  2. On the ‘Welcome’ page, click Next.
  3. If you do not have the prerequisites installed, a message will appear that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
  4. Read the End User License Agreement. If you agree to the terms, select «I accept the agreement» option and click Next.
  5. Read the ‘Usage Report Settings’ page, select or clear the feature reporting box, and then click Next.
  6. On the ‘Choose Setup Type’ page, click Typical.
  7. Click Install.

In addition to the SSMA program files, you must also install the SSMA for MySQL Extension Pack on the SQL Server machine.

Installing the SSMA for MySQL Extension Pack
Note: SSMA for MySQL Extension Pack is not supported on Windows XP.

  1. Double-click SSMA for MySQL Extension Pack.exe file.
  2. On the ‘Welcome’ page, click Next.
  3. Read the End User License Agreement. If you agree to the terms, select «I accept the agreement» option and click Next.
  4. On the ‘Choose Setup Type’ page, click Typical.
  5. On the ‘Ready to Install’ page, click Install.
  6. On the ‘Completed the First Step of Installation’ page, click Next. A new dialog box will appear, in which you select the instance of SQL Server for the extension pack installation.
  7. Select the instance of SQL Server where you will be migrating MySQL schemas, and then click Next. The default instance has the same name as the computer. Named instances will be followed by a backslash and the instance name.
  8. On the connection page, select the authentication method and then click Next.Windows Authentication will use your Windows credentials to try to log on to the instance of SQL Server. If you select SQL Server Authentication, you must enter a SQL Server login name and password.
  9. On the next page, select Install Utilities Database n, where n is the version number, and then click Next.The sysdb database is created and the user-defined functions and stored procedures are created in that database. If Install Tester Database option is checked the tester ssmatesterdb database will be created.
  10. To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.

3. Как запустить SSMA?
При первом запуске программы откроется окно, где будет предложено зайти на сайт и скачать лицензии для подключаемых баз, в нашем случае это MySQL. Заходим на сайт, качаем файл лицензии и в окне указываем путь к файлу, потом жмем Refresh license. Готово.

4. Как это работает?
http://technet.microsoft.com/ru-ru/library/ff520606.aspx

5. Если во время операций «Covert schema» или «Synchronize with the Database» возникли ошибки связанные с cascade foreign keys?
http://blogs.msdn.com/b/ssma/archive/2011/03/19/mysql-to-sql-server-migration-method-for-correcting-schema-issues.aspx

Реклама