Red Gate forums :: View topic - Extended properties to track version control revision number
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Extended properties to track version control revision number

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
akashkumar



Joined: 29 Aug 2013
Posts: 1

PostPosted: Thu Aug 29, 2013 7:05 pm    Post subject: Extended properties to track version control revision number Reply with quote

We have automated builds that get triggered from Jenkins on every database change check-in.

Jenkins calls SQL Compare command line which generates the deployment change script and then deploys all the changes to a SQL build instance. In the automated builds, we do not see the extended properties for version control revision number being set.

When we use SQL Compare UI and generate the script manually, it generates the script to add/update version control revision number which looks something like:

DECLARE @RG_SC_VERSION BIGINT

SET @RG_SC_VERSION = 1670

IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL))

EXEC sp_dropextendedproperty N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL

EXEC sp_addextendedproperty N'SQLSourceControl Database Revision', @RG_SC_VERSION, NULL, NULL, NULL, NULL, NULL, NULL

GO

Is there a command line parameter that needs to be passed in to SQL Compare command line to generate the code to update version control revision number extended property? I looked at the documentation for SQL Compare command line and did not find anything there. Am I missing something?

Any help would be appreciated. Thanks!
Back to top
View user's profile Send private message
todtrexler



Joined: 22 Nov 2013
Posts: 3

PostPosted: Fri Nov 22, 2013 1:08 am    Post subject: Reply with quote

I am in this same situation. Does anybody have an answer to this question? Is there a way to force SQL Compare to include the source control revision number update in the script generated from the command line?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group