Keep track of data base versions

Hi

We have several data bases and we update them every once in a while.

We want to mark each current state witha version in order to be able to track the changes made between 2 versions.

Any recommended tool?

Thanks

Avi harush

Check in Books Online about using Extended Properties.

Topics:

sp_addextendedproperty

sp_updateextendedproperty

fn_listextendedproperty

Code Snippet

EXECUTE sp_updateextendedproperty 'Version', 'v 1.0'
SELECT * FROM ::fn_listextendedproperty
( 'Version', default, default, default, default, default, default )
EXECUTE sp_updateextendedproperty 'Version', 'v 1.1'
SELECT * FROM ::fn_listextendedproperty
( 'Version', default, default, default, default, default, default )

|||

Thanks

Isn't there a product for doing this?

Avi

|||

I don't know of a third party tool to manage this.

But it would be very simple to create a couple of stored procedures (or script files) that can be used by your Upgrade process to check the version and either inform or take appropriate action.