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