How do you version/track changes to SQL tables?

Posted by gabe. on Programmers See other posts from Programmers or by gabe.
Published on 2010-12-29T22:31:15Z Indexed on 2010/12/29 22:58 UTC
Read the original article Hit count: 341

Filed under:

management

|

version-control

|

sql

When working in a team of developers, where everyone is making changes to local tables, and development tables, how do you keep all the changes in sync? A central log file where everyone keeps their sql changes? A wiki page to track alter table statements, individual .sql files that the devs can run to bring their local db's to the latest version? I've used some of these solutions, and I'm tyring to get a good solid solution together that works, so I'd appreciate your ideas.

© Programmers or respective owner

Related posts about management

SQL Server Management Features vs Oracle Database Management Features

as seen on Internet.com - Search for 'Internet.com'
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service… >>> More
Enterprise Performance Management: Driving Management Excellence

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Extending operational excellence to management excellence is the new strategic imperative for organizations large and small, all around the world. Management Excellence is a strategy for organizations to differentiate from their competition, by being smarter, more agile and more aligned. Tune into… >>> More
SQL Server Management Features vs Oracle Database Management Features

as seen on SQL Server Central - Search for 'SQL Server Central'
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service… >>> More
Oracle Application Management Pack and Application Change Management Pack for Oracle E-Business Suit

as seen on Oracle Blogs - Search for 'Oracle Blogs'
???????????,ORACLE AMP,ACP3.0 For Oracle EBS R12???,?????????? - EBS R12.1.2 - Grid Control 10.2.0.1 - 10.2.0.5 - AMP3.0 - ACP3.0 ??????????,??????????????,????????????????. ??????,??????????... >>> More
IIS Management Console is not present in web management tool

as seen on Super User - Search for 'Super User'
M facing the same problem.IIS Management console is not present under web management tool.Two options are there 1IIS 6 management compatibility 2IIS Management Scripts & Tools. checked both. But come in no use.Please help. >>> More

Related posts about version-control

In the context of the TFS version control SDK (Microsoft.TeamFoundation.VersionControl), what exactl

as seen on Stack Overflow - Search for 'Stack Overflow'
In the context of the TFS version control SDK (Microsoft.TeamFoundation.VersionControl), what exactly is deletionID? It is a property of Microsoft.TeamFoundation.VersionControl.Client.Item. It is also a parameter to some of the query methods on Microsoft.TeamFoundation.VersionControl.Client. I'm… >>> More
What are the advantages of version control systems that version each file separately?

as seen on Programmers - Search for 'Programmers'
Over the past few years I have worked with several different version control systems. For me, one of the fundamental differences between them has been whether they version files individually (each file has its own separate version numbering and history) or the repository as a whole (a "commit" or… >>> More
What are the advantages of version control systems that version each file separately?

as seen on Programmers - Search for 'Programmers'
Over the past few years I have worked with several different version control systems. For me, one of the fundamental differences between them has been whether they version files individually (each file has its own separate version numbering and history) or the repository as a whole (a "commit" or… >>> More
R and version control for the solo data analyst

as seen on Stack Overflow - Search for 'Stack Overflow'
Many data analysts that I respect use version control. For example: http://github.com/hadley/ See comments on http://permut.wordpress.com/2010/04/21/revision-control-statistics-bleg/ However, I'm evaluating whether adopting a version control system such as git would be worthwhile. A brief overview: I'm… >>> More
What version control tool can generate this header

as seen on Stack Overflow - Search for 'Stack Overflow'
This is from a sql script. What tool can generate this? Thanks --USE [MY_TABLE] GO /****** Object: StoredProcedure [dbo].[adminIncExp] Script Date: 03/05/2010 09:14:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: … >>> More