Deleted objects
stonefish
Posts: 5 Bronze 1
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
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
Comments
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.
If it happens again please let us know and we'll get the the bottom of it.
Kind regards,
David Atkinson
Red Gate
Product Manager
Redgate Software