Move Tessitura Production to Test

 Hi, everybody.

We would like to automate the prosess of moving Production db to Test
and setup to the schedule.
Any ideas solutions about this process will be really helpfull.

 

Thanks, Svetlana

 

 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thank you, Naomi.

We also thinking about MSSIS

Ans my 2d question about drop-recreate users

Does anybody automate the process drop - recreate login?

I've asked the same question Tessitura Network, but ...

From our side we profiled the process drop and recreateusers

and tried to setup it as SP. Unfortunately, it doesn't work the way, how Tessitura security module works.

Thanks, Svetlana

 

 

 

Hi Svetlana

We use a stored proc to automate the whole process, including re-creating logins.

Our script doesn't try to reproduce the tess <<drop/create all users>> process - it just copies missing / new user logins across from Live, with the same SID, so they automatically link to the users brought across in the db restores.

I presented on our process for maintaining test versions (we run three test environments, for different purposes) at the Tucson conference in 2007, available here:

 

To test, or not to test? How is the question… Maintaining your Test Environment

To test, or not to test? How is the question… Maintaining your Test Environment - Additional Scripts (zip)

...But the scripts have changed considerably in detail since then  - If you're interested in taking a look, I could post the current versions of the various components on my user files page. Might take me a day or two to re-assemble them.

Ken

Hi Svetlana

We use a stored proc to automate the whole process, including re-creating logins.

Our script doesn't try to reproduce the tess <<drop/create all users>> process - it just copies missing / new user logins across from Live, with the same SID, so they automatically link to the users brought across in the db restores.

I presented on our process for maintaining test versions (we run three test environments, for different purposes) at the Tucson conference in 2007, available here:

 

To test, or not to test? How is the question… Maintaining your Test Environment

To test, or not to test? How is the question… Maintaining your Test Environment - Additional Scripts (zip)

...But the scripts have changed considerably in detail since then  - If you're interested in taking a look, I could post the current versions of the various components on my user files page. Might take me a day or two to re-assemble them.

Ken

Hi Ken,

Good day.

this is a very interesting topic.

Thanks for your sharing.

 

have fun

Ben

Hi Ken,

Good day.

this is a very interesting topic.

Thanks for your sharing.

 

have fun

Ben