ProductCart Shopping Cart Software Forums : MS SQL Express Server https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 12:47:25 +0000 Tue, 13 Oct 2009 20:40:31 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3099 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[MS SQL Express Server : Thanks for the quick replies. Advice...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11620.html#11620 Author: RobertZ
Subject: 3099
Posted: 13-October-2009 at 8:40pm

Thanks for the quick replies.

Advice taken. Found a host with VPS and a MSSQL DB, which is not included Express Server.

Thanks again.

Rob
]]> Tue, 13 Oct 2009 20:40:31 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11620.html#11620 <![CDATA[MS SQL Express Server : We have multiple VPSes running...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11598.html#11598 Author: JoltDigital
Subject: 3099
Posted: 12-October-2009 at 11:34am

We have multiple VPSes running sql2k8 web edition without issues. However we do set up any productcart db to use sql2k5 compatablity. That should have been mentioned.]]> Mon, 12 Oct 2009 11:34:28 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11598.html#11598 <![CDATA[MS SQL Express Server : I do not recommend using SQL2008...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11597.html#11597 Author: cognecy
Subject: 3099
Posted: 12-October-2009 at 11:21am

I do not recommend using SQL2008 for ProductCart at this time.  Do not get me wrong I have seen it work but there are some compatibility issues between the architecture of the ProductCart DB and the architecture of SQL2008.  
 
Here is s detailed thread I posted a few months ago that talks to this point.
 
http://www.earlyimpact.com/forum/forum_posts.asp?TID=2980&KW=


Edited by cognecy - 12-October-2009 at 11:22am]]> Mon, 12 Oct 2009 11:21:33 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11597.html#11597 <![CDATA[MS SQL Express Server : See if your provider offers sql2k8...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11596.html#11596 Author: JoltDigital
Subject: 3099
Posted: 12-October-2009 at 11:04am

See if your provider offers sql2k8 web edition. It is only ~$20 month and does not suffer from the connection limitations or db size limitations of express.]]> Mon, 12 Oct 2009 11:04:11 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11596.html#11596 <![CDATA[MS SQL Express Server : Hello RobertZ, Your question...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11592.html#11592 Author: cognecy
Subject: 3099
Posted: 12-October-2009 at 12:06am

Hello RobertZ,
 
Your question is a bit open-ended but I will give you a definitive answer ... 
 
Can you use MSSQL Express with ProductCart?  Yes you can
 
Should you use MSSQL Express with ProductCart?  Absolutely and unequivocally NO!!!
 
MSSQL Express is a scaled down version of MSSQL Server but do not think that is the same as having the WorkGroup or Standard edition as it is not.  There are many things missing form the Express version the least of which being maintenance plans to keep your DB running smooth.  The Express version is meant for nothing more than a Development database or a personal database at best.
 
I have been working on the ProductCart Database for many years and I have seen people try to use this DB and some even claim that it is working fine for them (misguided as they may be).   If you are serious about your online business do not take shortcuts (you will thank me later for that advise).
 
If you are going into a VPS chances are that you may still have access your your hosting provider's shared services.  I would definitely ask them about this and see if you can still use their shared MSSQL 2005 server (and also get the benefit of having a management team that is taking care of that server to keep things running smooth).
 
 


Edited by cognecy - 12-October-2009 at 12:09am]]> Mon, 12 Oct 2009 00:06:45 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11592.html#11592 <![CDATA[MS SQL Express Server : Hi Looking for a bit of advise. We...]]> https://forum.productcart.com/ms-sql-express-server_topic3099_post11591.html#11591 Author: RobertZ
Subject: 3099
Posted: 11-October-2009 at 11:48pm

Hi
Looking for a bit of advise.

We are moving from a shared hosting environment to a VPS server, but MS SQL isn't the full version. Its the cutdown SQL Express Server.

Will this work? + Any advise running PC on this instead of the normal MSSQL2005.

I've looked everywhere inside EI for info but cant find anything that refers to a production environment rather than a testing environment.

Thanks

Rob
]]> Sun, 11 Oct 2009 23:48:49 +0000 https://forum.productcart.com/ms-sql-express-server_topic3099_post11591.html#11591