locked
Move SQL Server database for App Controller RRS feed

  • Question

  • I need to migrate our App Controller server to another SQL Server.

    I have copied the relevant SQL Server database. How can I reconfigure App Controller to use this new database?

    Saturday, March 8, 2014 4:46 AM

Answers

  • Hi evilclive1,

    To minimize the risk of data loss, I recommend the following steps:

    1. Export the AES encryption key from your existing App Controller installation
    2. Make sure you have a backup of the App Controller database
    3. On a spare VM, install a new instance of App Controller and connect to the new SQL server (you'll need the AES key from step 1).
    4. Verify that the new instance of App Controller works correctly with the new SQL server (this will verify that you have a good copy of the App Controller database on the new SQL server)
    5. Uninstall the original App Controller
    6. On the original App Controller server, reinstall and point to the new database (you'll need the AES key from step 1)
    7. Verify that this instance of App Controller works correctly with the new SQL server

    There isn't a supported way to just change the database used by an existing install.

    Kind Regards,

    Richard


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, March 28, 2014 4:56 PM