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
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.
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
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