How to move the Footprints Asset Core database to a new MSSQL server

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Client Management


    COMPONENT:

    Client Management


    APPLIES TO:

    Any version of BCM although the supported DB versions may vary depending on the agent version.



    PROBLEM:

    How do I move the BMC Client Management database to a new MSSQL server?


    SOLUTION:

    To move the database to a new SQL server, please follow the steps below:

       
    1. On the master server, go to Start > Administrative Tools > Services, and stop the Numara Asset Management Platform Agent service.
    2.  
    3. Backup the current database If Running Against SQL Server 2000:    
           
      1. Open SQL Enterprise Manager on the existing AMP SQL 2000 Server.
      2.    
      3. Expand Microsoft SQL Servers, SQL Server Group and the name of the SQL Server.
      4.    
      5. Right click the AMP database and select All Tasks -> Backup Database...
      6.    
      7. Click the Add button.
      8.    
      9. Click the Browse button (...), browse to the location where the database backup will be saved, and give it a file name.
      10.    
      11. Click Ok, and Ok again.
      12.    
      13. Back at the SQL Server Backup window select Overwrite existing media.
      14.    
      15. Click Ok to begin the backup process.
      16.    
      17. Click Ok once the backup is complete.
      18.   
      If Running Against SQL Server 2005, 2008, or 2012:    
           
      1. Open SQL Server Management Studio on the existing AMP/FAC SQL 2005, 2008, or 2012 database server.
      2.    
      3. Login as SA or an SA equivalent account.
      4.    
      5. Expand the Databases folder.
      6.    
      7. Right-click the database that you would like to backup and select Tasks -> Back Up.
      8.    
      9. If a file path already appears in the "Destination" window at the bottom, take note of the path and name of the backup file that will be created and skip down to step i. If a file path does not exist in the window, click the Add button and continue with the steps below.
      10.    
      11. Click the ellipse button to the right of the "File name" field.
      12.    
      13. In the "File name" field at the bottom of the "Locate Database Files" window, enter the desired backup file name. This will be the name of the backup file once the backup is complete. Take note of the path where the backup file will be created.
      14.    
      15. Click Ok Locate Database Files window and then click Ok to close the "Select Backup Destination" window.
      16.    
      17. Click Ok to begin the backup.
      18.    
      19. Click Ok once the backup is completed successfully.
      20.   
    4.  
    5. Copy the backup file to the new database server In SQL 2000, the default Backup file location is C:\Program Files\Microsoft SQL Server\MSSQL\Backup In SQL 2005, 2008, or 2012, the default Backup file location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
    6.  
    7. Restore the database onto the new server If restoring into SQL 2000    
           
      1. Open SQL Enterprise Manager on the new SQL Server.
      2.    
      3. Expand Microsoft SQL Servers, SQL Server Group and the name of the SQL Server.
      4.    
      5. Right click on the Databases folder and select All Tasks -> Restore Database...
      6.    
      7. In the Restore as database dropdown field type the desired name of the restored database. Do not leave "master" in this field. For example, name it "ampdb".
      8.    
      9. Click the From device radio button.
      10.    
      11. Click the Select Devices... button.
      12.    
      13. Click the Add... button.
      14.    
      15. Click the Browse button (...), browse to the location where the database backup file was copied, select it and then click Ok.
      16.    
      17. On the Choose Restore Destination window click Ok.
      18.    
      19. On the Choose Restore Devices window click Ok.
      20.    
      21. Click the Options tab.
      22.    
      23. In the Move to physical file name column of the grid make sure that the path is valid for the SQL Server you are restoring to. The path is taken from the original SQL Server and may not be valid on the new SQL Server. For example, if the old SQL Server had the database files located on the E: drive and the new SQL Server is installed onto the C: drive, the drive letter would need to be changed before running the restore operation.
      24.    
      25. Once the path is valid, click the Ok button to begin the restore operation.
      26.    
      27. Once the restore is complete, the database will show under the Databases folder in Enterprise Manager.
      28.   
      If Restoring into SQL Server 2005, 2008, or 2012    
           
      1. Open SQL Server Management Studio on the new SQL 2005, 2008, or 2012 database server.
      2.    
      3. Login as SA or an SA equivalent account.
      4.    
      5. Right-click Databases on the left and select Restore Database.
      6.    
      7. In the To database: field, enter the desired database name. This will be the name of the database after the restore is complete.
      8.    
      9. Under the "Source for Restore" section, select the From device radio button and then click the ellipse button to the right of the field.
      10.    
      11. Click the Add button and then browse for the location where the backup file was copied.
      12.    
      13. Select the backup file and then click Ok.
      14.    
      15. Click Ok to close the "Specify Backup" window.
      16.    
      17. In the "Select the backup sets to restore:" window, click the "Restore" check box next to the name of the database.
      18.    
      19. Select the Options page in the upper left.
      20.    
      21. In the "Restore the database files as:" section, to the right of the first row, click the ellipse button.
      22.    
      23. Navigate down to the following path, or the path where you would like the database files to be created: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
      24.    
      25. Expand the Data folder to display the list of database files already present on the server.
      26.    
      27. In the File Name field, enter the name of the file that will be created during restore. Make sure this name doesn't already exist. For example, enter a file name of "ampdb.mdf"
      28.    
      29. Repeat items k through m above for each database file in this list.
      30.    
      31. Click Ok to begin the restore operation.
      32.    
      33. Click Ok once the restore has completed successfully.
      34.   
    8.  
    9. ||TIA04408.zip|| to download a zip file containing a SQL script to update the database user information.
    10.  
    11. Open this script in Management Studio (SQL 2005, 2008, or 2012), or Query Analyzer (SQL 2000)
    12.  
    13. If the database was created with a user other than ampdbuser during installation, please change the @UserNamePattern section to show the correct user.    
           
      1. For example, if the SQL user created during the original installation was "amp", this portion should read @UserNamePattern = 'amp'.
      2.   
    14.  
    15. Execute the script.
    16.  
    17. From the \Program Files\Numara Software\Numara AMP\Master\config\ folder, open the Vision64Database.ini file in any text editor (such as Notepad).
    18.  
    19. Change the DatabaseName line to have the new SQL sever, and databse. For example, if the new server is named SQL01 and the database name is ampdb, this line should read "DatabaseName=Driver={SQL Server};Server=SQL01;Database=ampdb" (without the quotes).
    20.  
    21. Change the Host= line to have the name of the new SQL server
    22.  
    23. Change the User= line to have the name of the new SQL user created above
    24.  
    25. Change the PasswordEnc= line to be Password= with the password for the newly created user (for example, if the new password is ´┐Żamp_db_password´┐Ż this line should read "Password=amp_db_password" without the quotes).

       

     


    Article Number:

    000010186


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles