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

Here is a screen shot of what I mean. I would send you the dtsx file but I have passwords writing in the script for the database encryption key and so on. I schedule this as a SQL job, it notifies me when it has ran and I drop and recreate the users manually. We use this here constantly for test, our conversion environment and testing in a failover environment.

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

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 folks

I've posted the current versions of the components into my files page here.

Anybody who wants to use them should work through them very carefully to adapt to their own site.

Ken

Hi Naomi,

Sometimes downloading zips out of the files area with Internet Explorer causes IE to think the file is corrupted due to the way it interprets the download.  If you have access to Firefox, that usually works well.

If not, I have posted the package here for an alternative option.

Best

Todd

EDIT:  sorry about that--original post had a bad link.  I have corrected it.

Sorry folks--last post had a bad link.  I have corrected it in the original post, but for those of you getting notifications by email here is the correct link for the zip.

...and I've removed the zipped version from my files, and replaced it with a folder which has the original component files in it instead.

Sorry about that. I didn't realise that there were issues with downloading zip files. Pity, because that makes it 7 files to download instead of one. Luckily they're all very small.

Ken