Wrox Car Co Database Installation Instructions

The Wrox Car Co Application is built around two databases, representing the showroom (WroxCarCO) and the Head Office (WroxCarCoHeadOffice). These were developed on Microsoft SQL Server 6.5, running on two separate machines, under NT Server 4.0 and NT Workstation 4.0. There is no reason why the two databases cannot be crated on the same machine.

There are several scripts to automatically build the databases for you:

ScriptDescription
HeadOfficeBuild.batMaster script to build the head office database
HODatabase.sqlHead Office database devices and database creation SQL script
HOTablesProcedures.sqlHead Office tables and stored procedures SQL Script
HODataInsert.sqlHead Office data insertion SQL script
ShowroomBuild.batMaster script to build the showroom database
SRDatabase.sqlShowroom database devices and database creation SQL script
SRTablesProcedures.sqlShowroom tables and stored procedures SQL Script
SRDataInsert.sqlShowroom data insertion SQL script

The SQL scripts are standard SQL scripts and can be invoked from within the query window if necessary. The two batch files just combine the SQL scripts together.

You should run the batch files on the server on which you wish the databases to be created. They do not specify servers. They do, however, specify a user of sa with an empty password. This is only in the batch files so you can just change the user name and password in those if you require.