Soluling home   Document home

Import

Import Wizard - Select

Use this sheet to select the database of where you want to import from.

Select a database where you want to import data

Specifies the database type. Possible values are:

Format Description
Access Access databases (.mdb, .accdb)
Firebird Firebird databases (.fdb, .gdb)
InterBase InterBase databases (.gdb)
MySQL MySQL databases
PostgreSQL PostgreSQL database
SQL Server SQL Server databases
SQL Server Compact SQL Server Compact databases (.sdf)
SQLite SQLite databases (.db)

Depending on the selected database type, the sheet shows UI elements that let you edit database properties. Such properties are, for example, the location or address of the database, the name of the database, the user name, and password.

Access

Enter the database file name to the Database filename field or click the ... button to browse the file. Once you have entered a file name that exists, Soluling automatically connects to the database.If your database is password-protected, enter the password into the Password field. If you want to use some other database provider but the default one, choose the provider in the Provider combo box. You can give some additional ADO connection string parameters in the Connection string parameters field.

Firebird and Interbase

Check Use local server if your database server is on the same computer where you run Soluling. If the server is on some other computer, then enter the hostname or IP address of the server in the Server address fields. The default TCP/IP port is 3050. If your server uses some other port, set the port in Server port edit. Enter the database name in the Database file edit. If you have checked Use local server, then you can also browse the file by clicking the ... button. Finally, enter the user name and password in the User name and Password fields and click the Connect button to connect to the database.

MySQL

Enter the IP address of the server into the Server address field. The default TCP/IP port is 3306. If your server uses some other port, set the port in the Server port edit. Enter the user name and password in the User name and Password fields and click the Connect button to connect to the database. Finally, select the database from the Database name combo box.

SQLite

Enter the database file name to the Database filename field or click the ... button to browse the file. Once you have entered a file name that exists, Soluling automatically connects to the database.

SQL Server

Enter the server address into the Server address field. If you don't use operating system authentication, enter the user name and password into the User name and Password fields. Click Connect to connect to the database. Finally, select the database from the Database name combo box.

SQL Server Compact

Enter the database file name to the Database filename field or click the ... button to browse the file. Once you have entered a file name that exists, Soluling automatically connects to the database.