Link to home
Start Free TrialLog in
Avatar of Sekar Chinnakannu
Sekar ChinnakannuFlag for Singapore

asked on

ADMT Database move to new server. Need help to know the steps to perform pre and post check.

ADMT Database move to new server. Need help to know the steps to perform pre and post check.
Need help on basic sql queries to check the status\data on the ADMT DB too.
ASKER CERTIFIED SOLUTION
Avatar of Mahesh
Mahesh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sekar Chinnakannu

ASKER

Thanks Mahesh.
It's a full sql server, Could you please help me to get some basic queries to validate before and after the migration in ADMT DB.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
all we are doing is moving the DB from A to B location no other changes, I am trying to understand what check i need to do here.
Just curious, why are you moving ADMT from one server to another? ADMT is usually a temporary (temporary DC if you want to use ADMT command line) server implemented and used during a migration.
Currently we have ADMT 3.2 version installed on our environment, I am planning to detach DB from SQL from A location and uninstall the ADMT tool. Once DB is attached to B location install ADMT tool with same DB. Hope this should work as expected.
It worked.