[Updated 2/7/2012 Selina Jia- Microsoft SQL Server Migration Assistant (SSMA) for Access v5.2. The information provided below is still valid for SSMA for Access v5.2. Users should download the lastest SSMA for Access] In this blog post I’ll walk...

One common challenge for a migration project is for a DBA to give password to access a database that he/she owns. This article shows an approach where DBA can keep the password while allowing a separate migration team to run assessment and migration....

The next version of the Microsoft Assessment and Planning (MAP) Toolkit—version 5.5— is now available for free download. · Download MAP 5.5 Simplify planning for migration to the latest Microsoft products and technologies with...

You may run into issue when using SSMA to connect to Oracle database containing foreign characters (non-ASCII characters) in its schema. In the example below, we have an Oracle database containing a table with Japanese name: The issue is caused...