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
 DBGhost Plus Package dropping indexes
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ratbert9999


2 Posts

Posted - 06/30/2015 :  17:40:43  Show Profile Send ratbert9999 a Private Message  Reply with Quote
We are using DBGhost Plus packages to that create the stand alone database packages we update a customers sites. One our customers added some custom indexes into one our product databases for their own use. We recently ran an database update package at that customer site and they saying that their custom indexes they added are now missing. Question I have is there any options in DBGhust configuration that says to remove indexes in a target database?

There one option we have unchecked under "Comparison setting for objects and data" section which is "Remove everything from the target that doesn't exist in the source (Clean Up)". Is some other option we need to set so it would not drop indexes in target database?

Google AdSense

USA
Mountain View


dbghost



66 Posts

Posted - 07/01/2015 :  07:12:32  Show Profile  Visit dbghost's Homepage Send dbghost a Private Message  Reply with Quote
If there are parts of the target schema that you don't 'own' (the bits the customer has added) you can tell DBG compare to ignore them using the partial upgrade screen to enter a regular expression filter.

For example if your customer always names the indexes like this "Custom...." the filter string NOT@Custom will tell the compare code to ignore those indexes.

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