Updated: July 12, 2020 (May 9, 2011)

SQL Server Migration Assistants Updated

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... more

Updated database migration tools to help users of Access, Oracle, MySQL, and Sybase migrate to SQL Server are now available for free download. All tools support migration to SQL Server Denali, expected late this year, and feature improved performance during data migration. The tools could help customers standardize multiple database platforms onto SQL Server in order to reduce duplication of data and personnel, and could lower infrastructure costs by letting them move on-premises data storage to the SQL Azure service.

Moving to SQL Server 2005 or Later

The SQL Server Migration Assistants help users move their existing databases to SQL Server 2005, 2008, 2008 R2, and now SQL Server Denali by converting or migrating data, stored procedures, and other database objects from the source database to SQL Server. The assistants for MySQL, Access, and Sybase also support migration to SQL Azure, a Microsoft-hosted database management service based on SQL Server. The assistant for Access allows tables to be linked directly from Access 2010 to SQL Azure, with no application modification necessary.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now