Solved

convert mssql to mysql file

Posted on 2010-11-09
5
343 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

695 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