JDBC Driver information, Creating a DS databases

•The “-S” server name option can be omitted if the script is being run on the database server itself.

•The name that you will give for the server is the server alias you created with the “client network utility.”

•The “-e” option should be omitted unless you are debugging installation problems.

•If you have DB2 installed, you may need to rename the isql.bat file in the DB2 directory to isqldb2.bat, in order to prevent conflicts.

Creating an Audit database

•If desired, have the Database Administrator edit the cr_mssqldb_audit.sql script for the correct file size and placement.

•From a DOS command line, Run the scripts with the commands:

C:>isql -S <server_name> -U sa -i cr_mssqldb_audit.sql > auditdb.log

C:>isql -S <server_name> -d <audit_db> -U sa [-e] -i audit_mssql.sql > audit.log

C:>isql -S <server_name> -d <audit_db> -U sa -i audit_data.sql > auditseed.log

Creating a Learning Management System database

•If desired, have the Database Administrator edit the cr_mssqldb_lmm.sql script for the correct file size and placement.

•From a command window, run the scripts with the commands:

C:>isql -S <server_name> -U sa -i cr_mssqldb_lmm.sql > lmmdb.log C:>isql -S <server_name> -d lmm_db -U sa [-e] -i lmm_mssql.sql > lmm.log C:>isql -S <server_name> -d lmm_db -U sa -i permission_data.sql C:>isql -S <server_name> -d lmm_db -U sa -i settings_init.sql

Creating a DS database(s)

•If desired, have the Database Administrator edit the cr_mssqldb_ds.sql script for the correct file size and placement.

•From a command window, run the scripts with the commands:

C:>isql -S <server_name> -U sa -i cr_mssqldb_ds.sql > dsdb.log C:>isql -S <server_name> -d ds_db -U sa [-e] -i ds_mssql.sql > ds.log C:>isql -S <server_name> -d ds_db -U sa [-e] -i settings_init_ds.sql

•Repeat these steps for each database instance that requires an delivery server database