Red Gate forums :: View topic - Deleted objects
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Deleted objects

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stonefish



Joined: 07 Jul 2013
Posts: 2

PostPosted: Sun Jul 07, 2013 10:48 am    Post subject: Deleted objects Reply with quote

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
Back to top
View user's profile Send private message
stonefish



Joined: 07 Jul 2013
Posts: 2

PostPosted: Sun Jul 07, 2013 12:08 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1108

PostPosted: Mon Jul 08, 2013 9:49 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group