• Installation
  After the Download just double-click the file dbCOPY.exe and follow the instructions.
  
• Program call
  Under „Start - Programs“ you find the item „"dbCOPY 2.0 “. Just call the program
  dbCOPY.
  
• Command line call
  Since Version 1.5.5 dbCOPY is suitable for the batch-modus. Concurrently it is possible to make a link on the desktop.
  The call requires a working profile, e.g.:
  
  "C:\Programs\dbcopy\dbCOPY.exe" Profilename
  

dbCOPY MENU

• Connections
  Overview
  New Connections (MySQL)
  Servermanager (ADO-Databases, SQLite, ODBC)
  Windows address book
  
  
• Profiles
  Overview
  
  
• Copy
  Table assignment and Copy procedure
  Special note for the field allocation
  
  
• Table-View
  DB-Viewer
  Execute SQL-Querys

First create a required Database connection and save it for later use. Click "Add" for a new connection and choose the Database type.

Featured types are:

• MySQL from version 3.2x,
• MS Access from version 97,
• MS Excel from version 95,
• dBase III,IV,V
• Paradox 5.x,
• SQLite
• Text database (separated by comma, tab, or your own delimiter
• Import XML files (generated by MySQL)
• Import Windows address book
• OBDC-Data sources

Each connection has it own name which will be listed under the corresponding type.
Hint: Each connecting name can be put on only once.

To delete a saved connection click on "Delete". Only the saved link will be deleted, not the database/file itself!

To edit an existing connection click on "Edit".

In the connection window dbCOPY indicates an open connection by a green check .
You get a context meu by double click on a saved connection. Click on "Browse database" to open the integrated DB-Viewer which presents the data in an Excel like way.

MySQL
Connection: A unique name for later use in dbCOPY.
Server: The IP-address of the MySQL Server or the www-address
(e.g. www.mysql-server.de, without http://)
Port: Standard Port 3306
User name : The username for having access to the database
Password: The corresponding password
Database Name: The name of the MySQL Database

After input of server, port, user name and password, dbCOPY could establish a connection to the server and list all available databases.
You can enter the data base name directly in the field "Database".

After click on "OK" the connection will be checked and saved.

Database type: Access
Connection: A unique name for later use in dbCOPY.
Access file (*.mdb): Enter the full path+file to the Access database.
Password: If your database is protected by a password, please enter it.

Database type: Excel
Connection: A unique name for later use in dbCOPY.
Excel file(*.xl*): Enter the full path+file to the Excel file.
First row contains field names: The first row contains the field names which will not be copied.

Database type: dBase/FoxPro/Paradox
Connection: A unique name for later use in dbCOPY.
Path: Enter the full path to the respective database.

Database type: Text-DB
Connection: A unique name for later use in dbCOPY.
Text file: Enter the full path+file to the Text database.
First row contains field names: The first row contains the field names which will not be copied.
Field delimiter: The data are separate by COMMA, TAB or by an own delimiter, e.g. "|".
Character set: The used cahracter set (ANSI, OEM).

Database type: SQLite
Connection: A unique name for later use in dbCOPY.
SQLite file: Enter the full path+file to your SQLite file.

Database type: ODBC
Connection: A unique name for later use in dbCOPY.
ODBC source: Please select a registered ODBC-Datensource.

After click on "OK" the connection will be checked and saved.

Here you can see a list of all stored "copy configurations". By click on "Load Profile" the desired profile will be loaded.

After a complete copy procedure dbCOPY stores the last copy configuration under "Last copy procedure". You could also load this configuration.

Click on "Edit" to change the name and also the connections inside a profile.

This dialog is for the table and field assignment. Tables and also fields with different names can be updated.

Step 1:	Choose a source database (connection).
Step 2:	Choose a destination database (connection).
Step 3:	Select a table from the source and the destination database and add the allocation by click on . If the table names of the source and destination are identical, clicking on adds the allocations automatically to the list.
Step 4:	On the right side the field allocations are accomplished now. Accomplish this procedure for each assignment on the left side: Mark e.g."customer->Customers". In the right field allocation dialogue all fields of the source and and destination table appear - same field names are assigned automatically. Through click on a field within the destination table select the desired destination field. To delete the field allocation, click in the field and delete this with the removing key. Repeat step 3 and 4, until all table and field allocations are assigned. The created profile can be "Saved" and also loaded at any time.
Step 5:	Start the copy procedure. Please choose a copy mode (located on the left side). Delete all destination contents and insert new First all destination contents will be deleted. The new source data will be inserted. Leave destination contents and extend with source contents (Merge) In this mode the destination contents will NOT be deleted. The source data are read in line by line and compared with the target datas: With same entries the data record is not inserted. If contents of the data record should differ only in a place, the entire line is inserted. Hint: With to many field allocations the generated SQL expression can become too complex querying goal contents for the OLEDB drivers - further inserting is then stopped! Solution: In the field allocation dialogue a "Comparison field" can be indicated for each field allocation. When comparing only these fields are compared on equality. If an equality exists with these field contents, the data record is not inserted. If no "Comparison field" is indicated - everything on No - all fields are compared. Hint with primary keys: Inserting fields, which has a primary key and which field is already present, leads to an error message (e.g. same ID contents with Autoincrement) Solution: Ffields with primary key may not be copied.

The DB-Viewer presents the table data in an Excel like way.
The value of "Limit" restricts the view to at first 50 daten sets. Change the value and confirm your entry by "OK".
With the arrow keys you can navigate within the table - depending upon the limit forwards ">" and back"<".