an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Migration of a Live database from 3.1 to 4
Last Post 2/5/2010 9:11:59 AM By Bahram. 4 replies.
2/4/2010 2:54:26 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Migration of a Live database from 3.1 to 4
 
What is the exact procedure of migration of a Live database from 3.1 to 4?.
 
1- Backup/Restore to New Database
2- Run Migration Script1 and script2
 
 
2/4/2010 3:05:28 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Migration of a Live database from 3.1 to 4
DotShoppingCart Staff
2/4/2010 4:07:03 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Migration of a Live database from 3.1 to 4
Look Luke
 
 Please note to my question, I am taking about database migration and not application 
  
 
 1- The database is live
 2- Source is V3.1 and SQL is 2005
 3- Target is V4 and SQL is 2008 
 
2/4/2010 4:17:32 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Migration of a Live database from 3.1 to 4
Step 2 in the link is about database migration. Migration from SQL server 2005 to server 2008 is out of scope of Dotshoppingcart. Please check SQL 2008 books online.
DotShoppingCart Staff
2/5/2010 9:11:59 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Migration of a Live database from 3.1 to 4
What I mean is DCS database migration. The script is step 2 is not complete as you remember you send me another script.