Deleted objects

stonefish · July 7, 2013 5:48AM

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 · July 7, 2013 7:08AM

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.

David Atkinson · July 8, 2013 4:49AM

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

Deleted objects

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk