Using ProductCart - Using MSSQL 2008

Print Page | Close Window

Using MSSQL 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=5549
Printed Date: 04-October-2024 at 12:14pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Using MSSQL 2008

Posted By: Leather_Treaty
Subject: Using MSSQL 2008
Date Posted: 25-March-2013 at 6:16pm

Hello,

moving my websites and Product Cart to a dedicated server. They provide MSSQL 2008 Server Express for free. Will Product Cart function on this or do I need to buy a full version of MSSQL 2008?

Thank you,

Gary

Replies:

Posted By: whizzinpc
Date Posted: 25-March-2013 at 11:16pm

It will work fine. You can just backup the database then restore in 2008.

Posted By: Greg Dinger
Date Posted: 25-March-2013 at 11:35pm

I'm going to debate that one by referring to Mark's post in 2010. I really trust Mark's judgment on database issues.

http://www.earlyimpact.com/forum/forum_posts.asp?TID=3983&KW=Server+Express&PID=15530&title=sql-express#15530

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: cognecy
Date Posted: 26-March-2013 at 1:19am

Do not run your ProductCart store on an SQL Express database. Please refer to my earlier posting that Greg mentioned.

SQL Express is a development database only! Know this advice not only comes from several Certified ProductCart Developers such as myself, Greg, and others, but also from Early Impact and Microsoft's own recommendations as can be seen in their DB Comparison chart.

Although Express is built on the same SQL engine it is absolutely not the same database as the full version and is far too limiting to be run as a production DB.

Please open a private conversation with either Greg or myself and we will explain in detail.

-------------
Mark Shipp
Cognecy Solutions, LLC
Hosting/Design/Customization/Database Migration
www.cognecy.com
www.cognecy.co.uk