Migration from SQL Server Express to MySQL 5 - No source databases in list

Posted on 2011-04-28
Last Modified: 2012-05-11
I am using the MySQL Migration Toolkit to migrate an existing SQL Express 2008 database into MySQL.

When I attempt to set up my SOURCE connection parameters with either the computer name or IP Address, and a username and password, shouldn't I be able to use 'sa' with it's valid password?

Port: 1433
Username: sa
Password: *******

I attempt to click on the ... to 'fetch a database list' and I get the following error(s)

'Fetching of list failed'
'Network error IOException:  Connection refused: connect'
Question by:TSFLLC
    LVL 31

    Expert Comment

    by:James Murrell
    we once had this: in the end we purchased


    Author Comment

    I'm simply beginning a testing phase at this point to see whether I want to use MySQL over SQL Server with an existing project.  Prefer not to spend any $$ right now.  Regardless, the Migration Toolkit shouldn't have a problem like this....just in attempting to connect.
    LVL 31

    Expert Comment

    by:James Murrell

    Our actual problem with that error was due to collation being SQL_Latin1_General_CP1_CI_AS charset dependent
    LVL 32

    Expert Comment

    Your host name is probably wrong

    I suppose you used an instance name when installing the sql server express, try this for the host name


    Author Comment


    Tried that.  No luck.
    What is the deal with a JDBC driver?

    LVL 59

    Accepted Solution

    JDBC is what the migration tool uses to connect to MS SQL from MySQL.  As far as fixing the issue, have you checked to ensure that the SQL authentication is enabled?  If installed with Windows authentication only, then it may be failing due to that.  

    Presumably, remote connections and other good stuff in SQL Server Configuration have been checked as it sounds like you were using this as your production database previously.  

    If this persists, another method to migrate is to load the MySQL ODBC driver on your MS SQL box and then export data from MS SQL to MySQL using DTS/SSIS and/or through linked server.

    Author Closing Comment

    This is the direction I'll have to take.  Thanks.

    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

    Join & Write a Comment

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now