Windows Server SQL via IIS - dump db contents
Posted on 2011-05-06
I'm a LAMP/MySQL person. I've barely dealt with IIS in the past, but never .asp and SQL
I have a new client that i'm converting from SQL to MySQL -- that part is okay.
I DO have access to the FTP account and have downloaded all the .asp code files, etc.
I'm hoping there's a way that i can upload a canned .asp file and use the connection string that i amazingly found in the format dsn=xxx;uid=yyy;pwd=zzz;
in order to dump the db structure and contents in SQL format, so that i can upload to create the structure and populate the db.
Does such a canned dump file exist (and is it safe?) (i cannot risk altering anything in the db)
I would delete the file thereafter - the client is not friendly with the old host/maintainer-- i'm sure you know the situation :)
I use DW CS5 which opens the .asp files VERY nicely, and the code is quite readable even tho i've never programmed in it.
Also, the host did not know if there was a dashboard or control panel for the account (the host is not good, thus the reason for the move). I thought if there was a dashboard i could perhaps find the equivalent of phpmyadmin that might have a dump-everything command. but it appears that the account is barebones.
Once i get a dump, i should be home free to begin my work in PHP and MySQL.
Thus i'm seeking an .asp dump file that's all set to go (the more automatic it is, the better!)