SQLEditor

Software Description

SQLEditor is a tool that allows you to create SQL databases graphically. You can create and edit table structures.

You can import and export designs to a JDBC compatible database, text files or save the designs as pdf images for the web or for print.See your databases rather than just reading about them!

Key features:

- Visual editing, including drag and drop

- Live source view - the SQL source changes as you edit the diagram

- Ruby On Rails Migrations - SQLEditor can export them and now (in v1.4) import them too!

- With SQLEditor's reverse engineering you can import existing databases to diagram and SQLEditor will create an ER diagram for you.

- Once you've created your diagram you can export it directly via JDBC to one of several supported database systems including Postgresql, Oracle and MySQL.

- You can save your database to an SQL instruction (DDL) file for immediate use on remote servers or with other tools.

- Import existing DDL files directly into SQLEditor

- Copy and paste to import and export supported SQL to and from SQLEditor

- You can print out designs so that you can see your database up on the wall.1 SQLEditor also supports PDF output for easy sharing.

To install SQLEditor you should drag the SQLEditor application icon to the Applications folder. You may install SQLEditor in another location if you wish.

However the path of the location should not have a colon (:) character in it.

There are two main ways that we distribute SQLEditor, zip archive download or dmg disk image download.

The install process is similar but the details are slightly different.

(A) Zip Download

SQLEditor is normally distributed within a compressed zip archive. This archive must be decompressed before the SQLEditor application can be installed.

To decompress the archive file, locate it in your downloads folder and double click on it. The SQLEditor application will then be decompressed and you can drag the it to the Applications folder.

(B) Disk Image

Alternatively some releases are available in DMG disk image format. In this case you should mount the disk by double clicking the dmg file and then when the disk image mounts on your desktop, open it and drag the SQLEditor application icon to the Applications folder.

When you open SQLEditor you see the canvas, this represents your database design. You can add tables to this by dragging them from the palette or using the Object menu and toolbar items. You can add fields and indices to your tables in the same way. Use the inspector to make changes to your objects, the inspector changes to give you the options and settings for the selected object.

(If the inspector is not visible choose Window→Show Inspector)

The export the design to an SQL DDL text file using File→Export, or directly to your database system using File→Export to Database.

If you have an existing database you can import it using File→Import from Database. To import from a SQL DDL text file or database dump you can use File→Import.

There is online help available Help→SQLEditor Help.

Following feedback the drawing of objects by SQLEditor has been improved. Objects are now drawn with curved borders and label colors are applied the table title bar instead of the body, with the body section remaining a constant color.

This new behaviour can be disabled in the Appearances tab of the Preferences window by de-selecting Draw rounded boxes and Use new style color box headers.

SQLEditor (from 1.4b6) now stores saved passwords in the keychain. The password is stored as an application password using the connection string as the account description and the username as the account user name.

You may see messages asking to unlock the keychain when using database import or export.

From version 1.4.4b1 SQLEditor now supports compound foreign keys. These are available in addition to the existing column-to-column foreign keys.

To create a multi column foreign key you need to add the Foreign Key object to a table, then drag from the new foreign key object to a target table. This will create a link between the tables. Then you can select the new foreign key and add column pairs using the inspector. Click the + button at the bottom of the list then use the two popup menus to choose which fields should be linked together.

By default SQLEditor will import using the old style foreign keys where possible, however when it finds a multi-column foreign key on import then it will create a new style foreign key instead.

Note that you may have to add indexes manually in the target tables. MySQL in particular requires this in some versions. SQLEditor is not yet able to do this automatically (but this should be added in a future release).

Soft-Go is not responsible for the content of SQLEditor publisher's description. We encourage you to determine whether this product or your intended use is legal. We do not encourage or condone the use of any software in violation of applicable laws.

Any form of support or technical problems regarding SQLEditor must be addressed to its developer/publisher. Please be aware that we do NOT provide SQLEditor cracks, serial numbers, registration codes or any forms of pirated software downloads.

Screenshot

Related Searches

create sql database, sql database, sql editor

Download Note

SQLEditor is periodically updated by our editors team but sometimes you may find out that software informations are outdated, please note that the publisher of SQLEditor can update the software without notifying us. Current version of SQLEditor is 1.7.17.

Note: Soft-Go doesn't provide any form of technical support regarding SQLEditor, however, you may find answer to your problem by reading user reviews or directly contacting The MalcolmHardie Company which's the publisher/developer of this software.

SQLEditor Recent User Reviews

No user review yet, would you like to add your review ?

Popular Database Utils downloads