Red Gate forums :: View topic - SQL Compare aborts - Could not find a part of the path
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare aborts - Could not find a part of the path

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SandraV



Joined: 04 Jun 2014
Posts: 2

PostPosted: Wed Jun 04, 2014 6:54 pm    Post subject: SQL Compare aborts - Could not find a part of the path Reply with quote

SQL Compare is aborting during the check for source drift step with the error Could not find a part of the path 'C:\Users\username\AppData\Local\Temp\srk2fozc.m0j', where username is my username and the actual file refernced changes each time I restart SQL Compare.

Two unique things about this DB are that it's under source control (while all others I've run agains are not) and it uses encryption. I successfully run SQL Compare between other DBs on these two servers.

I upgraded to 10.7 to no avail. The Rev. # for each DB is identical.
Back to top
View user's profile Send private message
SandraV



Joined: 04 Jun 2014
Posts: 2

PostPosted: Wed Jun 04, 2014 10:49 pm    Post subject: SQL Compare aborts - Could not find a part of the path Reply with quote

A found a solution, though not a great solution.

I backed up/restored the source DB to create a copy of the source, ran sp_dropextendedproperty for SQLSourceControl Database Revision, SQLSourceControl Scripts Location, and SQLSourceControl Scripts Location on the copy, and was able to get SQL Compare to work against the copy and my production DB.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Mon Jun 09, 2014 2:04 pm    Post subject: Reply with quote

Thanks - the only other solution I could find is to use the Ignore migration scripts for databases option, which is doing the same thing, in a roundabout way.

Checking for source drift is a step that is trying to ensure there are no more changes that need to be synchronized from source control.

I do not have a root cause for the message but it is something to do with migration scripts - I suspect maybe the migration scripts location may be missing or invalid.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Wed Jul 16, 2014 4:51 pm    Post subject: Reply with quote

A few weeks back I found, completely by accident, you will get "could not find part of path" errors if you specify a revision that does not exist in the /version1 and/or /version2 arguments to the command-line version of SQL Compare. There is a bug logged for that to display a sensible message. As it is, the problem is about incorrect parameters being passed in rather than faulty code in the program.
Back to top
View user's profile Send private message
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