02-05-2015 01:36 PM
Has anybody tried using a Database Source Control program like http://www.red-gate.com/ to handle configuration migration changes?
We have a very strict Dev / Prod environment setup and the idea of translating everything manually after a development cycle, especially a major project is not practical.
The other option for us is to use the config migration tool from dev to prod, but i know thats not realy recommended. Just looking for other options.
thanks!
02-06-2015 03:01 AM
02-06-2015 04:08 AM
Stephen,
We use Red Gate for our home grown applications and it is a wonderful tool. While you could use it to just run a scan to see differences in Dev vs. Prod related to OnBase, you'll still need to transfer everything manually since you can't run any direct scripts against an OnBase database (this includes both DDL and DML). As you alluded to, one option is Configuration Migration. This module had its share of issues in earlier versions, but it's significantly better now. If you're a Workflow shop then Workflow Import/Export is the way to go for anything related to those changes (you can even migrate other types of objects by assigning them to a dummy lifecycle even if they're not meant to be a part of Workflow).
For things like File Cabinets/Folders, it's a manual process. There's an SCR out there somewhere for an import/export feature, but I don't think that it's ever made it in to the mix.
Nick McElheny
Database Administrator | Trover Solutions, Inc.
02-06-2015 04:39 AM
In OnBase 14 we introduced export and import wizards into Configuration to export basic types (Document Types, Keyword Types, and Folder Types are the major ones). In future versions we're going to be expanding the list of supported items and enhancing usability.
These are available in the Utils menu under Export Configuration Items and Import Configuration Items
02-06-2015 05:12 AM
Thank you Hyland for working on more systematic ways of migrating changes, as manual efforts are error prone and tedious.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.