[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

convert mssql to mysql file

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
attipa
Asked:
attipa
  • 3
  • 2
1 Solution
 
Kim RyanIT ConsultantCommented:
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
 
attipaAuthor Commented:
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
 
Kim RyanIT ConsultantCommented:
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
 
attipaAuthor Commented:
used a software which i purchased here: http://dbconvert.com/convert-mssql-to-mysql-pro.php

worked like a charm!
0
 
attipaAuthor Commented:
i did additional research myself and it worked great!  i wasn't able to get the answer from anyone.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now