Topic
  • 4 replies
  • Latest Post - ‏2014-01-14T20:33:55Z by Bzoo
Bzoo
Bzoo
71 Posts

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

    Re: Adding a test database to an existing connection

    ‏2014-01-14T20:28:29Z  
    • Bzoo
    • ‏2014-01-14T20:13:55Z

    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.

     

    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.

  • GlennSkinner
    GlennSkinner
    58 Posts

    Re: Adding a test database to an existing connection

    ‏2014-01-14T19:57:03Z  

    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
    71 Posts

    Re: Adding a test database to an existing connection

    ‏2014-01-14T20:13:55Z  

    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

    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
    58 Posts

    Re: Adding a test database to an existing connection

    ‏2014-01-14T20:28:29Z  
    • Bzoo
    • ‏2014-01-14T20:13:55Z

    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.

     

    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
    71 Posts

    Re: Adding a test database to an existing connection

    ‏2014-01-14T20:33:55Z  

    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.

    Hi Glenn:

    Thanks a lot for your  quick  response.

    I really appreciate your help.

    Regards,

    Bzoo.