Solved

convert mssql to mysql file

Posted on 2010-11-09
5
342 Views
Last Modified: 2012-06-27
Hi,

I have a db on Microsoft SQL Server 2005.  I need to output and convert the entire db to mysql.  A lot of software i have found out there makes you connect to both servers...I don't want to connect to the mysql server.  Is there something i can use where i connect to the ms sql server and it outputs a file i can then take over to mysql?

Thanks!
0
Comment
Question by:attipa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Kim Ryan
ID: 34098030
Yes, all databases let you export meta data (the table definitions)as ANSI SQL statements  The data itself can be  exported as SQL INSERT statements, to a text file such as comma seperated values.

Mysql can import the CSV values with the mysqlimport program.
0
 

Author Comment

by:attipa
ID: 34098231
yes, but this db is pretty large...that's why i was asking if there is a program that will do everything for me.
0
 
LVL 19

Expert Comment

by:Kim Ryan
ID: 34100448
I haven't heard of a program that can do everything. If the database is large it may only be practical to split it into 2 steps. Unload the data to a CSV file and then import it into MySQL.You often get errors on import as the data types between the two databses don't always match, so a bit of trial and error is involved.
0
 

Accepted Solution

by:
attipa earned 0 total points
ID: 34208219
used a software which i purchased here: http://dbconvert.com/convert-mssql-to-mysql-pro.php

worked like a charm!
0
 

Author Closing Comment

by:attipa
ID: 34228760
i did additional research myself and it worked great!  i wasn't able to get the answer from anyone.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Creating and Managing Databases with phpMyAdmin in cPanel.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question