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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.