There are several scripts to automatically build the databases for you:
Script | Description |
HeadOfficeBuild.bat | Master script to build the head office database |
HODatabase.sql | Head Office database devices and database creation SQL script |
HOTablesProcedures.sql | Head Office tables and stored procedures SQL Script |
HODataInsert.sql | Head Office data insertion SQL script |
ShowroomBuild.bat | Master script to build the showroom database |
SRDatabase.sql | Showroom database devices and database creation SQL script |
SRTablesProcedures.sql | Showroom tables and stored procedures SQL Script |
SRDataInsert.sql | Showroom 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.