Hi,
Also need to make a change in registry where your EM and server are inststalled.
Change the ODBC connection in the registry for SOURCE EM with the name of the TARGET MSSQL windows server hostname:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.ini\CTMEM640_default
Change the Registry entry for the SOURCE CONTROL-M/Server with the name of the TARGET MSSQL windows server hostname:
HKEY_LOCAL_MACHINE\SOFTWARE\BMC Software\CONTROL-M/Server\SYSPRM\SQLSRVRNAME*
Change this value in the CCM
Database->location
If you are moving to a brand new server do this first.
Install MSSQL in the new Server (TARGET database)
Create EM and Control-M DBO users with the same name and passwords as the SOURCE database.
Create TARGET EM and Control-M databases with a size equal to the SOURCE database.
Stop the SOURCE EM and Control-M Server applications.
Backup the SOURCE EM and Control-M databases.
Restore the SOURCE database backups on the TARGET MSSQL server.
|