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

The Development Backup Expand / Collapse
Author
Message
Posted Tuesday, May 20, 2014 12:30 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:40 AM
Points: 2,923, Visits: 1,875
I know of one shop that uses Red-Gate SQLCompare to create a snapshot of the production server every night and that gets checked into source control. It allows a dev environment to be refreshed from production in order to rehearse deployments.

Having the CI servers rebuild from the last deployed baseline is a very useful thing to have.
Having utility procs and test procs in source control is also handy. Whenever a new server is spun up the script to do so checks out the scripts to build the utility features and executes those scripts.

Knowing that ever server has your most treasured utilities ready to hand is reassuring.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1572835
Posted Wednesday, May 21, 2014 4:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 15, 2014 8:13 AM
Points: 295, Visits: 1,013
I have all my db code in version control. For some new projects, I have the database code in a visual studio project. From there, I can publish it directly to a database server. I can of course also do compares etc. The feeling of that is very nice.
Post #1573070
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse