November 8, 2012 at 4:10 am
In my company we have two different environments.one for development another one for testing environment.Testing Environment developers not having access to create the SP's.as per my requirement
How to transfer the SP script in one server to another server through JOB.
November 8, 2012 at 8:19 am
SSIS Service
November 8, 2012 at 8:30 am
Personally, I would have the developers build release scripts for applying to the Test environment then hand them over with release notes to the DBA.
He then handles the release process, ensuring he has a back up of the database PRE deployment incase of errors. You also get to test the scripts properly before they get sent to the Production DB
Finally you also have an audit trail of what was released and when, and you know what state each environment is in, and if any issues are down to scripts.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply