Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?




 All Forums
 Support
 DB Ghost Support Forum
 Stored Procedure Encryption
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

GrahamMcPhee


3 Posts

Posted - 06/05/2008 :  04:31:50  Show Profile Send GrahamMcPhee a Private Message  Reply with Quote
We have some databases which use encrypted stored procedures, however when differencing them with DBGhost the result is that the delta script drops the stored procedure from the target database, even if it has not changed. Is there any way of ignoring encrypted stored procedures so we can handle them separately?

Graham McPhee *Senior Configuration Manager*
Cirrus House Configuration Management Team
NHS National Services Scotland

Google AdSense

USA
Mountain View


leachm



125 Posts

Posted - 06/05/2008 :  04:33:55  Show Profile  Click to see leachm's MSN Messenger address Send leachm a Private Message  Reply with Quote
Hi Graham,

There has been some significant work in the encryption area in recent months - what version of Ghost are you using?

regards,

Malcolm Leach
You must be logged in to see this link.
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server
Go to Top of Page

GrahamMcPhee



3 Posts

Posted - 06/05/2008 :  04:50:24  Show Profile Send GrahamMcPhee a Private Message  Reply with Quote
Currently we are on 4.5.1866

Graham McPhee *Senior Configuration Manager*
Cirrus House Configuration Management Team
NHS National Services Scotland
Go to Top of Page

leachm



125 Posts

Posted - 06/05/2008 :  05:31:24  Show Profile  Click to see leachm's MSN Messenger address Send leachm a Private Message  Reply with Quote
In the latest version of the CompAndSync DLL (the engine behind the Change Manager) there are options to encrypt objects on the target database dynamically during the sync and delta script creation.

This means that you can have all stored procedures etc. in clear text on the source and let Ghost handle all the encryption on-the-fly thus saving you any manual workaround for encrypted objects.

Would that work for you?

regards,

Malcolm Leach
You must be logged in to see this link.
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server
Go to Top of Page

GrahamMcPhee



3 Posts

Posted - 06/05/2008 :  05:54:20  Show Profile Send GrahamMcPhee a Private Message  Reply with Quote
We currently only need a handful of stored procedures encrypted and ideally an option to not script the difference between encrypted stored procedures would have been ideal. However if you can supply the link to the latest version we will try that out.

Graham McPhee *Senior Configuration Manager*
Cirrus House Configuration Management Team
NHS National Services Scotland
Go to Top of Page

leachm



125 Posts

Posted - 06/05/2008 :  06:09:51  Show Profile  Click to see leachm's MSN Messenger address Send leachm a Private Message  Reply with Quote
I've sent you an email with the link to version 4.5.2074 in it. Please let me know how you get on.

regards,

Malcolm Leach
You must be logged in to see this link.
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free