Thursday 17 December 2009

same, same… but different

These scripts will allow you to build packages from the DEP812 environment.  If you don’t run these, you won’t see the correct enterprise server when you are defining a package from the DEP812 environment.  These will rename the entfries that need to be done.

These must be run against the JDEPlan812 DB.

update dbo.f98611 set omdatp = 'NEWSERVER - Logic'
where omdatp = 'OLDSERVER - Logic' ;

update dbo.f98611 set omdatp = 'NEWSERVER - RTE'
where omdatp = 'OLDSERVER - RTE' ;

update dbo.f98611 set omdatp = 'NEWSERVER - XAPI'
where omdatp = 'OLDSERVER - XAPI' ;

update dbo.f98611 set omdatb = 'NEWSERVER - 812 Server Map '
where omdatb = 'OLDSERVER - 812 Server Map ' ;

update dbo.f98611 set omsrvr = 'NEWSERVER' where omsrvr =
'OLDSERVER' ;

update dbo.f98611 set omdatp = 'NEWSERVER - 812 Server Map'
where omdatp = 'OLDSERVER - 812 Server Map' ;

update dbo.f98611 set omdatp = 'NEWSERVER'
where omdatp = 'OLDSERVER' ;

update dbo.f986101 set omdatp = 'NEWSERVER'
where omdatp = 'OLDSERVER' ;

update dbo.f986101 set omdatp = 'NEWSERVER - Logic'
where omdatp = 'OLDSERVER - Logic' ;

update dbo.f986101 set omdatp = 'NEWSERVER - RTE'
where omdatp = 'OLDSERVER - RTE' ;

update dbo.f986101 set omdatp = 'NEWSERVER - XAPI'
where omdatp = 'OLDSERVER - XAPI' ;

update dbo.f9650 set mmmkey = 'NEWSERVER' where mmmkey = 'OLDSERVER' ;

update dbo.f9650 set mmdatp = 'NEWSERVER - 812 Server Map'
where mmdatp = 'OLDSERVER - 812 Server Map' ;

update dbo.f9651 set mdmkey = 'NEWSERVER' where mdmkey =
'OLDSERVER' ;

No comments: