Moving the Data Catalog database?

alevyinroc

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?

Tianjiao_Li

Hi @alevyinroc

It's the best way to do it as far as I know.

We've seen users running into issues at step 2, so do let us know and we'll provide further information.