In the file browser, navigate to the directory that will store DDL files of a data source and click Open. In the Data Sources and Drivers dialog, select the DDL data source, and click Add directories or DDL files. To configure code settings for the DDL data source, see Configuring DDL generation settings. In the Database Explorer ( View | Tool Windows | Database Explorer), right-click a data source that you want to dump to a DDL data source and select Import/Export | Dump to DDL Data Source. Dump an existing data source to a DDL data source When you dump DLL files to the existing DDL data source, the excluded ones will be ignored.
Use file scopes to filter the files and folders that are used as sources for the DDL data source. If you already have a DDL data source for the selected data source, you can choose whether to dump DDL files to the existing DDL data source or create a new one. You can do the other way around and attach a directory with SQL files that contain DDL statements and drag them from the Files tool window to the Database Explorer. When you create a DDL data source, the folder with SQL files for this data source is automatically attached in the Files tool window.
