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 EAP
SQL Source Control EAP forum

Question About Table Rebuild When Doing Get Latest

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
jfennell



Joined: 01 Apr 2010
Posts: 32

PostPosted: Wed Jun 23, 2010 9:08 pm    Post subject: Question About Table Rebuild When Doing Get Latest Reply with quote

Hello,

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 table?

I don't see a way for me to access the database change script it has generated; I thought that might give me some clues. The table in question contains filestream data in one of its columns and has A LOT of data in it, so the rebuild will take a considerable amount of time.

Can you help me explain why the table needs to be rebuilt just to add a new stored procedure?

Please let me know if there is any more information I can provide to help investigate this issue.

Thanks,
_________________
~ Jim Fennell
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Thu Jun 24, 2010 4:29 pm    Post subject: Question About Table Rebuild When Doing Get Latest Reply with quote

Hello Jim,

This is very strange...

We are using SQL Compare to commit/get. SQL Compare sometimes requires the table to be rebuilt, but this doesn't sound like your situation.

Would you be able email us a copy of what's in source control and a SQL Compare snapshot of your database so we can reproduce the problem here? This will only be used for our internal testing.

Email: support@red-gate.com
Internal Reference Number: SOC-1235

Thank you!
Stephanie M. Herr Smile
Project Manager - SQL Source Control
Back to top
View user's profile Send private message
jfennell



Joined: 01 Apr 2010
Posts: 32

PostPosted: Thu Jun 24, 2010 7:12 pm    Post subject: Reply with quote

Hi Stephanie,

I agree that the link you mentioned does not describe any situations that seem to apply here. I'll be glad to email you the information you requested. When you ask for "a copy of what's in source control," what's the best way for me to get what you're looking for?

Thanks,
_________________
~ Jim Fennell
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Fri Jun 25, 2010 11:10 am    Post subject: Question About Table Rebuild When Doing Get Latest Reply with quote

Hello,

What source control system are you using?

It's best to do a SVN Checkout or a TFS Get Latest to a temporary location on your computer. You can then zip up the files and email that to support@red-gate.com. You may want to rename the zip to *.zip.txt, so email filters don't strip the attachment. When we get the file, we'll remove the .txt so we can see the zip contents.

Thank you!
Stephanie M. Herr Smile
Project Manager - SQL Source Control
Back to top
View user's profile Send private message
jfennell



Joined: 01 Apr 2010
Posts: 32

PostPosted: Fri Jun 25, 2010 7:33 pm    Post subject: Reply with quote

Stephanie,

Sorry, I should have known that you'd want to know that. I'm using Subversion. I'll pull a temporary copy of what SQL Source Control has in the repository and email it over with the snapshot.

Thanks,
_________________
~ Jim Fennell
Back to top
View user's profile Send private message
jfennell



Joined: 01 Apr 2010
Posts: 32

PostPosted: Thu Jul 01, 2010 10:06 pm    Post subject: Reply with quote

Apologies for the slow turnaround on my part. I've just emailed the requested information. Please feel free to call me at the phone number in my email (East Coast, USA) if you have any questions.
_________________
~ Jim Fennell
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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