Home SQLEditor Windows and Panels

# The Database Import Panel

This panel is used to import database designs from a database.

The import panel is fairly similar to the Database Export Panel.

### Presets

The presets menu is used to store groups of connection settings for future use. To do this you should enter all of the details for a connection and then choose Add New Connection... from the Preset menu. A new entry will then be created in the Preset Menu

### Driver

The driver popup allows you to choose which database driver you want to use to connect to the database. These need to be installed in a specific location.

### Host

The host field specifes the computer that the database software is running on. use localhost if the database is running on the same machine as SQLEditor.

### Database

Enter the name of the database into this field.

### Port

If your database is running on a non-standard port (or you think the number that SQLEditor provides is wrong) then you can provide a different port number in this box.

### Schema

If you are using schemas in your database then you can limit the import by entering a particular schema's name into this field

### User Name

Enter the username into this field

### Password

Enter the password into this field

SQLEditor stores usernames and passwords in the keychain for better security, so you may be asked to enter your keychain password

### Use SSL

Some databases support secure connections using SSL, if this is a supported option for the driver then this box will be enabled.

### Use Self Signed Certificates

If you enable secure connections but are using a self signed certificate this option relaxes some security checking to allow the connection to work.

### Url

The connection string that SQLEditor will use appears here. If you wish you can alter the connection string and SQLEditor will use your string instead.

### Table Filter

If you want to import only some tables then you can enter a search string into this box. A simple substitution will occur and any tables which have names matching the string will be imported. Tables that don't match will not be imported.

### Import

The import button starts the import process. SQLEditor will create a new document and display a progress bar. When it has received the necessary information from the database it will display the new objects in the document window.