This action is started by right clicking on the desired sketch from the overview and selecting Export to SQL server from the popup menu. If there is currently no active connection to a database, the user is prompted for connection information and database parameters. The following is a list of the database parameters.
Create database: Set database definition to create a new database.
Drop database before creating: Available if Create database enabled. Sets database definition to drop an existing database in the event of a naming conflict.
Drop and recreate schema (PostgreSQL only): Sets database definition to drop and recreate a schema in the event of a naming conflict.
Use BIGINTs instead of INTs for keys: Enabling this option changes the type of foreign key columns and the primary key columns to which they point from the default of int(11) to bigint(20).
Once a connection is established, the sketch (and its views) are converted to SQL code (see notes on shadow edges) and sent to the server. The database is created and the sketch is opened in data manipulation mode. The user can now interact with the new database. Note that this export action can also be found in the file menu of the sketch window - File | Export to | SQL server.
To export a sketch to an XML file, right click on its representation in the overview and select Export sketch to XML from the popup menu. The action can also be fired through the menu bar in the sketch window - File | Export to | XML. Select where the XML is to be saved and click OK. Note that all views of this sketch are automatically exported. Note also that these XML files are given a .sketch extension. See import sketch for details on importing.
This action can be fired from the file menu of the sketch window - File | Export to | SQL text file. The following steps are then taken to export the sketch to an SQL text file.
Select SQL dialect (MySQL or PostgreSQL).
Select database parameters.
Enter database connection options
Database name: The name used for the new database.
Schema name (PostgreSQL only): The name used for the new schema.
Identifier quoting: See identifier quoting for details.
Select where the SQL text file is to be saved and click OK. See shadow edges for details on auto-generated SQL code.
This action can be fired from the File menu in the sketch window - File | Export to | Image. Select where to save the image file and click OK. The default image type is png. The image type is specified by including its extension in the filename. Supported image types are png, jpeg, gif, and bmp.