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

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

 

 

Begin Section

End Section

/*********************************************/ /* 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

Change to your default path

Figure 136. Example of the DB_SQLSRVR70.SQL Script

190J.D. Edwards’ OneWorld B73.3 and Windows Terminal Server

Page 202
Image 202
IBM B73.3 manual Database Name Environments That Require This Database, Begin Section End Section