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.