asked on

MSSQL to MySQL Transfer

Hi Experts,

I need to transfer a database from MSSQL to MySQL, one table at a time...

Does MSSQL or SQL Server Management Studio has such a function to produce for me a CREATE TABLE and INSERT scriots that I can just run under MySQL, like phpMyAdmin does, or do I have to create m,y own.

If I have to do it, then I guess the simplest way for me to do it is use linked tables in Access, then use the tables and fields collections, but if there an easier way?

Thank you

ASKER CERTIFIED SOLUTION

PortletPaul

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

APD Toronto

ASKER

Pat, assuming that I have created my table structures in MySQL, how would you use SQL to generate INSERT statements?

PatHartman

Link to tables in both databases. Create a query that selects data from the source system. Change the query type to append and choose the target table. run the query. Access will transfer the data. It doesn't generate an Insert statement for each row being transferred. It just does the transfer. Or, you could export to a .csv or .txt file and then import that into the other database.

APD Toronto

ASKER

PhpMyAdmin has a function to export table data as SQL query, which produces an INSERT statement for each row. My question is can that be done with any SQL or SQLServer Management Studio?

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial