Michelle Taylor wrote:I'm not sure what exactly you're asking for here - doesn't synchronizing the non-encrypted object over the encrypted object do what you want?
I'm trying to achieve the same thing (overwriting encrypted objects with newer versions), and it is not working. The comparison lists the objects as different, and indicates that they will be synchronized. But when you actually run the Synchronization Wizard, it states that the objects "cannot be decrypted. Its contents cannot be compared and it cannot be syncronized
." Viewing the generated SQL script shows that it indeed will do nothing.
Is there any chance to have this behavior changed in a future release? It's terribly annoying to have to manually delete all encrypted objects in the target database before synchronizing them over.