Link to home
Start Free TrialLog in
Avatar of topsoil
topsoil

asked on

Script to export MS-SQL database so it can be imported later to a MySQL database

I currently have a database on my webhost under MS-SQL. I would like to export the data, so that it can be transfered over to a new webhost, who uses MySQL.

My current webhost does allow me to run cgi scrips (perl, and python), as well as ASP.

Basically, I'm looking for a script of some kind that will export the data from an entire MS-SQL database, to the same format as phpmyadmin Export feature uses for MySQL databases. I then hope to just import the data to the new MySQL server using phpmyadmin.

Unfortuantely, I do not have physical access to the machine, nor do I have remote desktop capabilities, so anything I use will need to be uploaded via ftp and run through the webserver.
ASKER CERTIFIED SOLUTION
Avatar of D B
D B
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial