Create a project
To start working with ClearSQL, create a ClearSQL project and import scripts that you would like to analyze. A ClearSQL project may include PL/SQL scripts, Oracle Forms & PL/SQL libraries, and Oracle database objects, preliminarily imported from the file system and Oracle database, and, if needed, synchronized with their sources.

Once the scripts get into the project, they are gathered into a hierarchically structured Project Tree shown in the main window. To start working with the scripts, run a project analysis so that ClearSQL can build any information about the imported code. Once analysis completes, the results will be shown in the tabs on the right from the Project Tree.

The project is just a container of scripts so you can safely add or remove them from the project without the risk of losing valuable data.
To automatically create a project
1
Start ClearSQL, and click Analyze in the startup window.
2
Choose a folder with the scripts that your would like to analyze.
3
Click Analyze. ClearSQL will create a new project and immediately analyze the imported scripts. The project will appear in the Project Tree panel in the main window.
To create a new project
1
On the File menu, click New Project.
2
Enter a project name and click OK.
3
Use the database tree on the From Database tab to import database objects or whole schemas.
4
Use the database tree on the From Database tab to import database objects or whole schemas.
To import database items, you will be prompted to connect to a database first.
5
On each tab, click Add to import checked items to the project.

OR

Click Add & Link to import checked items to the project and link them to their sources in the file system/database.
6
Click Create. The project will appear in the Project Tree panel in the main window.
To switch between recent projects, on the File menu, click Recent Projects, and then select the preferred project from the list.
This document was last updated on February 21, 2020
Helpful?