Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reg:Storedd Processing Moving One server to another server Expand / Collapse
Author
Message
Posted Thursday, November 08, 2012 4:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:34 AM
Points: 59, Visits: 360
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.
Post #1382393
Posted Thursday, November 08, 2012 8:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:19 AM
Points: 231, Visits: 736
SSIS Service
Post #1382526
Posted Thursday, November 08, 2012 8:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 858, Visits: 2,318
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
Post #1382530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse