Note : Download White Papers by Microsoft
Guide to Migrating from MySQL to SQL Server 2005
This migration guide explains the differences between the MySQL and SQL Server 2005 database platforms, and the steps necessary to convert a MySQL database to SQL Server.
Guide to Migrating from Oracle to SQL Server 2005
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms.
Guide to Migrating from Sybase ASE to SQL Server 2005
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2005. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant for Sybase, the best tool for this type of migration, can help resolve various migration issues.
Guide to Migrating from Microsoft Access to SQL Server 2005
This white paper covers migrating Microsoft Access databases to SQL Server 2005 and discusses the differences between the two platforms. SQL Server Migration Assistant for Access (SSMA Access) is the best tool for this type of migration; this paper tells you how to use it to mitigate potential problems in database conversion.
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)
I downloaded SSMA Tool and installed it. It is free. But i m not able to register.
I followed the following instructions :
Start Menu -> Program Files -> Microsoft SQL Server Migration Assistant for Access -> Microsoft SQL Server Migration Assistant for Access -> A License Management dialog box appeared -> Browse the Path ‘C:\Program Files\Microsoft SQL Server Migration Assistant for Access’ to License directory -> followed the Instruction .
But i did not received any Registration key.
I clicked on Refresh License and got a message “Failed to refresh license key. Check the directory or download the key again. ”
What should i do now? Please help me.
Is there any SSMA available for MySQl to SQL Server? DS works good for Tables and views. I am facing trouble in converting Procedures and Function because of huge number of them and complex once.
Any other tool or approach is welcomed too.
Thanks n Regards,