- Apex sql tools how to#
- Apex sql tools manual#
- Apex sql tools software#
In this video you can see a short description and a longer demo on how to actually use the project, understand the possible workflows and how to set it up. It should work for most operating systems, it was tested on Windows, MacOS and Linux. make changes in the database and spool it into the filesystem for deployment continously. use it only once at the beginning to create a baseline of files, then only make all future changes through those files under version control. This enables you to support different workflows: The exporter uses SQLcl together with DBMS_METADATA to export Oracle database objects, APEX applications, ORDS REST modules and everything as files into the filesystem. It can be configured in multiple ways so that there is no requirement for a specific layout of the filesystem. It uses regular expressions in order to figure out a mapping between a file system path and the matching connection pool. It will execute SQL files which it finds by iterating through the filesystem and listing all files that exist. The installer uses SQLcl under the hood to actually run the SQL scripts. It works nicely with Git / Subversion and supports working from the file system, from the DB or a mix of both. The real magic happens through the generated batch scripts that leverage these command-line tools. Actuall, it embeds the libraries of SQLcl so that no additional software is required (only Java8+). The software is written in Java and leverages Oracle SQLcl and DBMS_METADATA. This way exporting Oracle APEX and Oracle ORDS applications is possible without additional software, e.g. No separate tools / installation required, Oracle SQLcl libraries are embedded in the download.Getting started is easy, shell scripts are pregenerated during setup, only need to be customized.Highly adaptable through configuration files and command line switches, you are not stuck with our way of doing things.Comes with sound and proven default settings (used in actual client projects since Oct/2019).Automatic log generation in logfiles and database tables.Don't manually code your release - configure it.
Automate your typically manual process of running sql scripts in the desired order.Do you have an approach to move your Oracle code changes (PL/SQL, APEX, ORDS) from your development environment to test and production? Or are you unhappy with your existing one, get errors during installation, miss changes that were not deployed or don't know when you deployed the changes into which environment? Benefits
0 kommentar(er)
