You create projects to organize and store SQL development files. The purpose of projects is to keep your work-in-progress files organized, as well as maintain a common directory structure when developing code and executing files on registered data sources. Once a file has been developed and is ready for deployment, that file can then be executed on a registered data source.
SQL Project Explorer is used to view and access files. It uses a tree view to display the project as a series of folder directories with a folder labeled with the project name as the parent directory, and with project categories, and associated project files as its children.
All files in an SQL Project project are organized under the following categories:
- Connections. List the connections of any given SQL file of a data source associated with the project.
- Creation Scripts. Provide DDL statements and statements that define database objects.
- General SQL. Provide a category for all other SQL files that are not used in database object creation. This includes DML files, and so on.
- Large Scripts. Contain all files larger than the currently set SQL Editor preference. The file size limit can be modified on the Preferences panel by selecting Window > Preferences in the Main Menu.
Physically, the projects and files you create as you work in DB Optimizer are stored under the Workspace directory you specified at the prompt when DB Optimizer was started. The directory and files can be shared, and other tools can be used to work on the files, outside the DB Optimizer development environment.
You can move existing files within a project by clicking and dragging the file you want to move in the Project Explorer from one node to another, or via the File > Move command.
- Create a new SQL project
- Open an existing project
- Search a Project
- Add files to a project
- Delete a Project