Creating new v11 database

All,

 

We are upgrading to V11 in about 2 weeks.  I would like to create a brand new v11 database and I just need to know if I use the TIM utility to create a new DB then restore from backup.  We have been using a "cloned" test copy in a virtual network and I would like a brand new copy for the production upgrade. 

 

Thanks

John Brandt

Parents
  • That’s what I have been doing except we have separate virtual servers for test and live.  Did your extractions work?  What did you name your test instance in the SQL database?  We talked about this at the conference and it was mentioned that extractions may not function properly.

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of David Vivino
    Sent: Tuesday, August 21, 2012 1:46 PM
    To: Joe Giambalvo
    Subject: RE: [Tessitura Next Generation Forum] Creating new v11 database

     

    This sounds almost exactly the same as what we’re doing.

    I have a brand new v11 environment to test with – a second SQL instance on the same Windows server as our v10 Test environment.

    I can backup my Live v10 DB, and restore to v10 Test.  I can then restore to v11 Test and run through the migration steps.  So all three DB’s are then current.  I plan to do the Live to v11 Test migration several times during our testing processes over the next several weeks.  Hopefully I’ll get really good at it!

    On the day we go live, I will migrate the Live v10 DB to v11.  Of course, a full backup will be taken beforehand!  The Live DB therefore will stay on the same Windows server in the same SQL instance as it is now.

    …Dave

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of John Brandt
    Sent: Tuesday, August 21, 2012 10:59 AM
    To: Vivino, David
    Subject: RE: [Tessitura Next Generation Forum] Creating new v11 database

     

    Ron,

     

    We are migrating from V10 to V11 however, after attending the tess conference, many users created a brand new database in v11 and restored from backup their version 10 database and repointed T_defaults and websites.  The benefit of this is that it allowed the V10 to remain completely untouched in the event of a rollback if needed instead of restoring from backup.   I found the install document and I am building a new tess server so we can test connectivity and functionality and on the day of the migration move the v10 to the new database and keep the v10 unsullied to cover all of our bases.  It is a lot more work on the back end but it mitigates the risk of a failed restore.  Let me know your ideas.

     

    Thanks

    John

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Ron Wilson
    Sent: Tuesday, August 21, 2012 8:35 AM
    To: John Brandt
    Subject: RE: [Tessitura Next Generation Forum] Creating new v11 database

     

    John,

     

    If you are upgrading from V10 then you would want to make a new copy of your V10 database and go through the data migration and upgrade steps outlined in the upgrade documents.  That is how you get your data to V11.  The migration is done outside of TIM.  You go to TIM after that is done to enable SQL Notifications and install the other service components.

     

    Let me know if I have misinterpreted what you are wanting to do.

     

    Ron

     

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of John Brandt
    Sent: Monday, August 20, 2012 2:03 PM
    To: Ron Wilson
    Subject: [Tessitura Next Generation Forum] Creating new v11 database

     

    All,

     

    We are upgrading to V11 in about 2 weeks.  I would like to create a brand new v11 database and I just need to know if I use the TIM utility to create a new DB then restore from backup.  We have been using a "cloned" test copy in a virtual network and I would like a brand new copy for the production upgrade. 

     

    Thanks

    John Brandt




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

  • The issue we discussed with Extractions is only if you are using one instance for multiple databases.  If you are using a separate SQL instance then there should be no issue.  

    Best,

    Anna

Reply Children
No Data