Question About Table Rebuild When Doing Get Latest

[jfennell]

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

[sherr]

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
Project Manager - SQL Source Control

[jfennell]

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

[sherr]

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
Project Manager - SQL Source Control

[jfennell]

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

[jfennell]

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