I need somewhere to rant so please excuse me for a few moments.
OE 11.7.12/13.
Once a month we copy the backup from live to UAT and restore it, and anonymise the data in it for GDPR reasons. This process takes a long time, but it's manageable. This is standard operation. UAT is a different server to Live, naturally.
Recently we implemented Pro2SQL, using CDC policies, in live. Pro2 gives you a single machine license for CDC, so therefore we don't have CDC licenses in UAT. Progress allows you to restore a CDC enabled database with policies on a machine without CDC licenses, but that's just about it. Once it's restored, you can't even disable CDC as you get an error telling you there are policies. You can't connect to the database in single user mode, let alone proserve it. So you can't connect to it and remove the policies.
Even with a CDC license you have to execute code to remove the policies (and if there is any tracking data you have to remove that too).
Progress's official method for doing what we do is to restore the backup onto the Live machine, remove the policy and tracking data, disable CDC and then back that database up again, transfer it to UAT and carry on as before. Our database isn't massive, but at around 300GB that's a lot of extra space, and time, for a process that is already not fast.
Progress have created a utility to do the job without a license, but it's only available in 12.5+. So it's not in any LTS release. And won't be in any LTS release until they release the next one. They view this as new functionality, not a bug fix.
Surely I can't be alone in this? In fact I know I'm not, because the idea for the utility in 12.5 came from the ideas board in the community. This is more than an inconvenience.
Ironically it's not an issue for our development server as this has a development server license where you can evidently serve up a CDC enabled database without issue.
OE 11.7.12/13.
Once a month we copy the backup from live to UAT and restore it, and anonymise the data in it for GDPR reasons. This process takes a long time, but it's manageable. This is standard operation. UAT is a different server to Live, naturally.
Recently we implemented Pro2SQL, using CDC policies, in live. Pro2 gives you a single machine license for CDC, so therefore we don't have CDC licenses in UAT. Progress allows you to restore a CDC enabled database with policies on a machine without CDC licenses, but that's just about it. Once it's restored, you can't even disable CDC as you get an error telling you there are policies. You can't connect to the database in single user mode, let alone proserve it. So you can't connect to it and remove the policies.
Even with a CDC license you have to execute code to remove the policies (and if there is any tracking data you have to remove that too).
Progress's official method for doing what we do is to restore the backup onto the Live machine, remove the policy and tracking data, disable CDC and then back that database up again, transfer it to UAT and carry on as before. Our database isn't massive, but at around 300GB that's a lot of extra space, and time, for a process that is already not fast.
Progress have created a utility to do the job without a license, but it's only available in 12.5+. So it's not in any LTS release. And won't be in any LTS release until they release the next one. They view this as new functionality, not a bug fix.
Surely I can't be alone in this? In fact I know I'm not, because the idea for the utility in 12.5 came from the ideas board in the community. This is more than an inconvenience.
Ironically it's not an issue for our development server as this has a development server license where you can evidently serve up a CDC enabled database without issue.