StoreFront PRO also includes a separate StoreFront PRO Web Wizard and a StoreFront PRO Enable Web Utility. There are two methods for creating a StoreFront Pro web store. The first, and most common method, is to use the StoreFront Standard Web Wizard to create, build, and test the web store and then to hand off the Access database used in the standard version and have it upsized to the SQL Server. Microsoft provides tools for this process. This is useful when SQL Server isn t available for the developer but is required for the production site.
Access is less complicated to develop with as well.
StoreFront Pro includes the StoreFront 2000 Standard Web Wizard as well as the StoreFront Pro Web Wizard for this purpose. The second method is to create the SQL Server database and use the Pro web store from start to finish. StoreFront Pro includes the SQL Server folder which includes the sf2k70.sql and the sf2k65.sql scripts for use in creating the SQL Server database. The sf2k65.sql script should be used to create the SQL Server database for SQL Server 6.5 and the sf2k70.sql script should be used for SQL Server 7.0. The StoreFront Pro Web Wizard contains the scripts modified for use with SQL Server.