Topic
  • 1 reply
  • Latest Post - ‏2013-03-21T11:19:41Z by pdubovitsky
thalapathi
thalapathi
64 Posts

Pinned topic Re-establish the dropped User DB with the MASTR schema [Urgent]

‏2013-03-20T19:11:32Z |
Hi All,

We copied some CQ userdatabases and MASTR schema from PROD to TEST environment. Deleted all the Production User DB references referenced on the MASTR schema repository in the test environment by running the sql on the MASTR schema

delete from CQMASTER.MASTER_DBS where NAME not in (..... );

Is there any way to re-establish the dropped User DB with the MASTR schema?

I tried to recreate the User database from CQ designer and it throws error

Error: CRMMD1045E The name <xxxx> is already in use

Cheers,
Jose
Updated on 2013-03-21T11:19:41Z at 2013-03-21T11:19:41Z by pdubovitsky
  • pdubovitsky
    pdubovitsky
    376 Posts

    Re: Re-establish the dropped User DB with the MASTR schema [Urgent]

    ‏2013-03-21T11:19:41Z  
    Hi,

    You can re-export table from prod and update references instead of deleting them.

    Pavel