471,073 Members | 1,482 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

SQL 2005: keeping track of database changes

I'm actually taking Microsoft's 2779 and just finished a lab where we
kept track of our changes to the database.

However, I'm not happy with the scripts interface because it does not
tell me the chronological order of my changes to the database.

Could someone share with me their technique for keeping track of
database changes?

I'm actually thinking a set of tables would be best, because sometimes
you want to know what database object you made a change to and other
times you want to know when you did something...

Jul 5 '06 #1
2 2638
metaperl (me******@gmail.com) writes:
I'm actually taking Microsoft's 2779 and just finished a lab where we
kept track of our changes to the database.

However, I'm not happy with the scripts interface because it does not
tell me the chronological order of my changes to the database.

Could someone share with me their technique for keeping track of
database changes?

I'm actually thinking a set of tables would be best, because sometimes
you want to know what database object you made a change to and other
times you want to know when you did something...
The baseline for all such activities is the version-control system. SQL
objects have source code just like any other program code.

In our shop we use Visual SourceSafe out of habit. On top of that we
have a toolset, that also adds its own "system tables" to the database,
so we also have a track for a specific database. The whole thing is
available for public download on http://www.abaris.se/abaperls/.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 5 '06 #2
Microsoft also just came out with a beta for the Databae Professional
edition of Visual Studio Team System... Has anyone tried it?

Erland Sommarskog wrote:
metaperl (me******@gmail.com) writes:
I'm actually taking Microsoft's 2779 and just finished a lab where we
kept track of our changes to the database.

However, I'm not happy with the scripts interface because it does not
tell me the chronological order of my changes to the database.

Could someone share with me their technique for keeping track of
database changes?

I'm actually thinking a set of tables would be best, because sometimes
you want to know what database object you made a change to and other
times you want to know when you did something...

The baseline for all such activities is the version-control system. SQL
objects have source code just like any other program code.

In our shop we use Visual SourceSafe out of habit. On top of that we
have a toolset, that also adds its own "system tables" to the database,
so we also have a track for a specific database. The whole thing is
available for public download on http://www.abaris.se/abaperls/.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Sandman | last post: by
9 posts views Thread by DBQueen | last post: by
5 posts views Thread by Daniel Walzenbach | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.