ProductCart Shopping Cart Software Forums : Moving database from SQL 2000 TO SQL 2008 https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 19:05:29 +0000 Mon, 11 Jan 2010 13:42:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3351 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Moving database from SQL 2000 TO SQL 2008 : Thanks. Very informative article....]]> https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12574.html#12574 Author: DonnaT
Subject: 3351
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. ]]> Mon, 11 Jan 2010 13:42:07 +0000 https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12574.html#12574 <![CDATA[Moving database from SQL 2000 TO SQL 2008 : Hi Donna, I recommend reading...]]> https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12569.html#12569 Author: Hamish
Subject: 3351
Posted: 11-January-2010 at 12:06pm

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

]]> Mon, 11 Jan 2010 12:06:52 +0000 https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12569.html#12569 <![CDATA[Moving database from SQL 2000 TO SQL 2008 : Because of speed issues, I have...]]> https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12568.html#12568 Author: DonnaT
Subject: 3351
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.
]]> Mon, 11 Jan 2010 11:32:46 +0000 https://forum.productcart.com/moving-database-from-sql-2000-to-sql-2008_topic3351_post12568.html#12568