I am revamping the local document that outlines the procedural steps to copy db from one instance to another ( LIVE to TEST) . I am interested in scripting the T_DEFAULTS update with TEST db related values. Would like to know what scripting strategy is utilized by your organization?
Thank you,
Sabina
I use an update script that runs after the database is restored. ie
update t_defaults
set default_value=replace(default_value,'10.6.160.200','10.6.160.160')
where default_value like '10.6.160.200'
set default_value=replace(default_value,'10.6.160.100','10.6.160.160')
where default_value like '10.6.160.100'
set default_value=replace(default_value,'12001','12005')
where default_value like '12001'
set default_value=replace(default_value,'8094','8096')
where default_value like '8094'
set default_value=replace(default_value,'ArtTix','ArtTix TEST ** TEST')
where default_value like 'ArtTix'
and field_name = 'Company Name'
and field_name = 'TITLE BAR TEXT'
etc., for each line I want to update.
Trudy Guest,
ArtTix Systems Administrator
801.323.6969
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham Sent: Wednesday, August 01, 2012 12:16 PM To: Trudy Guest Subject: Re: [Tessitura Technical Forum] How do you upate T_DEFAULTS after coping db from one instance to another?
First, we're on RAMP, so they've got our copies scripted, and they do most of the updates as part of the process. But there are a few updates, especially for local tables that I've got scripted out and saved as a job in SQL Server Agent, so whenever we do a test it's easy to just click and run that job.
From: Sabina Spilkin <bounce-sabinaspilkin7252@tessituranetwork.com> Sent: 8/1/2012 12:49:00 PM
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!