Home Files: Importing and Exporting

# Exporting to a SQL text File

SQLEditor can export a database design to a text file, which is can then be imported into a database using a suitable tool.

This is useful if you have a database running on a remote server and you cannot use JDBC to connect to it.

1. Choose File→Export To File...
2. Choose the export dialect that matches the database system that you are using
3. Enter a suitable name for the new file
4. Click Export

A new document will appear containing all of the objects that SQLEditor was able to read in the file.

If SQLEditor had difficulties reading the file then the Status Panel will appear with details of the errors.

See also The Status Panel The dialect in the export window is preset to match the document dialect