Error: the given key was not present in the dictionary

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

Error: the given key was not present in the dictionary

Postby krichter » Wed May 08, 2013 4:40 pm

I cannot generate a deployment script in comparing a certain SQL 2012 db. I have tried comparing from different servers, creating new project, etc. When I choose deployment wizard it fails on "calculating dependencies". The message at the bottom says "The given key was not present in the dictionary". This is a big issue as I cannot generate a deployment script.
The database in question uses a FileTable. I am using SQL Compare version 10.38.406 (latest).

Posts: 1
Joined: Wed May 08, 2013 4:33 pm

Postby Chris Auckland » Mon May 13, 2013 10:21 am

Thanks for your post.

I've seen this sort of thing occur with some minor corruptions in the database schema before. The most recent one that springs to mind was related to extended properties.

When you receive the error, are you able to submit the error report with your email address? That should hopefully give us a clue to where the process is failing.
Chris Auckland
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests