How to check database schema version

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

How to check database schema version

Postby kulmam92 » Mon May 20, 2013 2:44 pm


When using sql source control and svn to manage DB schema, is there a way to check which version of db schema that a database has? I'm asking if there's any version table or version information stored in the database, so that I can check the schema version without using source control tool.

Thank you,
Posts: 7
Joined: Sat Dec 03, 2011 10:05 am

Postby james.billings » Wed May 22, 2013 3:22 pm

The current revision of a given linked database is stored in a DB level Extended Property, so you can view this in SSMS by right-clicking the DB, picking Properties, and looking at the Extended Properties.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control 3

Who is online

Users browsing this forum: Google [Bot] and 0 guests