A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith
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.
- Posts: 7
- Joined: Sat Dec 03, 2011 11:05 am
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: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 1 guest