DbNetCopy Application
Copying Data
| 1. | Select the Source Database. |
| 2. | Select the Target Database. |
| 3. | Select the tables from the source database that you wish to copy. Click on Select All to select/de-select all the tables |
| 4. | If you only want to copy certain columns then click on the  icon to display the columns which you can then select |
| 5. | If you want to replace the table in the target database if it already exists then check the Drop Target Table checkbox |
| 6. | Select the Mode |
| 7. | Select the Schema option |
| 8. | If you want to convert the encoding you must select the source and target encodings from the list of available encodings |
Mode |
Description |
SchemaAndData |
Creates a new table in the target database and copies all rows |
SchemaOnly |
Creates a new empty table in the target database |
ReplaceRows |
Deletes all rows from the target database and copies all rows from the source database |
InsertRows |
Adds rows that are in the source database but not in the target database. A primary key must be defined for the table. A record is deemed not to exist if a record with the same primary key cannot be found in the target database. |
UpdateRows |
Updates rows that are in the source database and also in the target database. A primary key must be defined for the table. A record is deemed to exist if a record with the same primary key is found in the target database. |
MergeRows |
Updates rows that are in the target database and inserts rows that are not. A primary key must be defined for the table. A record is deemed to exist if a record with the same primary key is found in the target database. |
Mode |
Description |
Preserve |
Attempts to preserve the schema name in the target database |
Drop |
The source schema name is not used when creating the table in target database |
IncludeInSchema |
Includes the schema name in the name of the table in the target database e.g. northwind.customers would become northwind_customers |
You can convert the encoding of strings as part of the copy process by selecting the encoding of the source database and the encoding that you would like to use in the target database.