Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-03-21T11:19:41Z by pdubovitsky
thalapathi
thalapathi
62 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

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

    ‏2013-03-21T11:19:41Z  in response to thalapathi
    Hi,

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

    Pavel