August 26, 2015 at 11:33 am
Forgive me if this is the wrong forum for my inquiry. I'm new to Team Foundation Server and this is my first experience with version control for an SQL Server database. I'm posting it here because at the core, this is about documenting the schema using extended properties.
TFS takes some getting used to and I may need to find a forum there to do my networking.
My task is to create a process for adding and auditing a set of extended properties for each of our database objects in TFS. What I'm looking for is experience from you folks who use TFS to maintain extended properties. I have questions purely about the use of EP, for example do you use them for lists such as object dependencies. Other questions are related to process of pulling and auditing TFS for incompete EP values. Have you built a report to pull EP directly from TFS?
I realize this is not a precise, razor sharp question with a discrete answer, but I hope someone can point me in the right direction.
Thank you in advance
John
SQL 2012 Standard VPS Windows 2012 Server Standard
August 27, 2015 at 4:29 am
How are you getting your database objects in and out of TFS? If you're doing it manually, stop.
Microsoft provides a free tool, SQL Server Database Tools. It runs in Visual Studio and can be used to link your database code with TFS (git, etc.). If you are using that, it will capture your extended properties with the objects on which they are defined. You can then use that tool through msbuild to generate database deployments through the dacpac.
Redgate Software (my employer by the way) also makes a tool called SQL Source Control [/url]which is for linking your database code with TFS, but through SQL Server Management Studio. It will also capture the extended properties with each object. You can use our tools to build out deployments as well. In fact, we have a whole bunch of tools for automating deployments[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 28, 2015 at 2:49 pm
Grant,
Thank you for this overview of the environment. We to have SSDT in our VS/TFS environment but it's not clear that everyone uses the same process for checking in there TSQL work. And since I am new, I get quite a few pieces of advice on this.
Amazingly, we have an unused license for SQL Version Control so I will install it and read the documentation. I'm sure it will help me understand, by the problem it addresses, the vagaries of using TFS/VS to develope SQL Server objects. Specifically extended properties.
Thanks again Grant
SQL 2012 Standard VPS Windows 2012 Server Standard
August 28, 2015 at 3:28 pm
Glad to help.
The one piece of advice I'd give is that you need to get everyone using a fairly common approach. If some are only doing partial work, you're going to hit issues.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply