LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Links

Wiki
Blog

Forum Statistics

Users
Members:
1880
Members Online:
2
Guests Online:
70

Total Post History
Posts:
81452
Topics:
18717

7-Day Post History
New Posts:
1
New Topics:
1
Active Topics:
1

Our newest member
kwanail87

Other

FAQ
All times are UTC [ DST ]

database development and publishing changes

Please wait...

database development and publishing changes

Postby Thirster42 on Mon Aug 16, 2010 8:16 pm

I'm having problems getting my head wrapped around source control for databases. Would someone care to go through how their setup works?
Ask three DBAs a question, and you’ll get four different answers.

-Brent Ozar
User avatar
Thirster42
Guru
Guru
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
LTD Silver - Rating: 517LTD Silver - Rating: 517LTD Silver - Rating: 517
 
Posts: 4646
Joined: Tue Nov 11, 2008 5:49 pm
Location: Jefferson City, Mo
Unrated

Re: database development and publishing changes

Postby SQLDenis on Mon Aug 16, 2010 9:06 pm

We have all our objects in Subversion..when it is time to deploy we have to create change, backout and verification scrips for the change, open a ticket and attach the scripts. In general the person with the dbo password on the database will do all this work (hitting the F5 key) and come back to you if it failed or succeeded

I am just glad I do my own changes
User avatar
SQLDenis
LTD Admin
LTD Admin
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
 
Posts: 21784
Joined: Wed Oct 10, 2007 6:43 pm
Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
Unrated