You can open projects by navigating to SQL Project Explorer and expanding the node of the project that contains the files you want to access.
Below each project name are a series of nodes that categorize any existing SQL files by development type:
- Connections. Lists the connections of any given SQL file of a data source associated with the project.
- Creation Scripts. General data source object development scripts. This node contains DDL statements and statements that define database objects.
- General SQL. Provides a category for all other SQL files that are not used in database object creation. DML files, etc.
- Large Scripts. Contains all files larger than the currently set SQL Editor preference. The file size limit can be modified on the Preferences panel. (Choose Window > Preferences in the Main Menu to access the panel.)
Physically, the projects and files you create as you work in DB Optimizer are stored under the project directory that you specified at the prompt when the project was created. The directory and files can be shared, and other tools may be used to work on the files, completely exempt from the DB Optimizer development environment.