SQL 2005: keeping track of database changes

metaperl

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

Subscribe Reply

2768

Erland Sommarskog

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****@sommarsk og.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

pb648174

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****@sommarsk og.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

Similar topics

3093

Keeping track of what a user has read on a web site

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 this by aggregating new content from all databases into a single indexed database and then saving a timestamp in the account database (for the current user) that tells me when the user last read items in the aggregated database.

PHP

2022

Keeping Track of Changes

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 from the previous version (my feeble mind can't retain all of this, especially when a week passses before getting back to a project). Is there a log mechanism within Access or is there some sort of support software someone can recommend which...

Microsoft Access / VBA

5493

Best practice keeping business object collection synced to DB

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 from a database. In the presentation layer, the user will be able to add/delete/modify this collection in which case it needs to be synced with the database. The question is basically how best to do this? Aside from overriding the add/remove...

C# / C Sharp

4040

How to keep track of changes of an object???

by: Daniel Walzenbach | last post by:

Hi, I need to track all changes made to an object. Consider the following class: Public Class Dog

Visual Basic .NET

3189

Storing SQL Server 2005 objects and queries in Perforce

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 control. Has anyone done this before and can suggest some advice? Alternatively if anyone has other methods for using source control on a database, could you please let me know? Also, is there any automated way of extracting individual scripts...

Microsoft SQL Server

3396

Keeping track of changes in VBA Classes

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 classes for this (I know not the easiest way, but I have made some considerations and I want to to it this way as VBA classes are some new stuff to explore for me). In a class 'client' I get the data from the database and put it in

Microsoft Access / VBA

4194

Track Changes in Form with sub-form & multiple tabs

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 which gives them specific views of the data. I'd like to track all the changes made to a record which works find with the following code : basAuditTrail: Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, recordid As...

Microsoft Access / VBA

9672

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9519

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10437

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10214

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10001

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4113

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3723

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2920

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General