TexasHiking
Perch
I have two shared hosting accounts. One with a SQL 2000 database on it and a newer account that has the capacity for SQL 2005 databases. I need to move the contents of that SQL 2000 database to the newer SQL 2005 database. I do know about the option of performing a backup of a database through the web pages like http://mssql6.jodoshared.com/mssql/Backup.aspx but I have had very spotty performance with this and most of the time I can never get the full backup downloaded to my box, never mind the subsequent upload to the new database. As a matter of fact I keep getting "problem loading page" errors just navigating to the above URL right now.
Is it possible to get a ticket opened up so that you can perform a backup of the database from one account and put it onto the database of another account, both of which are paid for by me? This would probably be lightning fast on the internal network compared to my trying to pull and push all of the data through Texas.
If so I'd also like to know when the best time is to make this request so that it can be done as quickly as possible (i.e. when are you most staffed and not as typically busy). I can shutdown my websites with a maintenance message, get the database connection strings moved over and then bring them back up as quickly as possible.
I'd also like to do a dry run of this maneuver beforehand whereby I get the contents moved over and tested against a dev installation to make sure that the real effort later won't have any issues.
Is it possible to get a ticket opened up so that you can perform a backup of the database from one account and put it onto the database of another account, both of which are paid for by me? This would probably be lightning fast on the internal network compared to my trying to pull and push all of the data through Texas.
If so I'd also like to know when the best time is to make this request so that it can be done as quickly as possible (i.e. when are you most staffed and not as typically busy). I can shutdown my websites with a maintenance message, get the database connection strings moved over and then bring them back up as quickly as possible.
I'd also like to do a dry run of this maneuver beforehand whereby I get the contents moved over and tested against a dev installation to make sure that the real effort later won't have any issues.