Installation: Choosing your ProductCart Database

Last Updated: Jan 02, 2017 10:31AM EST

ProductCart v5 requires a MS SQL Database

ProductCart requires a MS SQL database. MS Access, MySQL or Oracle databases are not supported.

A ProductCart-powered store typically requires around 100MB of SQL storage (around 30MB upon installation, but then the figure grows as products, customers, and order data is saved to the database).

MS SQL vs. MS SQL Express


Some Web hosting companies allow you to use MS SQL Express as part of the hosting package that they offer. Please note that although MS SQL Express is perfectly fine to create a testing or development store using ProductCart, it should never be used to power a production store. MS SQL Express was never designed to support a live Web application. It was created by Microsoft as a free tool that Web developers and designers can use while creating and testing a Web application. It should only be used as such.

Make sure to setup the database right after moving the files to the server that will host the store, and before you attempt to activate the product. That is: do not run the ProductCart Setup Wizard unless you have setup the database. Otherwise you will get an error during the activation process.

If you are installing ProductCart locally on your desktop for testing or development purposes, see the section below about using MS SQL Express. If you are not comfortable setting up the SQL database:
  • If you are buying ProductCart from NetSource Commerce, you can choose the installation service before or after you purchase the software, and the SQL database will be setup for you
  • If you are buying ProductCart from a ProductCart reseller, ask them for assistance with this task


ProductCart’s SQL database has been optimized for use by small businesses. If your database contains a large number of products and other data, we recommend that you consult a database administrator (DBA) to further optimize it to achieve higher performance. As your database gets larger and larger, a good practice is to have a DBA optimize it every few months.
647e99095133bd6d1ae916f97dc7f92f@productcart.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete