oracle - 如何在 oracle apex 中导入导出现有应用程序

Question

我们可以在 Oracle Apex 中导入导出现有应用程序吗？

我的意思是，一个应用程序在生产中，但在添加一些我想要增量导出/导入的页面后在开发中。

我试图导出/导入，但由于它的 id 已经存在，所以它用旧的替换了新的。

标签： oracleoracle-apex

Answer 1

Apex does not have fine grained change control but there are some tools:

In apex 20.1 you can "export as zip". That will give you a zip file with all the application components as indidvidual files. If you take an export of the app before and after the change, then you can use a version control sytem (like svn or git) to determine what components have changed between 2 versions. Note that this is on component level, so you'll be able to see that Page 2 changed, not the details.

Alternatively, there is a tool available called APEX Diff, written by Martin D'Souza, on https://www.oraopensource.com/blog/?category=APEX+Diff. This tool uses sqlcl to generate a json representation of your application with as only goal to be able to do a diff between 2 applications. I don't know if this tool is up to date with the latest versions.