Schema Compare - ignore object type settings aren't applied

Question

Hi, 

I am using the Data/Schema Compare tool in Visual Studio Ultimate to extract the changes applied to a development instance.  The tool correctly identify the changes, however, it ignored the Object Types setting in Schema Compare Options and tried to reverse engineer objects I don't have permission to access.  How can I fix this?

Thanks.

Answer 1

Hi xinonnet,

Based on your description, it seems that Ignore selected object types option does not work when you do the schema comparison.

To better understand your scenario:
1). What version of VS you are working with? VS2012 or VS2010?
2). For which kind of object you would like to ignore.
3). If you choose to ignore another type database object, will you get the same issue?

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi xinonnet,

What about your issue now? Have you resolved it? If not, please kindly offer me more information.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi, the issue was related to

"An error was received from SQL Server while attempting to reverse engineer elements of type Microsoft.Data.Schema.Sql.SchemaModel.ISql100DatabaseEncryptionKey: The user does not have permission to perform this action."

VS 2010 SP1 downgraded the error to a warning to allow Schema Compare to run through.

Thanks.

Answer 4

Hi xinonnet,

Please try to ingore the Database Encryption Keys on the Schema Compare Options dialog to see if it helps.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us