Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    4
  • Views views
    397
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export customized fields from development database

HeshamMahmoud

Hello,

We have development and production database we need to export customized fields from some table from dev environment database and import it to production environment database, so is there any way to do that?

Regards,

Hesham Mahmoud

  • 0

    Yes, it is called "Integrate a customization".  Everything else being equal between the environments (database structure wise), perform the following...

    1 - Using Designer application connected to dev, export database structure (File menubar option)

    2 - Using Designer application connected to prod, integrate a customization (Actions menubar option) and use the least restrictive "Alter" choice when prompted (dialog box pop-up after stepping through the "Integrate a customization" wizard screens)

    Obviously, always take a backup of production first in case a restore is needed.

    If the number of customized fields is small, then it is better to just re-create manually.

    If everything else being NOT equal between the environments (database structure wise), then export database structure of both environments, using a comparison tool like WinMerge, compare / accept only the differences needed and integrate.

    To learn more, review help / documentation for "Propagating customizations".

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.