Click here to monitor SSC

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 a software architect at Red Gate Software Ltd. He is a frequent speaker at many UK user groups and events (VBUG, NxtGen, Developer’s Group, SQLBits). He is primarily interested in database internals and database change management. At Red Gate he has designed and led the development of many database tools that compare database schemata and enable source control for databases (SQL Compare versions 4 to 7), refactor databases (SQL Refactor) and show the history of databases by analyzing the transaction log (SQL Log Rescue). András has a PhD from Cambridge and an MSc and BSc from ELTE, Hungary. He is also a MCSD and MCPD Enterprise. See his articles on simple-talk.
Latest articles
Backups, What Are They Good For?
 We've heard the confessional story from Pixar that Toy Story 2 was almost lost due to a bad backup, but... Read more...

C# Async: What is it, and how does it work?
 The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is... Read more...

Handling Deadlocks in SQL Server
 In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan... Read more...

SQL VIEW Basics
 SQL Views are essential for the database developer. However, it is common to see them misued, or... Read more...

The PoSh DBA: Grown-Up PowerShell Functions
 Laerte goes step-by-step through the process of tidying up and making more reusable an untidy... Read more...