ProductCart Shopping Cart Software Forums : Moving SQL Database to a new host https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 12:48:51 +0000 Sat, 06 Jun 2009 22:17:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2780 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Moving SQL Database to a new host : Moving a MSSQL database...]]> https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10150.html#10150 Author: Greg Dinger
Subject: 2780
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.
]]> Sat, 06 Jun 2009 22:17:54 +0000 https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10150.html#10150 <![CDATA[Moving SQL Database to a new host : Niel, I have just sent a private...]]> https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10149.html#10149 Author: cognecy
Subject: 2780
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.
]]> Sat, 06 Jun 2009 22:15:35 +0000 https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10149.html#10149 <![CDATA[Moving SQL Database to a new host : HiWe are currently with 123reg...]]> https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10148.html#10148 Author: Justplaying
Subject: 2780
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
]]> Sat, 06 Jun 2009 21:46:59 +0000 https://forum.productcart.com/moving-sql-database-to-a-new-host_topic2780_post10148.html#10148