Red Gate forums :: View topic - Shared Model Improvements Release
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Shared Model Improvements Release

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
csmith



Joined: 30 Jun 2011
Posts: 117
Location: Cambridge

PostPosted: Fri Jun 08, 2012 3:36 pm    Post subject: Shared Model Improvements Release Reply with quote

Hi

UPDATE:
I'm pleased to announce the Full Release of SQL Source Control v3.1 that includes improvements to the audit information provided in the 'Shared Model' environment. To install it please install the latest SQL Developer Bundle from http://downloads.red-gate.com/SQLDeveloperBundle.exe and then open SQL Source Control and select the latest update when prompted.

Original post:
I'm pleased to announce an Early Access Release of SQL Source Control v3.1 that includes improvements to the audit information provided in the 'Shared Model' enviroment. Download it from:
"http://downloads.red-gate.com/EAP/SQLSourceControl/SQL Source Control_3.1.0.458_x86_r209112.exe".

What�s new in this Early Access build?
This release will benefit you if you�re using the �shared database� development model. Schema changes you and your co-developers make will be listed as changes in the SQL Source Control �changed by� column. Unfortunately, the current implementation does not persist the data for very long as it is stored locally for each SQL Source Control installation. This has been an issue that many of you have raised in our Uservoice forum. In this release we have changed the implementation so that the �changed by� data is stored in a database, �RG�, created on your server.

Please let us know if you have any feedback, good or bad, on the RG database implementation.

Release Notes:
* Object drops will come up as �Unknown� (we have already identified a fix for this, and may update the EAP next week as a result)
* Changes to extended properties on objects will come up as �Unknown�

Thanks,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager


Last edited by csmith on Thu Nov 15, 2012 6:49 pm; edited 2 times in total
Back to top
View user's profile Send private message
dbdmora



Joined: 21 Nov 2011
Posts: 34
Location: Atlanta, GA

PostPosted: Fri Jun 15, 2012 3:26 pm    Post subject: Reply with quote

What is the ETR (estimated time of release) for V3.1 of SSC? Thanks
Back to top
View user's profile Send private message
celeryisbad



Joined: 17 Aug 2012
Posts: 1
Location: London

PostPosted: Fri Aug 17, 2012 2:22 pm    Post subject: DB usage an option? Reply with quote

Hey,

I'm using this new version - if the user doesn't have access to create the new required database, there's an error and the tool is unusable...

Can the use of this be optional? Also - would be good to have a single file on a shared drive accessible by all users rather than the db if possible.

What date will we see an official release Chris?

Thanks!
Joe
_________________
"If I'd asked the people what they wanted, they'd have said 'Faster Horses' ". Henry Ford
Back to top
View user's profile Send private message
anna.p



Joined: 03 Jul 2012
Posts: 23

PostPosted: Mon Sep 10, 2012 11:06 pm    Post subject: Reply with quote

I second dbdmora's question.
Is there an estimated time of release for this version?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Mon Sep 10, 2012 11:10 pm    Post subject: Reply with quote

Thanks for the question. It *should* be days, provided nothing bad turns up in the final phase of testing.

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
MBBW



Joined: 08 Mar 2011
Posts: 12

PostPosted: Wed Sep 26, 2012 5:34 pm    Post subject: Reply with quote

SSC 3.1.0.4583
SQL Server 10.50.4000

Hello!

We are testing the shared model with the SSC changelog database implemented as described at http://www.red-gate.com/supportcenter/content/SQL_Source_Control/knowledgebase/Logging_changes .

Without deep testing it seems to be necessary that each developer has to be a member of the sysadmin role. Otherwise SSC does not work and errors raise like:

System.Data.SqlClient.SqlException: The user does not have rights to perform this action. (Translated from German)


Can you confirm this statement and in case please update your guide? In this case the goal should be that developers can work with least privileged SQL Server logins.

Thanks!
Back to top
View user's profile Send private message
anna.p



Joined: 03 Jul 2012
Posts: 23

PostPosted: Wed Nov 14, 2012 3:31 am    Post subject: Reply with quote

Have you guys been able to fix the bug with v3.1 that caused the permission error for non-sysadmin users?
Back to top
View user's profile Send private message
samssb82



Joined: 23 Aug 2012
Posts: 2

PostPosted: Mon Dec 17, 2012 3:31 pm    Post subject: Reply with quote

Is there an estimated date as to when the issues outlined in http://www.red-gate.com/messageboard/viewtopic.php?t=15852 will be corrected?
Back to top
View user's profile Send private message
mryhmln



Joined: 29 Aug 2011
Posts: 12

PostPosted: Thu Jan 10, 2013 6:22 pm    Post subject: changes not being picked up when restarting SSMS Reply with quote

After upgrading to 3.1, SQL Source Control no longer seems to pick up changes that I am making to the db through SQL Management Studio. I have to restart SSMS in order for SSC to detect any changes.
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