I initially set up my Data Catalog database on a non-production instance of SQL Server for trial/test purposes. Now that I'm ready to go live, I need to move to a production instance. What is the best way to do so?
I'm thinking about the following:
- Stop the service
- Copy the database via backup & restore
- Verify permissions on the new server
- Run the configuration tool to point at the new server
- Start the service if it doesn't automatically start up
Is this workable? Is there an official method?
I'm thinking about the following: