PostgreSQL Data Wizard online Help
| Prev | Return to chapter overview | Next |
Setting source and target databases
On the first wizard step set the connection parameters of the source and destination databases.
Source connection
Specify the connection string for the source database. You can use any data source accessible via ODBC driver or OLE DB provider such as SQL Server, Oracle, MySQL, MS Access, Text files, MS Excel, etc. To learn more about ODBC drivers, OLE DB Providers and other such stuff, read our brief guide to connection strings.
Destination connection
Set the connection parameters for the target PostgreSQL database the source database to be converted to.
To convert data to a new database, check Create new database and select the database server version. To recreate an existing database, use the Drop database if exists option.

| Prev | Return to chapter overview | Next |







