Microsoft is Making a Play for MySQL Users

Posted by Jonathan Allen on Jan 19, 2010

Sections

Operations & Infrastructure,

Architecture & Design

Topics

SQL Azure ,

SQL Server 2005 ,

SQL Server 2008 ,

Azure ,

SQL Server ,

MySQL ,

Relational Databases ,

.NET ,

Database Design ,

Microsoft ,

PaaS ,

Architecture ,

Database ,

Programming ,

Cloud Computing ,

Companies

Share |

RELATED Research

Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.

Migrating from MySQL to SQL Server consists of a three-step process. The first step is to convert the schema from MySQL to SQL Server syntax. Then you can create a new SQL Server database and load the converted schema. After verifying the new schema using their side-by-side metadata explorer, you can use the tool to migrate the data itself.

CTP1 version only supports tables, indexes and constraints. According to Denis Vnukov, Microsoft Program Manager, support for stored procedures, functions, triggers and views will be included in final version.

You can download CTP 1 from Microsoft Downloads. Migration tools are also available for Access, Oracle, and Sybase.

RelatedVendorContent

Introducing SQLFire: a memory-optimized, high performance SQL database

Automating Error Reporting for .NET Applications

Visual Studio vNext: ALM features for Agile Planning, Team Collaboration

Want to know how software releases can be stress-free and happen with one click? Try Go free!

Improving Software Delivery Cycles: Pre-requisites and Inhibitors

Related Sponsor

Go: Agile Release Management Solutions. Go enables predictable, defect-free and timely software releases.