Move SQL Server database for App Controller

Answers

• 

  

  0

  Sign in to vote

  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.

  • Marked as answer by Richard RundleMicrosoft employee Friday, July 25, 2014 9:58 PM

  Friday, March 28, 2014 4:56 PM