7.11 Moving the QDB

This section provides a brief overview of how to move the QDB from one SQL Server computer to another SQL Server computer.

If you use the repository only as a read-only archive of information, you can typically use SQL Server backup and restore capabilities to copy the repository to a new SQL Server computer. You cannot, however, use the basic backup and restore capabilities to move an active AppManager repository that receives connections from the management server and the Control Center console or the Operator Console.

You can move the QDB between two 32-bit or 64-bit SQL Server computers or from a 32-bit SQL Server computer to a 64-bit SQL Server computer.

NOTE:

  • If you move the QDB from a 32-bit SQL Server to a 64-bit SQL Server computer, you must also move the Control Center repository to a 64-bit SQL server computer at the same time.

  • You must disconnect both the 32-bit repositories when you move them to 64-bit. You can choose to move any secondary QDBs to 64-bit.

For detailed instructions about moving a QDB, see the Upgrade and Migration Guide for AppManager, available on the AppManager Documentation page.