The following database types can be selected as source or destination for conversion and sync.
At this stage you can choose to convert not only the entire database but also the separate tables. This will speed up the access of the Execution stage and the entire conversion process.
You can select the following variants as a destination database type as well:
- MS SQL Dump / MySQL Dump / PostgreSQL Dump / Oracle Dump / Firebird Dump / DB2 Dump / PHP Script
- MS Visual FoxPro
- MS Excel
Note: Press "Refresh" button to check server connection and choose a database you want to convert from drop-down list.
MS SQL as Source / Destination
For MS SQL selected as a source or destination database Host, Port, Username and Password should be specified in the correspondent fields.
Please choose the proper communications protocol from the "Connection type" combo box: TCP/IP, PIPE or IPX/SPX.
Windows Authentication - this selected parameter allows a user to connect to the SQL Server through a Microsoft Windows user account.
After database selection, choose an appropriate schema for this database in "Schema" combo-box.
Connect to MySQL, PostgreSQL or DB2 Servers
When MySQL , PostgreSQL or DB2 Database are selected as source or target, you have to specify Hostname, Port, Username, Password.
Use Advanced features (SSH, SSL protocols) for MySQL / PostgreSQL databases if needed.
MS Access as Source / Destination
Choose MS Access file (*.mdb, *.accdb), enter Username and Password if required to set up MS Access as source or destination.
In case of MS Access WorkGroups, are used select the "Using WorkGroups" checkbox, and input the proper Username and Password in the corresponding fields.
Oracle Source / Target Connection
If Oracle is your source or destination database, fill in Host, Port, Username and Password parameters.
In order to connect to Oracle Server you should choose the access rights from the "Connect as" combo box: Normal, SYSDBA or SYSOPER.
Type database name you would like to convert in "Net service name or global database name" combo-box.
Firebird as Source / Destination
If Firebird Database is chosen, specify Server connection (Server, Port) and User database information (Database, User name and Password if needed).
- As a server you can define either a remote server or a local one.
- If your database is local you can browse it by clicking the button nearby. If it is remote, you should input your database name manually.
FoxPro as Source / Destination
If MS Visual FoxPro Database is selected as a source or destination database in "Open MS FoxPro database (*.dbc)" field browse a MS Visual FoxPro database file (*.dbc) by clicking the button nearby.
If you need to convert MS Visual FoxPro free tables in "Create database from set of tables FoxPro (*.dbf)" field browse a directory, in which the tables are located.
Set up MS Excel as Source
Browse for MS Excel file (*.xls, *.xlsx) by clicking the button.
After choosing the required MS Excel worksheet, click "Config" button. "Database structure configuration" window appears. In this window you can easily create new tables from MS Excel file or configure existing ones for the further conversion process.
- Check “Skip first row” checkbox to skip rows that do not contain any data.
- Check “First row contains field names” checkbox if the Excel sheet contains field names at the first row of the range specified.
Choosing SQLite as Source / Destination
Browse for SQLite database file (*.db) by clicking correspondent button.
All DBConvert applications support Unicode. To make language special symbols displayed correctly select utf8 or Unicode from the listbox "Connection character set". Optionally other character sets can be chosen.
After specifying connection information, click the "Test connection" button to check the parameters specified before.
By pressing the "Refresh" button you can view all existing databases available on server for this user and list them in the "Database" combobox. Choose a database you'd like to connect to. You can also type the name of the database manually in this combo.
Dump files and PHP Script as destination.
The following dump files may be generated by DBConvert Software as a destination database:
- MS SQL Server Dump
- MySQL Dump
- PostgreSQL Dump
- Oracle Dump
- Firebird Dump
- DB2 Dump
If case you want generate Dump files or PHP script perform the following steps:
In "Output file" field enter a name for dump file (it has .sql extension) to be created. You can also browse for existing file by clicking the button nearby.
In "Database" field enter a name for a database that will be created by the .sql file you specified above. This .sql file will insert data from the source database to the database with the name you define in "Database" field. In "Schema" field enter a name for an Oracle / DB2 schema.
Note: Dump files and PHP script generation is not available in DBSync Series.
MS SQL Dump
If you choose PHP Script to be generated as a destination database, specify a destination Hostname, Port, Userame and Password.
At this step you can set a way the resulting dump file should be formed in. The following settings are available:
- MySQL server version - this parameter determines the syntax of MySQL statements being used in output dump file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about your MySQL server version.
- Line breaks - this parameter specifies how to separate text lines in the dump file. If your target MySQL server / PostgreSQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.
- Insert comments - select this option to add brief comments. It makes the resulting dump file more understandable.
MS Visual FoxPro as destination.
In "Output file" field browse for a name for MS Visual FoxPro Program file (*.prg) for conversion.
In "Database" field type a name for a db that will be produced by the .prg file you defined above. This .prg file will insert data from the Source database to the database.
At this step you can set a way the resulting database should be formed in. The following settings are available:
- Insert comments - this option makes the resulting database more comprehensible.
- Insert status messages - this selected parameter indicates that during MS Visual FoxPro Program file (*.prg) execution, in program runtime will appear a window with described current operation.
- MS Visual FoxPro version - this parameter determines program file compatibility with MS Visual FoxPro version.
Note: If you chose MS Visual FoxPro version 8.0 and early program will be saved in several files.
MS Excel as destination.
Note: When you convert from MySQL to MS Excel, each MySQL table will be converted into a different Microsoft Excel sheet.