I have a client who I hosted with Communitech (fantastic company) which was bought out by Interland which is not so fantastic.
I need to grab the entire database and put it on my server which has MYSQL suppot.
To get the data I only have command line access to the DB. And on my new host they have a shared SQL server.
Ideally I could find a way to transfer the data to an interim database and then re-create that database on the other server and copy the data there.
What are some suggestions as to what you think the easiest way to accomplish this is?
The database is small so I am thinking of re-creating the structrue in Access, then creating PHP pages to dump the data (lucky the amount data is resonably small) to the screen and paste it into excell. Then import the excell data into Access. Then just dump the Access data into SQL Server via enterprise manager on my new server and change the couple of pages with the command lines to open the SQL database instead.
What are your thoughts? Is there an easier way? I have MySql, ODBC and SQLServer access on my web host.
If you want to export from MySQL and then import into MSSQL, you have to first create a dump file from MySQL (using the mysqldump) command.
From Enterprise Manager, you can connect to your MSSQL server, then import the SQL file (from the same place you restore backups). The only difference is, instead of restoring from a backup set, you will be restoring from a file. There is an option there that does this, because I had a similar situation.
I'm not at a computer that has Enterprise Manager installed, so I can't give you the exact steps to follow. There are also command line tools that come with MSSQL that allow you to import SQL files.
In order to understand recursion, one must first understand recursion.
If you feel like it, you can read my blog
Signal > Noise