Extracting Configuration/Initialization Statements

Go Up to Working with Configuration/initialization Parameters

You can extract the following statement types corresponding to the DBMS-specific methods for setting server configuration/initialization parameters.

MySQL	SET... SET GLOBAL...
ORCL	ALTER SYSTEM SET
SQL SVR	RECONFIGURE/GO/EXEC sp_configure
SYB ASE	EXEC sp_configure

To extract configuration/initialization parameter statements

1. Open the Datasource Explorer as configuration/parameter nodes are not visible in the Navigator. For more information, see Working with Bookmarks.
2. Connect to the datasource for which you want to view the server configuration/initialization parameters or options. For details, see Connecting to Datasources.
3. Display the configuration/initialization parameters or options for the server. For details, see Working with Configuration/initialization Parameters.

   The server configuration parameters are displayed in the right pane of the Explorer.

4. In the right pane of the Explorer, right-click one or more selected parameters and select Extract. The DDL Editor opens. For more information, see Using the SQL Editor.

For related information, see Modifying Configuration/Initialization Parameters and Options.