IBM J.D. EDWARDS' ONEWORLD B73.3 - Manual (Page 202)

190 J.D. Edwards’ OneWorld B73.3 and Windows Terminal Server
3. The database creation script is in the \Oneworld\B733\Database folder. The
name of the script is DB_SQLSRVR70.SQL (shown in Figure 136 on page
190).
4. Review the script and edit the paths (default path is z:\mssql) and verify that
the directory you are specifying exists in the enterprise server. For our
example, we changed z:\mssql to d:\mssql7 (d:\mssql7 is where SQL Server
7.0 exists on the enterprise server).
5. Delete the sections of the script you do not need; do not delete the section for
JDE_PRISTINE. The pristine specifications are completely replaced, and this
database is required. The script is clearly marked to identify easily which
sections of the script to delete completely. Use Table 17 to help decide which
database name and associated environment you can delete. For our example,
we deleted JDE_DEVB733 and JDE_DEVELOPMENT.
Table 17. Database Names and Associated Environments
Figure 136. Example of the DB_SQLSRVR70.SQL Script
Database Name Environments That Require This Database
JDEB733 All environments
JDE_CRPB733 CRP733
JDE_CRP CRP733
JDE_PRISTB733 PRT733
JDE_PRISTINE PRT733
JDE_PRODB733 PRD733
JDE_PRODUCTION PRD733
JDE_DEVB733 DEV733
JDE_DEVELOPMENT DEV733
/*********************************************/
/* Create JDEB733 Database and its devices */
/* Needed for all installations and upgrades */
/* except AS/400 */
/*********************************************/
use master
GO
CREATE DATABASE JDEB733
ON
( NAME = ’JDEB733_Data’, FILENAME = ’z:\mssql\jdeb733data.mdf’, SIZE = 300,
MAXSIZE = 500MB, FILEGROWTH = 5MB )
LOG ON
( NAME = ’JDEB733_log’, FILENAME = ’z:\mssql\jdeb733log.ldf’, SIZE = 30,
MAXSIZE = 50MB, FILEGROWTH = 5MB )
GO
sp_dboption JDEB733, ’select into/bulkcopy’, TRUE
go
sp_dboption JDEB733, ’trunc. log on chkpt.’, TRUE
go
use JDEB733
End Section
Begin Section
Change to your default path