Topic
4 replies Latest Post - ‏2014-01-14T20:33:55Z by Bzoo
Bzoo
Bzoo
45 Posts
ACCEPTED ANSWER

Pinned topic Adding a test database to an existing connection

‏2014-01-14T18:49:36Z |
All:

CQ Windows 7 Client 7.1.2.08

 
I have a connection "conn1"  that contains the product database  "PRD" and the master database "Master" only.
It does not contain the test database. The schema is at version 10.
 
Now,  I need to add a new test database to this connection.
 
I know how  to cretae a  new test database "TST" based on schema version 10 from scratch.
How do I add this to the existing connection "conn1" without affecting production.
 
Your help is greatly appreciated.
 
Thanks for your help
Bzoo 
Updated on 2014-01-14T18:53:28Z at 2014-01-14T18:53:28Z by Bzoo
  • GlennSkinner
    GlennSkinner
    46 Posts
    ACCEPTED ANSWER

    Re: Adding a test database to an existing connection

    ‏2014-01-14T19:57:03Z  in response to Bzoo

    Hi Bzoo

    I'm not sure I understand the question, what do you mean by "without affecting production"?

    If you log into "conn1" with the designer and create a test database called "TST" based on revision 10, the "PRD" database is not affected. You would end up with a "conn1" which contains "PRD", "MASTER", and "TST". Is this what you are trying to do?

     

    Glenn

    • Bzoo
      Bzoo
      45 Posts
      ACCEPTED ANSWER

      Re: Adding a test database to an existing connection

      ‏2014-01-14T20:13:55Z  in response to GlennSkinner

      Hi Glenn:

      This is what I am trying to do exactly. 

      I just want to make sure nothing bad happens ( in the process)

      to the "conn1"  nor to the production "PRD" nor to "Master" databases.

      Thanks

      Bzoo.

       

      Updated on 2014-01-14T20:21:14Z at 2014-01-14T20:21:14Z by Bzoo
      • GlennSkinner
        GlennSkinner
        46 Posts
        ACCEPTED ANSWER

        Re: Adding a test database to an existing connection

        ‏2014-01-14T20:28:29Z  in response to Bzoo

        Nothing SHOULD happen to the "conn1", "PRD", or "MASTER" if you create a new empty test database. If you login to the connection, select new database, enter the database information of the empty database you are creating the test database into, the worst case would be the creation of the test database fails, it won't affect the PRD, or MASTER.

        We always suggest though, to backup your databases first just to be safe. Creating a new test database won't affect the existing databases. However, having fresh backups though, is always a good practice.

        • Bzoo
          Bzoo
          45 Posts
          ACCEPTED ANSWER

          Re: Adding a test database to an existing connection

          ‏2014-01-14T20:33:55Z  in response to GlennSkinner

          Hi Glenn:

          Thanks a lot for your  quick  response.

          I really appreciate your help.

          Regards,

          Bzoo.