In order to run the Site Store Pro shopping cart on your website, the Site Store Pro database must be setup on your webhost’s or development system’s SQL Server by “executing” the Site Store Pro SQL installation script.

The Site Store Pro database can be installed in Microsoft SQL Server 2000, 2005 or 2008 (including SQL Express Edition).

 

A database must already be setup on your SQL SERVER prior to executing the Site Store Pro SQL install script. Setting up a new database on a hosting account is usually done through the website hosting control panel or by requesting a new SQL SERVER database setup from your hosting company’s support department.

The database required to run Site Store Pro is installed by executing EITHER one of the following SQL scripts to your MS SQL Server database:

SSPRO_MSSQL_DEMO_STORE.sql

SSPRO_MSSQL_CLEAN_INSTALL.sql

The script file(s) are located in the ‘SQL_Server_Database’ folder of the Site Store Pro zip file. You only need to execute ONE (1) of the included SQL scripts.  

• Executing the SSPRO_MSSQL_DEMO_STORE.sql  script file will install the sample categories and products.
  
• Executing the SSPRO_MSSQL_CLEAN_INSTALL.sql  script file will only install the required tables and data to run Site Store Pro WITHOUT any sample products.

 

Executing the SQL script requires access to the previously setup MSSQL database via an online SQL Query tool or remote SQL Management software.

The SQL Query interface used to install the Site Store Pro tables to your SQL database will be determined by the version of SQL server you are running and if the server supports remote connections or requires a web-based SQL Query Manager to execute the installation script file.

Note:  Some webhosting companies will install the Site Store Pro tables into your SQL server database free of charge if you provide them with .sql script file.

If you need assistance installing the Site Store Pro database, please contact support@sitestorepro.com.