Red Gate forums :: View topic - Bad performance and incorrectly included items on 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 3
SQL Source Control 3 forum

Bad performance and incorrectly included items on Get Latest

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sognibene



Joined: 28 May 2013
Posts: 7

PostPosted: Thu Jun 13, 2013 3:54 pm    Post subject: Bad performance and incorrectly included items on Get Latest Reply with quote

Hello,

I have SQL Source Control 3.4.2.61 running against TFS 2010 and SQL Server 2012 SP1 with the latest CU installed. My SQL Server is local on my workstation (quad core, 14GB RAM) and TFS is on the network.

I am trying to get the latest "Filter" from source control. When I select only the filter and click "Get latest", the SQL Source Control "Retrieving changes from source control" hangs and uses 100% cpu for several minutes.

I then get a "Warnings" dialog that includes among other things a High warning that a deployment script with no name ("") will be used, and then it says it will drop a user and three schemas.

Why would this happen when I am just trying to get the updated filter?

Thanks.



Severity: High
Title: Some of the changes you selected are covered by the migration script ""
This will be used to generate the deployment script.
----------------------------------------------------
Severity: Low
Object: ReportViewer
Title: Dropping a user is a potentially dangerous operation. Dependencies for the ReportViewer user are not selected automatically. If you are sure you want to drop this user please select the objects that belong to this user manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: SQLCop
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the SQLCop schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: tSQLt
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the tSQLt schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1120
Location: Twitter: @dtabase

PostPosted: Thu Jun 13, 2013 11:08 pm    Post subject: Reply with quote

SQL Source Control is apparently trying to pull in a "migration script" as part of the "get latest" operation. Can you visit the Migrations tab and see if there's anything there that shouldn't be? If you find something, try deleting it and trying again. However, it's a little strange that it's apparently not got a valid file name. You could try looking at the migrations folder in source control and seeing if there's anything suspect in there.

Failing this, unlink your database and relink it without setting the migrations folder and try the get latest again.

Migration scripts are used when you want to customize the behavior of SQL Compare's comparison and sychronization engine.

David Atkinson
Red Gate
Back to top
View user's profile Send private message Send e-mail
sognibene



Joined: 28 May 2013
Posts: 7

PostPosted: Fri Jun 14, 2013 2:38 pm    Post subject: Reply with quote

I checked the Migrations tab and there are two scripts listed. Both of them are valid. I looked through all the code in both the SQL files and there were no commands that affected any users.

I hadn't patched SQL compare in a while so I am going to restore a new copy of my database and try again. If I can reproduce the problem is there a log file I can send in that might be helpful?
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 82

PostPosted: Mon Jun 17, 2013 9:51 pm    Post subject: Reply with quote

Hi sognibene,

We've opened up a ticket for you and will be in contact shortly. In the meantime, you can find the log files for SQL Source control here: YOURDRIVE:\Users\YOURUSERPROFILE\AppData\Local\Red Gate\Logs\SQL Source Control 3

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
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