The project properties are displayed in the Properties window when you click on an object in the Project window. The properties change dynamically when you click on the individual folders or files in a project and can be edited in the Properties window. Properties that cannot be edited are grayed out. All properties that you define for a folder (or sub-folder) are automatically inherited by the files that are contained in that (sub-)folder. You can, however, break that tie by defining separate properties for individual files or sub-folders.
If you have defined properties for the different folders in the Project window, any file that you add to your project will inherit these properties from its parent folder. You can change the properties for a file at any time. DatabaseSpy displays properties that deviate from the parent folder's values in bold type. Once you have changed a property of a file, the link between the file's property and its parent folder's property is broken and will also not be restored by choosing the identical value in the file's drop-down list. You can, however, restore the folder-file connection by using the respective command in the context menu.
Let's assume you have defined a sub-folder for SQL Server-related files in your Project window, and that you have set the Database Kind property to "MS SQL Server" for that sub-folder (see screenshot below). Since no properties have been defined for the parent SQL folder, the Database Kind property appears in bold type.
The file SelectHostByYear.sql in the SQL Server folder inherits the properties from the SQL Server folder and the Database Kind property therefore appears in normal font type. However, the Data Source and Root Object properties have been changed and the SQL Editor should require semicolons check box has been activated, and these three properties are displayed in bold type.
If you deactivate the SQL Editor should require semicolons check box again, the property will still be displayed bold although the value is now identical to the parent folder's value (see screenshot below). This indicates that the tie between the folder's properties and the file's properties has been broken and—although currently identical—an individual value has been defined for this property.
Once a property has been changed for an individual file, the tie between the file and its parent folder can only be re-established via the Restore value to parent's option context menu command.
|1.||In the Project window, select the file and right-click the property you want to reset in the Properties window.|
|2.||Choose Restore value to parent's option from the context menu. The file inherits the property from the parent folder again.|
For the project itself, the path to the project file and, optionally, a description are displayed in the Properties window.
Data source properties
You can define in the data source properties to automatically connect to the data source when the project is opened. To do so, activate the Connect on Open Project check box in the Options section of the data source properties.
The Global Resource check box is activated if the data source has been added to the projects as a global resource. Note that this property cannot be changed by deactivating the check box. You must copy the global resource into the project and remove the global resource from the project to convert a global resource into a local one.
The Use ODBC Native Interface check box is for advanced users who may wish to retrieve structural information about their databases using the API methods provided from ODBC directly rather than DatabaseSpy's internal SQL queries. This might be desired when the user is experiencing difficulties retrieving data, or feels the application is too slow when retrieving this information. The down side to this approach is that the amount of structural information that the user can retrieve via the ODBC interface is limited.
The Driver Information section lists name, version, issuing company, file name, full path, and date of the driver that is used for the selected data source connection.
You can also manually edit the connection details in the Connection section of the data source properties but keep in mind that a project might not be able to establish a connection to the data source if the connection properties have been manipulated. For security reasons, the password for the data source connection cannot be edited directly in the Properties. If you double-click into the Password field, an extra dialog box opens where you have to enter the existing password before you can define and confirm a new password.
Detailed properties of the individual database objects can be viewed by selecting the respective database object in the Online Browser. You must connect to a data source before you can view its database objects in the Online Browser.
SQL folder properties
When you select the SQL folder in the Project window, you can edit the properties that apply to the entire folder and are inherited by all files contained in this folder. These properties can be overridden by properties that you define on file or sub-folder level.
The General section provides three drop-down lists for database kind, data source, and root object as well as text fields containing the folder and project names. The Description section shows a text field for entering a description. Please note that the properties for database kind and root object are filled in automatically when you select a data source from the drop-down list. However, you can then change the root object, if applicable.
Design and Favorites properties
For the Design and Favorites folders, the Properties window provides drop-down lists for database kind, data source, and root object. In addition, a text field for entering a description is available. The Design properties include also a text field displaying the project name.
Data Diff properties
In the Data Diff folder, DatabaseSpy displays statistical information on the comparison file, and you have the possibility to edit the compare options as well as the options for string and xml comparison and the merge execution options on file level.
Schema Diff properties
In the Schema Diff folder, DatabaseSpy displays statistical information on the comparison file, and you have the possibility to automatically start a comparison when the document is opened.
© 2019 Altova GmbH