Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Best way to deploy ORDS application to another environment?

CortanamoDec 27 2017 — edited Jan 7 2018

Hi all,

Assuming that you built a not so small application with ORDS and everything is nice and fine, what would be the best way to deploy it into the production / some other environment (different Oracle instance)?

Regretfully "Installation, Configuration and Development Guide" doesn't tell anything about deployment (or it's not obvious where the deployment part resides).

Obviously, clicking it all together in SQL Developer is not a serious option, since it's too much work and way too error prone.

I can see that you could define everything with PL/SQL packages for REST data services (ORDS.Create_Module...), which would give you a code base to deploy to another environment.
However, if you did your development using SQL Developer instead of ORDS. packages, is there a way to deploy ORDS repository to another environment?

Is there a utility tool to use for deployment?

If anyone can point me to the right direction that would be great.

Best regards,

C

Comments

Cortanamo

Apparently documentation mentions ORDS_METADATA schema. I suppose that exporting it from one to the other instance should be sufficient, plus maybe enabling ORDS for schemas and tables that should be accessable to ORDS. But this looks like a bit of a workaround. Is there really nothing better?

there's 2 pieces, ORDS, and the Services.

ORDS can be moved by simply packing up the WAR file and moving to the new location, or just re-installing it.

The services are defined in the REST-enabled schema.

You can export the modules to PL/SQL scripts, which can then be ran in your new environment.

I'd recommend you Source Control these scripts, so you can track changes, and easily build deployment/upgrade packages.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 4 2018
Added on Dec 27 2017
2 comments
766 views