Using ProductCart - Moving database from SQL 2000 TO SQL 2008

Print Page | Close Window

Moving database from SQL 2000 TO SQL 2008

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3351
Printed Date: 01-March-2025 at 3:23am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Moving database from SQL 2000 TO SQL 2008

Posted By: DonnaT
Subject: Moving database from SQL 2000 TO SQL 2008
Date 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.

Replies:

Posted By: Hamish
Date Posted: 11-January-2010 at 12:06pm

Hi Donna,
I recommend reading post http://www.earlyimpact.com/forum/forum_posts.asp?TID=2980 - http://www.earlyimpact.com/forum/forum_posts.asp?TID=2980

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: DonnaT
Date 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.