Hello, David,
I made this separation. Piece of cake, provided you prepared a very accurate
and thorough plan, including a backup
We have two systems. From time to time I refresh my test system with the
production data. Check the KG for documents like 'Changing deployment
server', etc. For table updates you can use my script. It worked fine in
B7332 release. I think it will work in XE as well, but I do not guarantee.
The database name is the same for both systems. If you are going to have
different ones, check other columns of the tables. Should you have two
servers in your system you will have to delete some records. You will have
to update JDE.INI files on both servers, including jde.ini in misc
directory. You will have to update access files on the deployment server as
well.
The script itself:
update sysb733.f00942 set emmkey='HQNTERP2' where EMMKEY='HQNTERP';
update sysb733.f00945 set rmmkey='HQNTERP2' where RMMKEY='HQNTERP';
update sysb733.f00945 set RMJOBN ='HQNTERP2' where RMJOBN ='HQNTERP';
update prodb733.F983051 set vrmkey='HQNTERP2' where vrmkey='HQNTERP';
delete objb733.f9861 where simkey='HQNTERP2';
update objb733.f9861 set simkey='HQNTERP2' where simkey='HQNTERP';
update SVMB733.F986110 set JCEXEHOST='hqoradev' where JCEXEHOST='hqoraprod';
update sysb733.f98611 set omsrvr='hqoradev' where omsrvr='hqoraprod';
update sysb733.f98611 set OMDATP='HQORADEV' where OMDATP='HQORAPROD';
update sysb733.f98611 set OMDATP='HQORADEV - B733 Server Map' where
OMDATP='HQORAPROD - B733 Server Map';
update sysb733.f98611 set OMDATP='HQORADEV - Logic' where OMDATP='HQORAPROD
- Logic';
update svmb733.f98611 set OMSRVR='hqoradev' where OMSRVR='hqoraprod';
update svmb733.f98611 set OMDATP='HQORADEV' where OMDATP='HQORAPROD';
update sysb733.f986101 set OMDATP='HQORADEV1' where OMDATP='HQORADEV';
update sysb733.f986101 set OMDATP='HQORADEV' where OMDATP='HQORAPROD';
update svmb733.f986101 set OMDATP='HQORADEV' where OMDATP='HQORAPROD';
update sysb733.f986101 set OMJOBN='HQNTERP2' where OMJOBN='HQNTERP';
update sysb733.f9650 set MMMKEY='hqoradev' where MMMKEY='hqoraprod';
update sysb733.f9650 set MMMKEY='HQNTERP2' where MMMKEY='HQNTERP';
update sysb733.f9650 set MMDATP='HQORADEV - B733 Server Map' where
MMDATP='HQORAPROD - B733 Server Map';
Good luck.
Regards, Alex Shevchenko
XE SP18 Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test