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
Cybersecurity
DevOps Cloud
IT Operations Cloud
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
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
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".