Synchronization in ClearSQL

To avoid the risk of losing or damaging valuable information, the main principle we instilled into ClearSQL is that you never have to work with sources.

De facto, you are working with precise copies of the source data, which gives you freedom and a chance to make mistakes without any risks.
As a first step, you are prompted to:
1. Сreate a Project.
2. Import scripts to it.
3. Then carry out necessary manipulations.
Imported files can be: PL/SQL scripts, Oracle Forms & PL/SQL libraries, and Oracle database objects, imported from both your file system and Oracle database.
Bidirectional relationship
Assuming the source files can be updated, recreated, or dropped without your assistance, it's handy to synchronize imported data with its original sources and work with the latest versions only.
Tilda Publishing
Synchronization in ClearSQL is bidirectional:
source2project
project2source
In other words, you can overwrite already imported scripts from their sources and, vice versa, write back changes from the Project to the source (the latter cannot be undone!). Synchronization is flexible meaning you can unlink or relink established connections and check if you are using the latest edition of the code by validating it.
To keep track of the modifications, ClearSQL automatically creates different script versions after each source2project synchronization. The history of changes is saved, so you can always restore the version you need, or compare them against one another. On the whole, there are three types of comparison:
1
Project script vs. Source script
2
Project script version 1 vs. Project script version 2
3
Project script A vs. Project script B
Detected differences are highlighted with distinctive colors and shown in two parallel panes, similar to the UI of typical comparison tools.
Taking into consideration complex structure of PL/SQL systems, with its hierarchy and multi-levelled organization, we empowered ClearSQL with flexible synchronization settings. These allow you to adjust common sync behavior for the whole Project as well as for specific types of imported items.
Helpful?