SQLEditor supports several different import and export formats. However these formats don't support all of the options that SQLEditor uses internally.
With SQLEditor a native format can preserve all options and settings. This includes document level details such as document dialect and window settings, along with object level attributes such as size, position and label.
Any other format is considered a foreign format.
So, if you export your document to a foreign file format or a database and then import it back into SQLEditor, the document you get out may not be the same as the document you had originally.
| Format | Extension | Type |
|---|---|---|
| SQLEditor Schema Document | sqs | Native |
| SQL Text File / SQL Script File / SQL Database Dump | sql | Foreign |
| Ruby On Rails Migration | rb | Foreign |
| Database (Via JDBC) | rb | Foreign (1) |
(1) Database export cannot preserve all options currently.
The only Native Format for SQLEditor currently is the SQLEditor Schema Document format (extension sqs).
Use File->Save... or File->Save As... to save files in the native format.
Other formats are called Foreign Format files. This currently include exported SQL dump files (extension sql) and Ruby on Rails Migration class files (extension rb).
Use File->Export To File... to save files in a foreign format.
SQLEditor does not currently store its own information in a database when it performs an export. This is being considered as an optional feature for a future release.
Use File->Export To Database... to export to a database.
To contact us with a support issue please email:
