SSMA migrating local my SQL to local SQL Server and Windows Azure SQL Databaase

Source: Internet
Author: User



SSMA migrating local my SQL to local SQL Server and Windows Azure SQL Databaase



Speaking of databases, many people will think of my SQL, SQL Server and Oracle, and so on, and very people prefer my SQL, because my SQL is free, and the packet is relatively small, fast and convenient installation, and SQL server is charged, is Microsoft's products, charges are quite high, Generally rarely used, unless the big data, of course, in the case of funding to select the Oracle database, which I do not specifically, today, we mainly describe how to migrate the local my SQL data to SQL Serrver, no matter what services, migration data is the most painful thing, Is there a more intelligent way to do the migration, the answer is necessary, what is it? That is Microsoft provides a tool Ssma,



SSMA (SQL Seerrver migration Assistant) software Server provides the migration of local my SQL to SQL Server and Windows Azure SQL Servrer dabase, as follows:



The first is to download the software:



Http://www.microsoft.com/en-us/search/result.aspx?q=microsoft SQL Server Migration Assistant for MySQL






Start installation after download





Tip the driver for my SQL ODBC is not found locally, and you can click Download






http://dev.mysql.com/downloads/connector/



http://dev.mysql.com/downloads/connector/odbc/






After downloading, we can install






Start installation






Installation Complete






We continue to install Ssma






Start installing Ssma






Tool installation Complete






After installation, the desktop is one more Microsoft SQL Server Migration assing





Enable the program






Start by creating a new project
After starting the program, click the New Item icon in the upper left corner



Then choose whether you want to migrate to SQL Server or SQL Azure (we select SQL Server)






After the project is created, we link my SQL because we want to migrate my SQL





MY SQL Link Certification





connected to MySQL



Click the connect to mysql icon in the upper-left corner (you must confirm that the MySQL ODBC Connector is installed), and your MySQL database information will be displayed in a tree view





Create a Schema Migration report



Select the database that you want to migrate, then right-click the database name and select Create report :





. connected to SQL Server (or SQL Azure , it depends on the first 3 Step Selection)



Click "Connect to the upper left corner of the SQL Server icon." You can provide the credentials to connect to SQL Server or to SQL Azure. If the database you selected in step 4 of the MySQL database has the same name that does not exist, you will be asked if you want to create one.



Note : If you do not want Ssma to create a database for you, you should specify the database you want to migrate to in the Connection dialog box. By default, Ssma converts all objects in the MySQL database DB1 to the SQL Server schema db1.dbo SQL Servers database DB1, which must be created synchronously (see step 8th). The simplest way to do this is to specify the database name in the SQL Server Connection dialog box when you establish a connection to a SQL Server database.





Because we are migrating to SQL Server, we also need to link SQL Server





MY SQL and SQL Server are linked successfully





You should now see a tree view of SQL Server data in SQL Server Explorer , select the mode you want to migrate.



7. Conversion Mode (that is, table) in MySQL Metadata Explorer , right-click the database you want to migrate and select convert mode :





At this point, you may need to make some changes in the transformation mode, for example, I chose the link_updated column, which is an empty column, because this column MySQL set the default value, and 0000-00-00 00:00:00, is a special value, will be treated as a null value data to migrate, and this change can lead to errors if the data is migrated without change.





SQL Server Synchronization of Databases



Select the database to synchronize to in SQL Server, right-click to select Synchronize with Database





Confirm the database that you want to synchronize, confirm





Synchronization complete





Migrating data



In MySQL metadata Explorer, right-click the database you want to migrate and select migrate data to Enter the connection credentials for the MySQL and SQL Server databases.





Prompt to verify database authentication before migration





Start migrating data





Migration success





If you are migrating to Windows Azure SQL database, we need to create a project in the first step to be honest about choosing SQL Azure, which does not introduce much, since Ssma software currently migrates to my SQL to SQL Serrver does not support domestic windows In Azure, only the international version of Wiindows Azure is supported. is not unsupported, but the current software if you choose to migrate to Windows Azure, the database connection only international domain name (database.azure.cloud.net), there is no domestic windows Azure Domain Name (database.azure.cloud.cn). So there is no option to connect to the domestic Windows Azure database



This article is from the "Gao Wenrong" blog, make sure to keep this source http://gaowenlong.blog.51cto.com/451336/1581630



SSMA migrating local my SQL to local SQL Server and Windows Azure SQL Databaase


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.