What are the challenges you face when working across database platforms? Take the survey

Moving the Data Catalog database?

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:
  1. Stop the service
  2. Copy the database via backup & restore
  3. Verify permissions on the new server
  4. Run the configuration tool to point at the new server
  5. Start the service if it doesn't automatically start up
Is this workable? Is there an official method?

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file