I'm evaluating SQL Source Control (126.96.36.199) 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.