Creating new v11 database

I think John’s talking about building out a brand new Live database, fully configured for v.11, that on go-live you restore from Live V.10. In theory, it ought to make your go-live window shorter, because all the configuration is done beforehand. I think it’s a terrific idea and I’d love to do that, but someone else was saying that the Transcend database gets cranky if you go this way. I’d love to hear experiences from those who did this, as I had enough trouble with my Transcend database when I built my new Test v.11 environment (I eventually created a new Transcend database, since in Test it doesn’t matter, but needless to say, I don’t want to have to do this in Live).

If anyone has any experiences they could offer, I’d love to hear them.

Thanks,

Jeanne DeVore

Technology Manager

Chicago Shakespeare Theater

jdevore@chicagoshakes.com

312 595-5603

www.chicagoshakes.com

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

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

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!

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!

I think John’s talking about building out a brand new Live database, fully configured for v.11, that on go-live you restore from Live V.10. In theory, it ought to make your go-live window shorter, because all the configuration is done beforehand. I think it’s a terrific idea and I’d love to do that, but someone else was saying that the Transcend database gets cranky if you go this way. I’d love to hear experiences from those who did this, as I had enough trouble with my Transcend database when I built my new Test v.11 environment (I eventually created a new Transcend database, since in Test it doesn’t matter, but needless to say, I don’t want to have to do this in Live).

If anyone has any experiences they could offer, I’d love to hear them.

Thanks,

Jeanne DeVore

Technology Manager

Chicago Shakespeare Theater

jdevore@chicagoshakes.com

312 595-5603

www.chicagoshakes.com

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

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

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!

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!