Central Repository migration

[Former Member]

Hi All,

We need to migrate our central repository from one database to another.

What is the best way to achieve this?

I tried exporting the Central Repository as an ATL file, but didn't find a way to do so.

Thanks and Regards,

Bhupendra

[former_member187605]

1/. Copy all content from old central repo to an empty local one.

2/. Copy all content from that local repo to the new central one.

Obviously, that only works if you're not interested in the full version history.

[Former Member]

We are infact interested in keeping the history of the changes intact.

Any ways to achieve this?

[mageshwaran_subramanian]

If you migrate from one database to another of the same type (say SQL server A to SQL Server B) , a simple backup and restore as a new DB would work.Make sure you configure the new central repo in CMC. This way you can keep the history.I haven't tried it but I cannot think of any pitfalls doing this.