MySQL Forums
Forum List  »  Microsoft SQL Server

Exporting data to MSSQL (using a new XSL based Tool)
Posted by: Tony Tromp
Date: October 08, 2010 09:12PM

Hi Everyone,

In one of my projects i needed to export data to Microsoft SQL Server on regular basis (reporting).
Thus the SysDBA's had i nightmere sorting out the datatype differences, so i decided to help them out a little.

Since mysqldump already had an XML output feature (-X), i rolled up some XSL's to auto-generate the appropriate CreateTables.sql and InsertData.sql files.

If you ever need them, i've uploaded them for you to share:
https://sourceforge.net/projects/mysql-to-mssql/

Cheers,
Tony

Options: ReplyQuote


Subject
Written By
Posted
Exporting data to MSSQL (using a new XSL based Tool)
October 08, 2010 09:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.