Moving SQL Database to a new host

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   Hi

We are currently with 123reg for our dedicated server but we would like to move to Fasthosts

Our problem is the SQL Database, we dont want to lose the customer details and past orders.  Is there an easy way to transfer the SQL database.  I have tried making a backup to my local drive then uploading the backup to a new database but this just fails

Any ideas would be welcomed

Neil

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Justplaying Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-August-2007 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote Justplaying Report Post Thanks(0) Quote Reply Topic: Moving SQL Database to a new host Posted: 06-June-2009 at 9:46pm
	Hi We are currently with 123reg for our dedicated server but we would like to move to Fasthosts Our problem is the SQL Database, we dont want to lose the customer details and past orders. Is there an easy way to transfer the SQL database. I have tried making a backup to my local drive then uploading the backup to a new database but this just fails Any ideas would be welcomed Neil

cognecy Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 18-March-2006 Location: United States Status: Offline Points: 8	Post Options Post Reply Quote cognecy Report Post Thanks(0) Quote Reply Posted: 06-June-2009 at 10:15pm
	Niel, I have just sent a private forum message to you regarding your desire to re-locate your Database.
	Mark Shipp Cognecy Solutions, LLC Hosting/Design/Customization/Database Migration www.cognecy.com www.cognecy.co.uk

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 06-June-2009 at 10:17pm
	Moving a MSSQL database is not particularly difficult but you may not have sufficient permissions to undertake it without cooperation of your current and new hosts. Some details are here: http://wiki.earlyimpact.com/how_to/move_store?s[]=moving You need to preferably do this at a time when the store is typically quiet, if you know of such a time. If you can closely coordinate this with everyone, that is best. First, set the store to "closed" so that orders don't arrive at the old host during the transition. Ask the old host to pull a backup of the database and provide it to you. They will probably place it in a folder on your web site. Download that via FTP and upload it to the new server. Then tell the new host where to locate that backup so they may perform the procedure required to import (restore) the database to the new SQL server. Ask that this be done as soon as practical since the store on the old host is closed. Once this is done, transfer DNS. Also, assuming the new host provides a means by which you may address your site prior to DNS transfer, test the store and reverse the flag indicating the store is closed on the new host. This way when DNS does transfer, and customers find their way there, your store is open for business.