Database movement from Tier 1 to Tier 1

July 14, 2020 53 words One minute

Contents

In GOLD, export GOLD bak file
In MIG, stop all services: Batch, DIXF, MR
In MIG, backup AXDB MIG
in MIG, AxDB to AxDB_Orgi
In MIG, Create AxDB_New
In MIG,resotre GOLD to AxDB_New
AxDB_Gold to AxDB
Start all the services and resett IIS in LCS
DB Sync

1
2
3
4
5


ALTER DATABASE AxDB SET Single_user With Rollback immediate
alter database AxDB Modify name = AxDB_Orig
alter database AxDB_Orig SET MULTI_USER
alter database AxDB_Gold Modify name = AxDB
select * from [USERINFO] 