Microsoft SQL Server Migration Assistant for MySQL

  • Rating:
  • Version: 6.0.0
  • Publisher:
    www.microsoft.com
  • File Size: 7.35 MB
  • Date: Nov 30, 2014
  • License: Freeware
  • Category:
    Database Management
    Business & Finance
Microsoft SQL Server Migration Assistant for MySQL Download
Free Download Microsoft SQL Server Migration Assistant for MySQL 6.0.0

Microsoft SQL Server Migration Assistant for MySQL is a tool to automate migration from MySQL database to SQL Server or SQL Azure. A client application that you use to perform a migration from MySQL to SQL Server or SQL Azure. It also contains an extension pack that supports data migration and the use of MySQL system functions in your migrated databases.

Install the client application on the computer from which you will perform the migration steps. You must install the extension pack files on the computer where the migrated databases will be hosted. That computer must be running SQL Server.

SQL Server Migration Assistant (SSMA) for MySQL lets you quickly convert MySQL database schemas to SQL Server or SQL Azure schemas, upload the resulting schemas into SQL Server or SQL Azure, and migrate data from MySQL to SQL Server or SQL Azure.

To migrate MySQL databases to SQL Server or SQL Azure, you must first create an SSMA project. The project is a file that contains the following information:
1. Metadata about the MySQL databases that you want to migrate to SQL Server or SQL Azure.
2. Metadata about the target instance of SQL Server or SQL Azure that will receive the migrated objects and data.
3. SQL Server or SQL Azure connection information.
4. Project settings.

When you open a project, it is disconnected from MySQL and SQL Server or SQL Azure. That lets you work offline.

Command Line Usage: SSMAforMySqlConsole.exe
-s|script scriptfile
(required, XML file containing SSMA commands to be executed)
[-v|variable variablevaluefile]
(XML file containing values of parameter variables defined in the scriptfile)
[-c|serverconnection serverconnectionfile]
(XML file containing connection information for servers involved in the migration project)
[-l|log logfile]
(log file for logging SSMA activities)
[-e|projectenvironment projectenvironmentfolder]
(custom project environment settings folder)
[-x|xmloutput [xmloutputfile]]
(console output in XML format, if not specified output by default is in 'plain text' format)
[-p|-securePassword add|remove|list|import|export]
(password management, must be the only option in command line, type -p -? for more options)
[-?](show syntax summary)

Requirements:
1. Microsoft Windows Installer 3.1 or a later version.
2. The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
3. MySQL Connector/ODBC v5.1.
4. Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.

The license of this software is Freeware, you can free download and free use this database management software.

More Details:
Related Software: