Hi Dwaine. This Uservoice forum is really for feature requests, not bugs. If you think something is broken, it's generally best to contact our support team directly for assistance.
In this case specifically, it sounds like a misunderstanding in how the tool works (although that suggests we've not explained something correctly!)
The commit tab will offer to delete stuff from TFS if the change was you deleted it from the live DB. For example if you're currently in a state where everything matches up and there's nothing on either tab, then deleting 1000 tables in the Live DB would show you 1000 drops on the commit tab, which, once executed, will delete the objects from TFS.
It sounds like you have stuff in TFS you want to get rid of that isn't in the Live DB you currently are looking at? If so, then it suggests that at some point things have gotten out of sync somehow. One option would be to use the "Undo changes" feature. This will pull items back into the Live DB from the repository and resync everything so you could then delete them from the DB and commit the drop back to TFS? Or if you don't want to make changes directly on the DB, you could create a new empty database, link to the TFS location, do a "Get Latest" on all objects, then delete the ones you don't want in TFS (again, you'd then see drops for all of these on the commit tab).
Hi Dwaine. This Uservoice forum is really for feature requests, not bugs. If you think something is broken, it's generally best to contact our support team directly for assistance.
In this case specifically, it sounds like a misunderstanding in how the tool works (although that suggests we've not explained something correctly!)
The commit tab will offer to delete stuff from TFS if the change was you deleted it from the live DB. For example if you're currently in a state where everything matches up and there's nothing on either tab, then deleting 1000 tables in the Live DB would show you 1000 drops on the commit tab, which, once executed, will delete the objects from TFS.
It sounds like you have stuff in TFS you want to get rid of that isn't in the Live DB you currently are looking at? If so, then it suggests that at some point things have gotten out of sync somehow. One option would be to use the "Undo changes" feature. This will pull items back into the Live DB from the repository and resync everything so you could then delete them from the DB and commit the drop back to TFS? Or if you don't want to make changes directly on the DB, you could create a new empty database, link to the TFS location, do a "Get Latest" on all objects, then delete the ones you don't want in TFS (again, you'd then see drops for all of these on the commit tab).
To understand how we determine what to show on the two tabs, you might want to read this background technical document, which explains it in more detail: http://documentation.red-gate.com/display/SOC3/How+SQL+Source+Control+works+behind+the+scenes
As I said, you can reach out to our support team either by email at support@red-gate.com or via their portal at http://redgatesupport.zendesk.com for more direct assistance.