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
Posted Tuesday, May 20, 2014 12:30 PM


Group: General Forum Members
Last Login: Yesterday @ 11:44 AM
Points: 2,997, Visits: 2,043
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
Post #1572835
Posted Wednesday, May 21, 2014 4:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 29, 2015 1:06 PM
Points: 305, Visits: 1,081
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