SQL Resolution Scopes
This page lets you specify the data sources, databases and schemas that should be used to resolve unqualified (short) names of database object in your SQL files.
Settings
Item | Description |
---|---|
Project mapping | The set of data sources, databases and schemas used by default by all the SQL files in your project to resolve unqualified names of database objects. |
Path / Resolution Scope | Mappings for individual files and directories. If nothing is specified in this section, all the SQL files in your project use the project mapping. To specify a different mapping for a file or directory, click and select the file or directory in the dialog that opens. Then click or the Resolution Scope cell, and select the necessary data sources, databases and schemas. The mappings specified explicitly are shown in black. The mappings inherited from a higher level (unless you close the dialog) are shown in gray italic. |
Example
You have two data sources, one for your production database and the other one - for your test database. The tables in both databases have the same names but slightly different structures. And you keep the SQL scripts for your production and test databases separately, in two different folders.
In such a situation, you'd map the folder with the production scripts onto the production data source, and the folder with the test scripts onto the test data source.
The other possibility would be to use the project mapping for your production data source and specify the mapping for the test scripts folder separately, or vice versa.