Dropping SQL Server Databases
For uninstalling, you must drop the SQL Server databases that were created by the JD Edwards EnterpriseOne installer prior to uninstalling the Platform Pack. If you fail to drop the databases before you run the Platform Pack installer, and then you subsequently reinstall JD Edwards EnterpriseOne Release 9.2, the Microsoft Windows operating system will delete the databases the next time the machine is restarted.
This section lists the SQL Server databases that must be manually dropped by a DBA. This is the list of databases that were created by the JD Edwards EnterpriseOne Release 9.2 installation of the Platform Pack on your Enterprise or Database Server for your JD Edwards EnterpriseOne installation, or from a previous JD Edwards EnterpriseOne installation.
Z:\JDEdwards\MSSQL\Scripts
The names of these
scripts
are:SQL_drop_db.bat
Drop_users.bat
(Caution: This script should only be used for new installations. It should not be
used for upgrades.By design, these databases are not automatically removed by the JD Edwards EnterpriseOne uninstallation program. You should have a DBA for your RDBMS manually remove any unused databases listed in the table below.
JD Edwards EnterpriseOne Component |
SQL*Server Database Name |
JD Edwards EnterpriseOne Purpose |
---|---|---|
Foundation |
JDE910 |
System Object Librarian Data Dictionary Server Map |
Production |
JDE_PD910 |
Production Object Specifications
|
JDE_PRODUCTION |
Production Data Production Control Tables |
|
Pristine |
JDE_PS910 |
Pristine Object Specifications
|
JDE_PRIST920 |
Pristine Data Pristine Control Tables |
|
Development |
JDE_DV910 |
Development Object Specifications
|
JDE_DEVELOPMENT |
Development Data Development Control Tables |
|
Prototype |
JDE_PY910 |
CRP Object Specifications
|
JDE_CRP |
CRP Data CRP Control Tables |