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

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

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

Postby SandraV » Wed Jun 04, 2014 6:54 pm

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.
SandraV
 
Posts: 2
Joined: Wed Jun 04, 2014 6:46 pm

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

Postby SandraV » Wed Jun 04, 2014 10:49 pm

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.
SandraV
 
Posts: 2
Joined: Wed Jun 04, 2014 6:46 pm

Postby Brian Donahue » Mon Jun 09, 2014 2:04 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Wed Jul 16, 2014 4:51 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests