Category: Tip

Moving or Copying a PowerShark EQR Database

Sometimes it is necessary to move or copy a PowerShark EQR database from one server to another. You might need to do this if you’re setting up a new production environment or refreshing a test environment with current production data. The procedures are different and this blog article describes the recommended procedure for each.

License

The license to use PowerShark EQR is registered to the database and stored within. As you will learn below, license management is an important aspect of moving and copying PowerShark EQR databases.

Moving Database to a Different SQL Server

  1. Unregister License in Source Database
    • Run the PowerShark EQR Admin Utility
    • Connect to the source database
    • Jot down exactly the “License Key” and who it is “Issued To”
    • Follow the instructions on this page to unregister the license
  2. Backup Database
    Backup the database you are copying using the SQL Server utility for this purpose.
  3. Restore Database
    Restore the database to a target SQL Server Instance and/or different database, again, using the SQL Server utility for this purpose.
  4. Register License
    Follow the instructions on this page to register the license using the “License Key” and “Issued To” jotted down in step 1 above.

Refreshing a Test Database with Current Production Data

  1. Backup PROD Database
    Backup the production (PROD) database using the SQL Server utility for this purpose.
  2. Unregister License in TEST Database
    • Run the PowerShark EQR Admin Utility
    • Connect to the TEST database
    • Jot down exactly the “License Key” and who it is “Issued To”
    • Follow the instructions on this page to unregister the license
  3. Restore PROD Database to TEST
    Restore the PROD database backup to the TEST SQL Server Instance, again, using the SQL Server utility for this purpose.
  4. Register License
    Follow the instructions on this page to register the license using the “License Key” and “Issued To” jotted down in step 2 above.

If you would like to know more about PowerShark EQR databases or if you have any other questions, please contact PowerShark EQR Support.