2011. 6. 15. 10:01
Brain Trainning/DataBase
출처 : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=69739c8c-ac82-41de-b9e6-8fa5ae2594d9
Microsoft SQL Server Migration Assistant for MySQL v1.0
Brief Description
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
On this page
Files in this Download
The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
Overview
Microsoft SQL Server
Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost,
and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008 and SQL
Server 2008 R2. SSMA 2008 for MySQL also supports migrating to SQL Azure.
SSMA for MySQL lets you quickly convert MySQL database schemas to SQL Server schemas, upload the resulting schemas into SQL Server, and migrate data from MySQL to SQL Server.
SSMA for MySQL supports migration from MySQL 4.1 and higher to any edition of SQL Server.
SSMA for MySQL lets you quickly convert MySQL database schemas to SQL Server schemas, upload the resulting schemas into SQL Server, and migrate data from MySQL to SQL Server.
SSMA for MySQL supports migration from MySQL 4.1 and higher to any edition of SQL Server.
System Requirements
- Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Server 2008 R2;Windows Vista;Windows XP
SSMA for MySQL v1.0 is designed to work with MySQL 4.1 to 6.0 and all
editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 as well as SQL
Azure.
Requirements for the SSMA for MySQL client:
• Microsoft Windows Installer 3.1 or a later version
• The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
• MySQL Connector/ODBC v5.1.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
• 1 GB RAM.
Requirements for SSMA for MySQL v1.0 Extension Pack:
• SQL Server
• Microsoft Windows Installer 3.1 or a later version
• MySQL Connector/ODBC v5.1.
Requirements for the SSMA for MySQL client:
• Microsoft Windows Installer 3.1 or a later version
• The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
• MySQL Connector/ODBC v5.1.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
• 1 GB RAM.
Requirements for SSMA for MySQL v1.0 Extension Pack:
• SQL Server
• Microsoft Windows Installer 3.1 or a later version
• MySQL Connector/ODBC v5.1.
Instructions
After you download the latest version, you must extract the installation
files from before you can install SSMA for MySQL.
Installing the SSMA for MySQL
1. Extract all files from the zip file.
2. Extract installation file using preferred utility.
3. Double-click SSMA 2005/2008 for MySQL 1.0.exe.
4. On the 'Welcome' page, click Next.
5. 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.
6. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
7. Read the 'Usage Report Settings' page, select or clear the feature reporting box, and then click Next.
8. On the 'Choose Setup Type' page, click Typical.
9. 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. Extract all files from the zip file.
2. Extract installation file using preferred utility.
3. Copy SSMA 2005/2008 for MySQL 1.0 Extension Pack.exe, to the computer that is running SQL Server 2008.
4. Double-click SSMA 2005/2008 for MySQL 1.0 Extension Pack.exe file.
5. On the 'Welcome' page, click Next.
6. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
7. On the 'Choose Setup Type' page, click Typical.
8. On the 'Ready to Install' page, click Install.
9. 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.
10. Select the instance of SQL Server where you will be migrating Oracle 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.
11. 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.
12. 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.
To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.
Installing the SSMA for MySQL
1. Extract all files from the zip file.
2. Extract installation file using preferred utility.
3. Double-click SSMA 2005/2008 for MySQL 1.0.exe.
4. On the 'Welcome' page, click Next.
5. 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.
6. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
7. Read the 'Usage Report Settings' page, select or clear the feature reporting box, and then click Next.
8. On the 'Choose Setup Type' page, click Typical.
9. 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. Extract all files from the zip file.
2. Extract installation file using preferred utility.
3. Copy SSMA 2005/2008 for MySQL 1.0 Extension Pack.exe, to the computer that is running SQL Server 2008.
4. Double-click SSMA 2005/2008 for MySQL 1.0 Extension Pack.exe file.
5. On the 'Welcome' page, click Next.
6. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
7. On the 'Choose Setup Type' page, click Typical.
8. On the 'Ready to Install' page, click Install.
9. 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.
10. Select the instance of SQL Server where you will be migrating Oracle 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.
11. 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.
12. 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.
To install the utilities to another instance of SQL Server, select Yes, and then click Next. Or, to exit the wizard, click No.
Additional Information
Licensing
SSMA is a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience. To help you with the registration process, a License Key Required dialog box opens the first time that you start the SSMA program.
SSMA is a FREE download, and is available for use by any customer or partner with no charge or any obligations. However, the product requires a license key for activation. The key can be obtained after quick and simple registration. Microsoft reserves the right to use an e-mail address or phone number provided during registration in order to contact a customer regarding his/her SSMA experience. To help you with the registration process, a License Key Required dialog box opens the first time that you start the SSMA program.
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] Four-Part 쿼리 회피하기 위한 방법 Execute AT (0) | 2011.06.21 |
---|---|
[MSSQL] Top 10 Index T-SQL Statements That SQL Server DBAs Should Know (0) | 2011.06.16 |
[GeoIP] GeoIP용 쿼리... MSSQL (0) | 2011.06.14 |
[MSSQL] Replication Job 모니터링 [펌글] (0) | 2011.06.13 |
[MSSQL] 성능카운터 수집 by TYPEPERF.EXE (0) | 2011.05.27 |