Overwriting encrypted objects

mpeschka

Is there any way to force SQL Compare to overwrite encrypted objects? I prefer to set WITH ENCRYPTION when deploying databases from development to production, but on SQL 2005 this poses a problem since SQL Compare won't later overwrite those.

Thanks!

- Mike

Michelle T

Currently I'm afraid you'll have to drop the encrypted object before you can synchronize a new object across - SQL Compare doesn't let you synchronize on top of encrypted objects. I've put your feature request in the database and we'll take a look at it.