Can I copy a populated object from a database on one server on the Azure Data Catalog to a database on another server?

Question

One of our server names has recently changed so when we published new objects it was under the old server's name duplicating the db that we had added in the original server. All the objects since then have been cataloged in that duplicate db. Is it possible to copy those cataloged objects to another db in the data catalog without losing any of the work done or does it need to be manually copied over using excel for each row?

Answer 1

Hi @A'997 ,

Thanks for your response and clarification. Unfortunately there is not an automatic way to copy the old server's assets to the new server in ADC. To ADC, assets from the old server and assets from the new server are completely separate. It might be possible to read the existing assets (old server) and update the server name (new server name), then write them again.

Basically, write a REST application that does a query to read all assets with that server name (old server name) from ADC, then update the references from old server name to the new server name in memory, then write them again to ADC. Or you might be able to use this sample code to read the desired assets into a file, update the file with new server details, then write them back to ADC. https://github.com/Azure-Samples/data-catalog-dotnet-import-export/

Hope this helps. Let us know how it goes.

----------

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.