DbMouse

Latest version

DbMouse
Version: 6.4.1
Published: 2017-03-06

DatAdmin
Version: 5.4.2
Published: 2011-12-15

Hudební software

Hudební software Zpěvníkátor a Notoeditor v češtině.
cz.jenasoft.com

Data duplicator tutorial

Data duplicator is unique DbMouse tool allowing to copy or duplicate related data. It is binded with data relation tools allowing finding related rows, data duplicator can the insert in other database, preserving relations between copied objects.

Obtaining dataset

First step is to obtain related data. There are several ways to obtain this:

Obtain dataset using related rows dialog

In data view, select rows with related rows and choose "Find related rows" in context menu.

In dialog, click "Load missing" utton for loading all missing dependencies. The click "Save to local DB" to open dataset in local database.


Using data duplicator

Data duplicator must be invoked from local database. All tables in local database, which are named equaly as table names in current database, are imported. Relations from current database are persisted. In Local DB ribbon, choose "Data duplicator". In data duplicator. "Run" button imports (duplicates) data into current database, "Generate SQL" button generates SQL script for inserting duplicated data.


Local database.

Data duplicator