We help IT Professionals succeed at work.

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

topsoil
topsoil asked
on
840 Views
Last Modified: 2011-09-20
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.
Comment
Watch Question

Database Developer
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
EugeneZSQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.