Skip to main content

Source / Target steps

  • Updated

The following database types can be selected as source or target 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:

Note: Press "Refresh" button to check server connection and choose a database you want to convert from drop-down list.

SQL as Source / Target

For SQL selected as a source or target 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.  

mssql_source.png

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.

MySQL

mysql_source.png

PostgreSQL

postgres_source.png

IBM DB2

mceclip0.png
 

MS Access as Source / Target

Choose MS Access file  (*.mdb, *.accdb), enter Username and Password if required to set up MS Access as source or target.

In case of  MS Access WorkGroups 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 target 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.

oracle_source.png

Type database name you would like to convert in "Net service name or global database name" combo-box.

Firebird as Source / Target

If Firebird Database is chosen, specify Server connection (Server, Port) and User database information (Database, User name and Password if needed).

Note:

  1. As a server you can define either a remote server or a local one. 
  2. 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 / Target

If MS Visual FoxPro Database is selected as a source or target 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.

Note:

  1. Check “Skip first row” checkbox to skip rows that do not contain any data.
  2. 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 / Target

Browse for  SQLite database file (*.db) by clicking correspondent button.

 sqlite_source.png

Unicode

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.

Test Connection

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 target.

The following dump files may be generated by DBConvert Software as a destination database:

  • 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

 

MySQL Dump

 

PHP Script

If you choose  PHP Script to be generated as a destination database, specify a destination Hostname, Port, Userame and Password.

PostgreSQL Dump

Oracle Dump

Firebird Dump

DB2 Dump

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 target.

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 target.

Note: When you convert from MySQL to MS Excel, each MySQL table will be converted into a different Microsoft Excel sheet.

Related articles

Comments

0 comments

Please sign in to leave a comment.