Red Gate forums :: View topic - Question About Table Rebuild When Doing Get Latest
Return to www.red-gate.com RSS Feed Available

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

Question About Table Rebuild When Doing Get Latest

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jfennell



Joined: 01 Apr 2010
Posts: 32

PostPosted: Wed Jul 14, 2010 5:49 pm    Post subject: Question About Table Rebuild When Doing Get Latest Reply with quote

Hello,

I posted this question in the "early access" forum, and I haven't received a response. Now that the EA forum is locked, I wanted to follow up on it by re-posting here.

I have a database under source control to which a new stored procedure was recently added on the remote (server) copy of the database. I am trying to use the "Get Latest" function to update my local copy of the database. When I go to the Get Latest tab under SQL Source Control for the database on my local system, the only change listed is the new stored procedure. When I try to perform the "Get Latest" function, SQL Source Control gives me a warning that it needs to rebuild one of the tables mentioned in the new stored procedure.

Why it would need to rebuild a table just to create a new stored procedure in the database? Shouldn't it be able to simply execute the CREATE PROCEDURE script?

Per your request, I emailed a database snapshot and copies of the SQL Source Control scripts to support@red-gate.com with a subject line of "Internal Reference Number: SOC-1235"

Please let me know the status of this issue and if there is anything more I can do to help troubleshoot it. Rebuilding that table takes a LONG time (1/2 hour+) given its size, and it is troubling that SSC wants to rebuild it when that doesn't seem necessary. Developers are starting to talk about circumventing the source control and applying scripts directly just to avoid the rebuild.

Thanks in advance for your help,
_________________
~ Jim Fennell
Back to top
View user's profile Send private message
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