Moving database from SQL 2000 TO SQL 2008

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


   Because of speed issues, I have decided to move my ProductCart store from a Win 2003 server to a Win 2008 server with the same service provider. The service provider does not move databases so it is therefore up to me to do this. Questions:
-  can I simply back up my current SQL database, restore it to the new database on the 2008 server and then change the storeconstants file to reflect the new database name or are there other steps involved? 
- I currently have a SQL 2000 database but have the option of upgrading to a SQL 2008 server with my new plan. If I decide to go this route, can I simply backup my 2000 database and restore it to the new 2008 database  or will this cause problems? 
Any advise prior to starting this would be greatly appreciated.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
DonnaT Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote DonnaT Report Post Thanks(0) Quote Reply Topic: Moving database from SQL 2000 TO SQL 2008 Posted: 11-January-2010 at 11:32am
	Because of speed issues, I have decided to move my ProductCart store from a Win 2003 server to a Win 2008 server with the same service provider. The service provider does not move databases so it is therefore up to me to do this. Questions: - can I simply back up my current SQL database, restore it to the new database on the 2008 server and then change the storeconstants file to reflect the new database name or are there other steps involved? - I currently have a SQL 2000 database but have the option of upgrading to a SQL 2008 server with my new plan. If I decide to go this route, can I simply backup my 2000 database and restore it to the new 2008 database or will this cause problems? Any advise prior to starting this would be greatly appreciated.

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 11-January-2010 at 12:06pm
	Hi Donna, I recommend reading post http://www.earlyimpact.com/forum/forum_posts.asp?TID=2980
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

DonnaT Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 24-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote DonnaT Report Post Thanks(0) Quote Reply Posted: 11-January-2010 at 1:42pm
	Thanks. Very informative article. This is exactly the type of info that I needed. I will stay with SQL 2000 for now.