Question About Table Rebuild When Doing Get Latest

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Question About Table Rebuild When Doing Get Latest

Postby jfennell » Wed Jun 23, 2010 9:08 pm

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
jfennell
 
Posts: 32
Joined: Thu Apr 01, 2010 2:19 am

Question About Table Rebuild When Doing Get Latest

Postby sherr » Thu Jun 24, 2010 4:29 pm

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
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby jfennell » Thu Jun 24, 2010 7:12 pm

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
jfennell
 
Posts: 32
Joined: Thu Apr 01, 2010 2:19 am

Question About Table Rebuild When Doing Get Latest

Postby sherr » Fri Jun 25, 2010 11:10 am

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
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby jfennell » Fri Jun 25, 2010 7:33 pm

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
 
Posts: 32
Joined: Thu Apr 01, 2010 2:19 am

Postby jfennell » Thu Jul 01, 2010 10:06 pm

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
jfennell
 
Posts: 32
Joined: Thu Apr 01, 2010 2:19 am


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests

cron