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
mpeschka
0

Comments

1 comment

  • 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.
    Michelle T
    0

Add comment

Please sign in to leave a comment.