Is it possible to duplicate a SQL repository, like it is possible to do for GBMS and Oracle.
There is no option to duplicate SQL repository, I wonder if it is possible?
Solved! Go to Solution.
With SQL server server there is no duplicate feature such as with Oracle storage.
Performing a duplication via SQL Server tools (physical duplication) would not be correct.
Indeed, each repository has a ID. When performing a physical duplication, this ID dos not change.
As a consequence, the official procedure consists in using logical backup and importing the .MGR fle to rebuild a new repository. This can take some time.
If this is not applicable in your context, please open a case
I believe, it should not be an issue when I import logical back from repository A into repository B, within the same Environment?
We have to restore a previous state of a repository and intend to do this to another existing (empty) repository. Can we do this with the restore feature of the SQL Server or is there still an issue with the repository ID?
There are also articles, within our online documentation, that cover both "environment duplication" and "repository duplication within the same environment" (the original post). The "repository duplication within the same environment" method covered in the attached screenshot of our documentation is an "expert level" method to duplicating but one that I personally prefer, so I thought I would share ;-)
Hope you find it helpful.