プロジェクトプロパティ

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  DatabaseSpy プロジェクト > プロパティ >

プロジェクトプロパティ

プロジェクトプロパティ are displayed in プロパティウィンドウ when you click on an object in プロジェクトウィンドウ. The properties change dynamically when you click on the individual folders or files in a project and can be edited in プロパティウィンドウ. 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.

 

プロジェクトウィンドウ内で、異なるフォルダーのためにプロパティを定義した場合、プロジェクトに追加されたファイルは親フォルダーからこれらのプロパティを継承します。ファイルのためにプロパティを変更することができます。 DatabaseSpy は、太字で親フォルダーの値から誤差のあるプロパティを表示します。ファイルのプロパティを変更すると、ファイルのプロパティと親フォルダのプロパティ間のリンクは切断され、ファイルのドロップダウンリストから同じ値を選択しても復元されません。 コンテキストメニュー内で、対応するコマンドを使用してフォルダーとファイル間の接続を復元することができます。

 

サンプル

Let's assume you have defined a sub-folder for SQL Server-related files in your プロジェクトウィンドウ, and that you have set the Database Kind property to "MS SQL Server" for that sub-folder (下のスクリーンショットを参照してください)。 Since no properties have been defined for the parent SQL folder, the Database Kind property appears in bold type.

tab_project-sql-properties

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, データソース and ルートオブジェクト properties have been changed and the SQL エディター should require semicolons チェックボックス has been activated, and these three properties are displayed in bold type.

tab_properties-individual-sql

If you deactivate the SQL エディター should require semicolons チェックボックス again, the property will still be displayed bold although the value is now identical to the parent folder's value (下のスクリーンショットを参照してください)。 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.

tab_properties-individual-identical

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 コンテキストメニューコマンド.

 

 

To reset a file's properties to its parent folder's options:

1.プロジェクトウィンドウ内で、 ファイルを選択し、 right-click the property you want to reset in プロパティウィンドウ.
2.Choose Restore value to parent's option をコンテキストメニューから選択します。 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 プロパティウィンドウ.

 

データソースプロパティ

You can define in データソース properties to automatically connect to データソース when the project is opened. To do so, activate the Connect on Open Project チェックボックス in the Options section of データソース properties.

 

If you prefer to view データソース in the オンラインブラウザー also when they are not connected, you can activate the Always show in オンラインブラウザー チェックボックス which is also located in the Options section.

 

The グローバルリソース チェックボックス is activated if データソース has been added to the projects as a グローバルリソース. Note that this property cannot be changed by deactivating the チェックボックス. You must copy the グローバルリソース into the project and remove the グローバルリソース from the project to convert a グローバルリソース into a local one.

 

The Use ODBC Native Interface チェックボックス 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 データソース properties but keep in mind that a project might not be able to establish a connection to データソース if the connection properties have been manipulated. For security reasons, the password for データソース connection cannot be edited directly in the Properties. If you double-click into the Password field, an extra ダイアログボックス opens where you have to enter the existing password before you can define and confirm a new password.

 

Detailed properties of the individual データベースオブジェクトs can be viewed by selecting the 個々の データベースオブジェクト in the オンラインブラウザー. You must connect to a data source before you can view its データベースオブジェクトs in the オンラインブラウザー.

 

SQL フォルダープロパティ

When you select the SQL folder in プロジェクトウィンドウ, 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 ドロップダウンリストs for database kind, data source, and ルートオブジェクト as well as text fields containing the folder and project names. The 説明 section shows a text field for entering a description. Please note that the properties for database kind and ルートオブジェクト are filled in automatically when you select a data source from the ドロップダウンリスト. However, you can then change ルートオブジェクト, if applicable.

 

Design and Favorites properties

For the Design and Favorites folders, プロパティウィンドウ provides ドロップダウンリストs for database kind, data source, and ルートオブジェクト. 更に、 a text field for entering a description is available. The デザインプロパティ 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.


(C) 2019 Altova GmbH