A service from Red Gate

in
Home SQL .NET Exchange Opinion Blogs Forums About
Sign in | Join | Help
Home Blogs Forums
Blogs Home > Andras > Databases and source control article

Andras

Software Architect - Red Gate Software

Databases and source control article

Published Wednesday, May 30, 2007 2:39 PM

My current interest is focused on database evolution and on ways to manage changes to database schemata. This interest is reflected in my current project, SQL Compare 6. This version has the goal to help source control integration for databases by allowing users to handle a set of SQL creation scripts as a possible source for the database schema. However, even with this tool, it is not a simple task to set up source control, and there are many problems one needs to find a solution for. I have summarized some of these problems in an article which you can access on Simple Talk

by András

Comments

 

HenryH said:

OK. I use Source Control in SQL Server, using SourceSafe. I've read the article. I can understand your caution, but can you please list out simply the problems that aren't solved by SQL Compare 6's ability to read and sync to and from SQL scripts. (http://www.simple-talk.com/community/blogs/andras/archive/2007/05/15/26511.aspx). I can understand that one still doesn't know who did what if SQL Compare syncs the script to the database, but then DDL Triggers (in 2005) will do that.
May 30, 2007 12:19 PM
 

András said:

Hi Henry,

I tried to make the article as general as I could, so it is not about SQL Compare 6, or its limitations. I will try to summarize SQL Compare's limitations, at least the ones I'm aware of, once we release the final version (at the moment only a beta version is accessible to the public). I would appreciate if you could share your opinion on what limitations there may be, we might be able to address these before the release. Concerning DDL triggers, it is a tricky one. I'm not sure if I understand you right though. SQL Compare disables DDL triggers (and then reenables the active ones) before synchronizations. This can be controlled by an option, but by default the DDL triggers would not be fired. However, one can always use SQL Compare to see if the executed script is in sync with the creation files.

Andras
June 1, 2007 2:52 AM
You need to sign in to comment on this blog

About András

András Belokosztolszki is the architect of SQL Compare versions 4, 5, 6 and 7, SQL Log Rescue and SQL Refactor. He is focused on database internals, database synchronization and database schema evolution.
  Opinion Home

  Opinion Pieces (98 articles)

  Geek of the Week (40 articles)

  Tony Davis - Editor (6 articles)

  Phil Factor (41 articles)

  Damon Armstrong (8 articles)

  Douglas Reilly (40 articles)

  Adrian Furnham (1 articles)

  Claire Brooking (1 articles)

  Richard Morris (37 articles)

  Tim Gorman (1 articles)

  Jesse Liberty (5 articles)

  Sarah Blow (1 articles)

  Anna Larjomaa (1 articles)

  Gaidar Magdanurov (2 articles)

  Regular Columnists (1 articles)

  Ben Hall (2 articles)

  Blogs Home
<May 2007>
SuMoTuWeThFrSa
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
Larry Gonick: Geek of the Week
 Cartoonist, mathematician, historian and environmentalist. Larry Gonick proved that learning could be... Read more...

A SysAdmin's Guide to Change Management
 In the first in a series of monthly articles, ‘Confessions of a Sys Admin’, Matt describes the issues... Read more...

Exchange: Recovery Storage Groups
 It can happen at any time: You get a request, as Admin, from your company, to provide the contents of... Read more...

Build Your Own Virtualized Test Lab
 Desmon explains the fundamentals of building a test lab for Windows servers and Enterprise applications... Read more...

Rendering Hierarchical Data with the Treeview
 It sometimes happens that Web Server controls that visualize data don't quite fit with the way that... Read more...