Move discovered servers from development CCA to production CCA

Products

• CA Configuration Automation

Issue/Introduction

After have implemented CCA 12.9 in a development environment and have discovered around many servers 
with their components and relationships of each of the servers a new installation was done for the production 
environment. It is required to pass the servers that are discovered in the development CCA to the production 
CCA server with their same components and discovered relationships.

Environment

CA Configuration Automation - version 12.9 and above

Resolution

Below is the procedure to have the discovered data from development into the production environment.

1. Take the copy of mdf and ldf files from the development database environment. Here for example, 
there is an installed CCA with database name as cca129ga.
Then mdf and ldf of the database is cca129ga.mdf and cca129ga_log.ldf.
 
2. The above two files are available in the below location.
 
  C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\
 
3. Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\  
of target database environment.

4. Then go to sql software, right-click “Databases” and click the “Attach” option to open the Attach 
Databases dialog box.

5. Click the “Add” button to open and Locate Database Files From 
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\

6. Click the OK button. SQL Server Management Studio loads the database from the .MDF file.

7. Once the database is loaded, delete the existing user from  <database_name> ->Security ->Users ->
"Database User"

8. Now Expand the Security folder -> Logins ->create New Login

9. Provide the Login name and choose the SQL Server authentication and provide the password for the 
login name.

10. Uncheck the Enforce password policy.

11. Select the User Mapping page -> select the newly uploaded Database name and choose the Default 
Schema as "dbo" and database role as db_owner and public.

12. Click ok to complete the login creation details.

Now it needs to re-install CCA server in the production environment and during the installation process 
please select "Database Action type as Use Existing Database" in the installation screen. Here please 
provide Database Name,User & Password of existing database which was created.

Once the installation is successful it will load all the existing data.