VP-ASP supports the following databases
- Access 97/2000/2002 databases
- SQL Server
- MYSQL Database under Unix and Windows
Microsoft Access
VP-ASP comes with Microsoft Access 2000 database. If you want to use Access 97, we can supply a copy in that format on request. Access 2002 databases can also be used with VP-ASP.
For small to medium shops, Access is fine. It will support thousands of products. The actual performance is very dependent on many factors that include the web hosting company you are using.
A sample shop and products are included.
SQL Server
Microsoft SQL Server is a more robust database. SQL server is something you buy from Microsoft or buy the use of from your web hosting company.
Many web hosting companies charge extra for using SQL Server over using Access.
We will supply a script that creates the VP-ASP tables and the VP-ASP will automatically will handle unique SQL Server features such as date formats. We also will have support staff that can answer SQL specific questions. The script is included in the distribution package.
Configuration of SQL Server will be through the normal configuration file and no code changes will be necessary to use all features of VP-ASP Shopping Cart.
If you outgrow Access, you can switch to SQL Server with minimum effort. There are only a few VP-ASP configuration options to change. SQL Server comes with migration tool called Data Transformation Services that allow you to move data from your Access database to the SQL Server Database.
SQL Server is much more complex than Access and anyone using it should have a reasonable amount of expertise.
MYSQL
MYSQL is an alternative database system that is quite similar to SQL Server. Although MYSQL is generally used with Linux system, it is also supported by some Windows hosting provider.
The latest version of VP-ASP now supports MYSQL out of the box. To use MYSQL with VP-ASP, the server where your site is hosted must have MYSQL ODBC Connector installed.
For more information on MYSQL, please got to http://www.mysql.com