Sunday, January 30, 2011

Restoring AX Database From One Environment to Another


When you restore a database from a production environment to a test / dev environment, you should run these scripts to ensure that your database is synchronized with the Application environment and proper object server.
Here are some samples scripts you should run:
Select * from BatchServerGroup
–Update BatchServerGroup set SERVERID = ’01@NewAOS’ where SERVERID = ’02@OldAOS’
Select * from BATCHSERVERCONFIG
–Update BATCHSERVERCONFIG set SERVERID = ’01@NewAOS’ where SERVERID = ’02@OldAOS’
Select * from SYSCLUSTERCONFIG
select * from SYSSERVERCONFIG
–Update SYSSERVERCONFIG set SERVERID = ’01@NewAOS’ where SERVERID = ’02@OldAOS’
Select * from SYSSERVERSESSIONS
–Update SYSSERVERSESSIONS Set AOSID = ’01@NewAOS’, Instance_Name = ’01′ where AOSID = ’02@OldAOS’
Select * from Batch
–Update BATCH set SERVERID = ’01@NewAOS’ where SERVERID = ’02@OldAOS’
select * from SYSCLIENTSESSIONS
–delete SYSCLIENTSESSIONS
Beside these, you should also check the Dynamics database for Enterprise Portal, Analytical Server BI setup and reporting server configuration. This could be done through SQL Server access or trough AX Administration setup.
Post a Comment