Red Gate forums :: View topic - Encrypted Procedures not synchronized on SQL 2005 Target DB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

Encrypted Procedures not synchronized on SQL 2005 Target DB

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
beardedfreak



Joined: 17 Mar 2008
Posts: 1

PostPosted: Mon Mar 17, 2008 12:52 pm    Post subject: Encrypted Procedures not synchronized on SQL 2005 Target DB Reply with quote

Hi,

We use the SQL Toolkit (version 5.3) to update our clients installations with the latest schema from a snapshot of our SQL 2000 development database.

Much of our business logic is located within stored procedures (over 750) which are all encrypted to protect our intellectual property (and prevent tampering).

Several of our clients are using SQL 2005 and our upgrade process is now failing. A manual sync between SQL 2000 and SQL 2005 gives the following warning: "[object] cannot be decrypted. Its contents cannot be compared and it cannot be synchronized."

I was planning to blindly update all procedures, functions and views in the target DB but cannot achieve this through the 'BuildFromDifferences' method. Is this functionality available in version 6?

If the objects have to be scripted seperately, which is the best way to deal with the interdependency as I assume they must be dropped and then recreated in the correct order. We have Packager and could possibly create a script to apply after the table syncronization. I'm not a fan of the seperate script because the table sync may complete successfully but the procedure script may fail leaving the DB in an unknown state - possibly requiring a restore on a Production DB.

Any help or advice would be greatly appreciated.
Many Thanks
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Tue Mar 18, 2008 1:45 pm    Post subject: Reply with quote

Hi,

There isn't much that I can suggest except to drop the encryption from all of the stored procedures. SQL Compare could compare encrypted objects only because of an exploit on SQL Server 2000 (It's not terribly serious -- the user running SQL Compare has to be logged in as a SYSADMIN).

SQL Server 2005 closed this hole, so the encrypted objects can no longer be decrypted. SQL Compare Engine 6.x still lacks the capability to decrypt objects on SQL Server 2005 and it may not be possible and/or feasable to do this in the future.

Sorry about the confusion.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group