Moving a database from a 11.3 instance to a 11.6 instance on

Posted by simonc on 20-Oct-2017 07:56

Hello,

I'm planning to upgrade a LOB application which has a live and test version installed on the same server.  The current version is compatible with OpenEdge 11.3 and the new version requires 11.6.  Budget constraints mean the upgrade must be done on the same server.

My plan so far involves installing 11.6 along side 11.3 and upgrading the test version of the application first.  Can I just back up and restore the database from 11.3 to the 11.6 instance?  My Background is in MS SQL Server and Oracle so apologies if I'm using the incorrect terminology!

Regards,

Simon

Posted by Rob Fitzpatrick on 23-Oct-2017 10:34

- Install 11.6 on the server alongside 11.3.

- Back up the current test DB with 11.3 and restore to a new location.  

- Using 11.6, update the schema of that new database:

proutil dbname -C updateschema

proutil dbname -C updatevst

Be sure that those commands run with the 11.6 installation, not 11.3.  

- Upgrade your application schema.

- Update data as needed.

All Replies

Posted by Rob Fitzpatrick on 23-Oct-2017 10:34

- Install 11.6 on the server alongside 11.3.

- Back up the current test DB with 11.3 and restore to a new location.  

- Using 11.6, update the schema of that new database:

proutil dbname -C updateschema

proutil dbname -C updatevst

Be sure that those commands run with the 11.6 installation, not 11.3.  

- Upgrade your application schema.

- Update data as needed.

Posted by simonc on 31-Oct-2017 10:56

That's great thank you Rob

This thread is closed