Posted on 2011-10-14
Last Modified: 2012-05-12
I have a SQL 2000 database that I'd like to be able to export it & then import it into a MYSQL this possible? Can I do it for free? Or does SQL have a tool built in so I can export it so I will be able to import it to a MYSQL database?
Question by:wantabe2
    LVL 59

    Accepted Solution

    SQL 2000 can probably do this using DTS or Linked Server to MySQL. Just be aware of the data type differences and level of support for ANSI SQL and differences in syntax/behavior in general based on what all is in your database. For example, there is not a concept of a computed column or uniqueidentifer data type, etc. Remember it is schema.table and not database.schema.table, i.e., database is analogous to "catalog" in ANSI terms and mysql does not use catalog. So just ensure you have a good map of what you will have to alter in design/structure, but the data should be easy to move with one of the methods specified even if just to export to CSV/Excel and then use Import on MySQL side.
    LVL 15

    Author Comment

    I'm not that familair with MYSQL or SQL...So you are saying I should be able to export the SQL DB to a CSV then import it into the MYSQL?
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]
    if you are not familiar yourself, you likely should give the final task to someone that is experienced :)

    but to repeat above comment:
    yes, you can export your sql data in a way that it can be read with MySQL import.
    you can find the relevant MySQL reference here:

    to "export" from SQL Server into such a format, you can use sqlcmd tool (, bcp ( or the wizards (
    My experience is that you better start scripting anyhow, as you will eventually run this type of export a couple of times until it works out ...
    LVL 59

    Expert Comment

    by:Kevin Cross
    Data. But I would look first to direct transfer using DTS or Linked Server. Both use the connectors provided by MySQL.

    P.S. If you are not familiar with MySQL, why are you moving that direction if you don't mind my asking? I use both, so I am really just curious. With the free edition of SQL Server, you can transition more seamlessly from where you are today if either system will be a learning curve. The advantage is that if you have to learn SQL 2000, learning SQL 2008 R2 won't be far off. Whereas moving to a new DBMS, you will have to learn SQL 2000 plus the new system whether that is MySQL or otherwise.
    LVL 15

    Author Comment

    It's because I legacy applications we use & there is a real need for the upgrade to new hardware & we don't have the new $$$ for SQL license. It has to run on full blown SQL or MySQL....
    LVL 59

    Expert Comment

    by:Kevin Cross
    Okay. The suggestions above should apply. I was just curious as if the features of full blow SQL are not absolutely required as evidenced by being able to move to MySQL, then I would think SQL Express Edition would be just as good. Anyway, given you have no choice. I would use references provided by a3 to familiarize yourself. Note: SSIS is SQL Server's replacement of DTS. So, specifically with Import/Export Wizard, you will find that information informative to you in some ways even though it is for SQL 2005 and higher. And as a3 asserts, it will likely take more than one attempt because of some of the things I spoke of earlier like data type changes.

    The advantage you have is if your vendor supports both, then you should already have data structure setup for MySQL, right? That alleviates that piece and you just have to move data from one structure to the other. Additionally, if your application vendor supports both SQL 2000 and MySQL, they likely have scripts or migration processes to go between platforms, so it may not hurt to ask, especially if you are unfamiliar with either side of the equation.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now