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