• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • Last Modified:

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

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?

Hostname: 192.168.1.2
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'
0
TSFLLC
Asked:
TSFLLC
1 Solution
 
James MurrellProduct SpecialistCommented:
we once had this: in the end we purchased https://www.regnow.com/softsell/nph-softsell.cgi?item=5160-13

0
 
TSFLLCAuthor Commented:
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.
0
 
James MurrellProduct SpecialistCommented:
Agree:

Our actual problem with that error was due to collation being SQL_Latin1_General_CP1_CI_AS charset dependent
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Ephraim WangoyaCommented:
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

YOURPCNAME\INSTANCENAME
0
 
TSFLLCAuthor Commented:
ewangova,

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

Migration.jpg
0
 
Kevin CrossChief Technology OfficerCommented:
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.
0
 
TSFLLCAuthor Commented:
This is the direction I'll have to take.  Thanks.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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