SQL 2000 to MySQL

Posted on 2007-07-25
Last Modified: 2012-08-14
I need to convert a SQL 2000 Enterprise database to a MySQL database. when i export it as an access database, there are too many fields.  is there any sort of converter out there that will take it from one to the other without having to go to access first?  
Question by:HunTelWebProgrammer
    LVL 14

    Accepted Solution

    Try this link:

    download it and use this.

    Hope it helps.
    LVL 14

    Assisted Solution

    LVL 2

    Assisted Solution

    There maybe a lot of utilities out there which take pain and guess work out of such database migrations. many are Sharewares and many are freewares. Based on your budget you can choose to use any.
    I prefer to do such migrations the hard way.
    First database table, and view creation in all database vendors would be same.
    The stored procedures however may require a few changes if the vendors are different which in your case is true.
    SQL server allows you to export data from all tables into flat files. These exports happen on a table by table basis which means you can export only one table to a flat file at a time. If you are systematic in your approach you can export all the tables in your database accordingly.
    SQL server also provides a feature to Generate Scripts as another database level task. You can use this to generate Table and View creation scripts which can be run without much modifications in any other vendors database.
    Once you have your views and tables created its just a matter to doing a bulk import into the other database.
    This is definitely not a straight forward approach but if you want to remove all guess work from you migration, this is the approach I suggest.
    Hope this helps.

    LVL 1

    Author Comment

    I tried the software suggested by chinu.. converted sucessfully, but program using the DB didn't like the info after the conversion at all. I ended up having to recreate it :(  thanks for all your help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    761 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

    7 Experts available now in Live!

    Get 1:1 Help Now