THIS DATABASE IS FOR TESTING and LEARNING ONLY. USE AT YOUR OWN RISK AND INSTALL ON TEST SERVERS ONLY (just common sense :). MICROSOFT AND ANY SPEAKERS WHO USE THIS DATABASE ARE NOT "SUPPORTING" THIS DATABASE.

HAVING SAID THAT - It's a fun database for learning so have fun! This directory contains the files used to create and populate the credit database used by a variety of courses as well as by speakers at conferences. fyi - I'm not aware of anyone using this on a case sensitive server so there are probably mis-matched case issues. 

************************
***** INSTRUCTIONS *****
************************

You have two options for installing this Credit Database - you can use the scripts OR you can restore the backup. The backup has some slightly different index strategies and it also has a larger Charge table (1.6 million rows instead of only 100,000).

****** Option #1 ******

Credit Database Build Directory
To install the credit database you will run the install.bat batch file. There is only one cause for concern. 

The database is created with CREABASE.SQL. This file MUST be modified IF either of the two is NOT TRUE.
(1) SQL Server must have been installed in the default directory of: C:\PROGRAM FILES\MICROSOFT SQL SERVER\ and the data directory under MSSQL\DATA.
(2) You are installing CREDIT to the default instance. If you have a named instance then you must change the directory to reflect the named instance's name of MSSQL$InstanceName\Data.

Other than that this database should install easily.

****** Option #2 ******

Use the CreditBackup80.zip to unzip and then restore. Make sure to restore with move - if necessary. This version of the Credit Database has these properties:

File 1		FileName
CreditData 	c:\Program Files\Microsoft SQL Server\MSSQL\Data\CreditData.mdf
		Filegroup	Size		MaxSize		Growth	Usage
		PRIMARY		512000 KB	Unlimited	10%	data only

File 2		FileName
CreditLog	c:\Program Files\Microsoft SQL Server\MSSQL\Data\CreditLog.ldf
		Filegroup	Size		MaxSize		Growth	Usage
		NULL		198400 KB	Unlimited	10%	log only

Have fun!