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
APD TorontoSoftware DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulEE Topic AdvisorCommented:
see: http://www.mysql.com/products/workbench/migrate/
Most dbms products have migration tools to help migrate INTO their product

So you don't have to create your own scripts (and there will be more available than just the above) but migrations typically aren't  simple (but this depends on the complexity of the databases).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
Assuming the DDL to create tables is the same or similar in MySQL to SQL Server, then you can use SQL server to generate the create statements.  Once the MySQL database is created, you can use Access to link to both databases and use append queries to copy from SQL Server to MySQL.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're looking for something that's ready to go, then you might consider Convert-IN. I've used the products from Convert-IN in previous projects, and they work very well, and are inexpensive (around $50 US). I converted from Access to MSSQL and MYSQL, and each went off without a hitch. There was still work to be done on the FE, of course, but the database conversion was done with just that tool.

http://convert-in.com/sql2mss.htm
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

APD TorontoSoftware DeveloperAuthor Commented:
Pat, assuming that I have created my table structures in MySQL, how would you use SQL to generate INSERT statements?
0
PatHartmanCommented:
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.
0
APD TorontoSoftware DeveloperAuthor Commented:
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?
0
Dave BaldwinFixer of ProblemsCommented:
You might try Adminer http://www.adminer.org/ .  Version 3/4 is supposed connect to MS SQL but it crashes on my old computer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.