Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment...

SSMA automates conversion of most statement. There are a few features and syntax which SSMA is unable to migrate. In such situation, SSMA issues a migration error and for each error, SSMA provides estimated manual conversion time. I often asked how do we come up with the time. Those manual estimation...

[Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2. The information provided below is still valid for SSMA for Sybase v5.2. Users should download the lastest SSMA for Sybase] This blog post explores the similarities and differences between Sybase Adaptive...

SSMA provides a project setting that allow you to customize how the conversion is done. This post describes the project setting options available for you as well as scenarios where you want to customize the setting. SSMA project setting options are categorized into the following: Project...

One of the first decisions you need to make when migrating to SQL Server is to decide whether to migrate to a schema or to a database. There may be different concept of schema between your source database product and SQL Server. Unlike Oracle, for example, schema in SQL Server is not necessarily linked...

This video provides a quick overview of planning your database migration and setting up your SSMA, including connecting to your databases and configuring SSMA project setting. Format: wmv Duration: 02:27 Check out the other videos in this series: Introduction to SSMA Planning Your...

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 the Microsoft Assessment and Planning (MAP) Toolkit...

Microsoft Assessment and Planning (MAP) is a powerful tool to inventorize, assess and report your IT asset inventory. The new version, MAP 5.5 has new features that automates discovery of heterogeneous database instances for migration to SQL Server. The tool provides network inventory reporting for MySQL...