Deleted objects

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

Deleted objects

Postby stonefish » Sun Jul 07, 2013 10:48 am

I'm evaluating SQL Source Control (3.4.6.33) to be used with Mercurial (via TortoiseHG). It is used on MS SSMS 2008 Express, which is connecting both to a 2005 Express instance and a 2008 Express instance. We use the Dedicated database development model.

I'm still not convinced the software is fully fit for purpose - but unfortunately it appears to be the only option on the market that comes even close.

One thing that concerns me is the following...

How can I delete an object (table, stored procedure, function, etc) and save that change to the linked directory? From what I can tell this isn't supported?

For instance, if I remove a stored procedure from the software that is no longer necessary. It appears to be impossible for me to save/commit that removal, so that when my colleagues pull the change the stored procedure is also removed from their local database as well.

Obviously the "get latest" tab will show the deleted item as something to be applied to the database.

Cheers,
Tom
stonefish
 
Posts: 2
Joined: Sun Jul 07, 2013 10:33 am

Postby stonefish » Sun Jul 07, 2013 12:08 pm

I really don't know what went wrong originally, but now it appears to be picking up the "Drop" correctly... very strange.

I don't know if it makes any difference (I've just done another test, and it doesn't appear to) but I use a SQL Comparison tool (NOT Red-Gate) to compare two databases and drop the stored procedure that wasn't required.

I can guarantee that it did NOT show any drops originally.

If I can replicate it again, I will try and give me exact details.
stonefish
 
Posts: 2
Joined: Sun Jul 07, 2013 10:33 am

Postby David Atkinson » Mon Jul 08, 2013 9:49 am

That does seem very strange indeed. Sometimes you will need to refresh the commit and get latest tabs, as polling for changes takes up to 30 seconds.

If it happens again please let us know and we'll get the the bottom of it.

Kind regards,

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests