Student-lead MySQL primer
Ankit Bhagoliwal is a student at Poornima College of Engineering, Jaipur and a member of the OSUM community. He has written a great tutorial on how to use data from MySQL Server to help those who are restricted to using Microsoft SQL Server.
In his primer, Ankit looks at how to edit data that originated in MySQL to be used in MSSQL. He describes:
- How to remove comment lines from the script.
- The differences in the CREATE TABLE statements.
- How to convert the INVERT statements to the proper syntax.
- How to effectively clean up acute accent/reverse apostrophes around the table name, as well as the apostrophes in the text fields of data.
After completing the steps Ankit describes in detail, you can now run the script.
The great take-away from Ankit's blog is that he has shown how you can use either MySQL or MSSQL injection scripts to import any acquired databases into a system. If you use MySQL, you can simply do the process outlined in the blog in reverse to convert a MSSQL injection script into a MySQL one. As Ankit describes: "Either way, you can import data using an injection script from either of the two most popular database management systems in the world."
I strongly encourage you to read Ankit's blog on this subject. It is very well written, informative, and most importantly useful to a lot of people. Please continue to send ideas, links, and reviews to me either via OSUM or by e-mailing me at maijaliisa[dot]burkert[at]sun[dot]com.
The referred blog is a waste of time. There is no need to edit a script manually. mysqldump can do it for you.
mysqldump --compatible=mssql database_name
Read the manual: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Giuseppe
P.S. There are no INVERT statements in a SQL dump script.
Posted by Giuseppe Maxia on May 04, 2009 at 12:15 PM PDT #
Thanks for sharing your information and pointing out the article Giuseppe!
Posted by Maijaliisa Burkert on May 05, 2009 at 02:04 PM PDT #