Hello,
I am looking into developing a small portable test impresario database. Does anyone already have such a thing? Test names, addresses, plans, campaigns.... the works? I am shying away from using a copy of our database, not only because of the sheer size of it, but also completely ensuring no faulty sanitation occurred. This will also exist on a laptop.
Thanks
The installation package comes with a sample database that I have always assumed is what TN staff use during demos. You might figure out how to get TIM (or at least NAnt) to install it for you, or you can find it at /Components/Database/DbRefresh/TessituraSampleDatabase15.1.0.zip in the installation package.
All these years, I never knew that... Thanks!
One more thing Nick,
What's the master key password for that sample database? I would like to upgrade it, but it wants me to open the master key to do it.
No idea. Did you install it with TIM, or are you attaching it manually?
I am attaching it manually. The sample database is not at the same level. Security reported it Version: 15.1.8.52593where the security application is expecting 15.1.8.57135. Not a big deal, In TIM, I tried to upgrade the database and it reports a build failure about opening the master key. At this point, I am assuming a SQL statement is in order
OPEN MASTER KEY DECRYPTION BY PASSWORD = '#######'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
I just don't know what that password could be...
I thought about using a force regeneration and doing something with the tesscert certificate, but I wanted to know if there was an easier answer.