asked on

1433 - not open, trying to use MySQL Migration toolkit (MSSQL to MySQL)

hello,

i'm trying to migrate a MSSQL to MySQL. I'm using the MySQL Migration tool kits but i'm falling at the first hurdle.

as you can see from the screen shot its saying connection refused.

first of all i tried telnet 127.0.0.1 1433 and i got: "couldnt not open connection to host etc etc etc "

so then i tried netstat -an and i got loads of ports but not 1433.

so...

i went to my firewall and completly opened all connections to 1433 then i tried the above again but got the same results.

am i barking up the wrong tree, is this whats stopping me from migrating or is it somehting else. what else should i try?

thanks
zac

MYSQL-MIGRATION.jpg

Bitsqueezer

Hi,

maybe you have a named instance in the SQL Server, in this case you need to supply this, too - alternatively you could search for a port to the SQL Server which don't need to be 1433. Then you should look into the SQL Server Configuration Tool to look for the network configuration. And then you should look into the Windows Services list if the SQL Server Browser service is started which lists the instances for network accesses. SQL Server starts without that service and don't need it to run so it is not started in all cases.
Another way would be to use the SQL Server export module (only available in the full version of SQL Server Management Studio, not in the Express edition) which is really good. There is also a menu item to generate scripts from the database which can be used to adapt to MySQL.

Cheers,

Christian

Zac123

ASKER

thanks,

so here is what i have tried:

1, checked for instances via services
2, looked under SQL server configuration properties and its says is listening on port 1433
3, unfortunatly i only have sql management express.

port.jpg

Zac123

ASKER

image
sql.jpg

SOLUTION

Bitsqueezer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Zac123

ASKER

you got it! thanks so much. i followed your screen shot and it worked perfectly. i have an error now connecting to the MySQL db but i'm sure i can handle that.

thanks again.

Raja Jegan R

Welcome..
And revert if you face any issues.