How can I copy entities from test DB to production DB? (OpenInsight 32-bit Specific)
At 26 FEB 2010 01:13:05PM Dietrich K. Neuman wrote:
Weve got an AREV32 application running on OI 9.0. Weve also got a test environment; a separate copy of OI, installed in another directory, with a copy of our production database copied over some months ago. Ive been writing enhancements to the application altering code, and developing new OI forms and Client/Server Connection objects in the test environment. Were almost ready to deploy these in the production environment, and I was wondering, is there a simple way I could copy these forms, Connection objects, and table rows with the new code to the production environment? I could just pull up Form Designer and C/S workspace in the production environment and recreate the entities by hand, and copy and pasted the new code, but if theres a quicker and more dependable way to copy the new stuff over Id love to use it.
At 12 MAR 2010 09:51AM Jared Bratu wrote:
There are several different options and you'll have to experiment and come to a roll out process that works for your organization. Here are a couple suggestions you can try.
The RDK process is a very specific process to define what to roll out and how to package it (i.e. NSIS installer or repository files). This is your best approach for specific item by item upgrades.
The window APPBACKUP could also be a tool to move all of your development resources into the production system. As the name implies it is designed to backup/restore applications but it could also take the entire development app and restore it over the production app. Be sure you don't copy your data tables or you'll overwrite the production data (check box on screen).
Hope this helps.