473,231 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 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 2749
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Sandman | last post by:
Just looking for suggestion on how to do this in my Web application. The goal is to keep track of what a user has and hasn't read and present him or her with new material I am currently doing...
9
by: DBQueen | last post by:
Is there an easy way to keep track of which modules I've worked with day by day. I'd like to see a log of what items I "affected" - so that when a database goes sour I can easily see what changed...
9
by: Alfred Taylor | last post by:
I'm testing the waters of n-tier development and I ran into a scenario that I'm not sure what the best solution would be. I have a Company object which contains a collection of contacts retrieved...
5
by: Daniel Walzenbach | last post by:
Hi, I need to track all changes made to an object. Consider the following class: Public Class Dog
2
by: d.grabov | last post by:
We are trying to use source control to store our database objects and queries in Perforce. The general idea is to produce scripts which create all objects in the DB and then store the SQL in source...
2
by: De_Cisse | last post by:
Hi all, I'm working on an application in which I already make some preparations to be able to work in a frontend and backend database, even if this isn't the issue a this moment. I'm using VBA...
3
by: dirksza2009 | last post by:
Hi, I've made a multi user (4 end users) database in Access 2000. I've made data tables, reference tables etc which sits on a shared drive and I've made individual front ends for the end users...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

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.