Ask the Expert

Moving from MS SQL to MySQL all by myself

Slowly, my company (150 users) is moving to Linux. We want to get off of MS SQL, but the migration task seems like a big deal for a 1-person (me) IT shop. If we chose MySQL, would we lose any functionality or data? Am I going to be able to handle this alone?

    Requires Free Membership to View

A loss of data should not occur if the job is done properly. Functionality may be difficult to move, depending on the amount of stored procedures in your database. MySQL 5 has stored procedures, but MySQL follows the PL/PSM standard for stored procedures, and MSSQL uses T-SQL. While the two standards are similar in a lot of ways, you may find youself having to modify the MSSQL stored procedures to get them working with MySQL.

You can use the MySQL Migration Toolkit to help move your data and schema from MSSQL to MySQL, and I would recommend reading an article I wrote on migrating MSSQL and Microsoft Access databases to MySQL. In addition, I delivered a presentation on migrating MSSQL and Microsoft Access databases to MySQL, and you can view the presentation materials here.

This was first published in May 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: