Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

fails on more than 200 objects

I have about 800 objects. I can only add 100 to 200 objects at one time. If I try to add too many it fails.

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminRedgate Administrator (Admin, Redgate) responded  · 

This sounds like a problem we’ve seen before. Do you have Microsoft Security Essentials installed? If so, this could cause a problem when committing a large number of objects, which is usually the case when first committing an existing database to source control. Your workaround of doing a smaller partial commit seems to fit this expected behaviour.

To get around this, please configure Security Essentials to exclude LOCALAPPDATA\Red Gate\SQL Source Control 0\ from live protection.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminRedgate Administrator (Admin, Redgate) commented  ·   ·  Report

    Also, do you have Microsoft Security Essentials installed? If so, this could cause a problem when committing a large number of objects. What source control system are you using?

    To get around this, please configure Security Essentials to exclude C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Source Control 0\ or C:\Users\<username>\AppData\Local\Red Gate\SQL Source Control 0\ from live protection.

    Please let us know if this fixes the issue.

  • [Deleted User] commented  ·   ·  Report

    So that we can try to work out what's going on can you please email us the log file that will have been generated.

    You can find the log in:

    C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\Logs\SQL Source Control 0

    or

    C:\Users\<username>\AppData\Local\Red Gate\Logs\SQL Source Control 0

    depending on your operating system.

    The email address is: ************************************