Activity overview
Latest activity by mah530
thank you for the reply. looks like I will not be able to use SQL compare.
Please consider adding the option to 'Ignore WITH ENCRYPTION' in a future release of the product.
Thanks / comments
thank you for the reply. looks like I will not be able to use SQL compare.
Please consider adding the option to 'Ignore WITH ENCRYPTION' in a future release of the product.
Thanks
Is there any way for me to modify the ObjectIn1, ObjectIn2 properties before doing the compare? Would I have rights to modify the text in these objects (trigger text, stored proc text, etc)? I would want to remove the 'WITH ENCRYPTION' phrase before the actual compare is performed.
Is this possible? Without me having to write the actual compare process? / comments
Is there any way for me to modify the ObjectIn1, ObjectIn2 properties before doing the compare? Would I have rights to modify the text in these objects (trigger text, stored proc text, etc)? I w...
How do I acces the text property - didn't see it in the Difference class
Thanks / comments
How do I acces the text property - didn't see it in the Difference class
Thanks
I started looking at the SQL Compare SDK - to see if I could try to do this myself.
Could I try creating new Option Type - "IgnoreWithEncryption" - that would be processed in similar way as the existing option type "IgnoreWithNocheck"? Only difference would be that it would look for the WITH ENCRYPTION phrase in the object text, rather than the WITH NOCHECK on foreign keys and check constraints.
Is it feasible? or are all needed classes sealed/unavailable to me?
Thank you! / comments
I started looking at the SQL Compare SDK - to see if I could try to do this myself.
Could I try creating new Option Type - "IgnoreWithEncryption" - that would be processed in similar way as the ex...
That makes things very difficult here, because 90% of the time we will be trying to verify/synch the encrypted version against our master database which will never be encrypted.
This means visually checking each object to see if the 'difference' is only due to the encryption phrase. Thousands of objects.
I am interested in any workarounds that you could think of. I was considering scripting the encypted db, and removing the 'with encyption' , and then comparing it to the master d...but, I don't think I can even generate a script against the encypted objects...
Any other workaround ideas??
Thanks / comments
That makes things very difficult here, because 90% of the time we will be trying to verify/synch the encrypted version against our master database which will never be encrypted.
This means visuall...
How to ignore the 'WITH ENCRYPTION' phrase ?
I need to compare the objects in two SQL 2000 databases. In one database, all of the objects are encrypted, in the other they are not. ( This will always be the case). When I compare the obje...