What are the challenges you face when working across database platforms? Take the survey
Options

Overwriting encrypted objects

mpeschkampeschka Posts: 11
edited September 26, 2007 1:20PM in SQL Compare Previous Versions
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

Comments

  • Options
    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.
    Software Developer
    Redgate Software
Sign In or Register to comment.