|
|
The data transfer window let's you move data from one supported data source to another.
This can be a "one-off" transfer or it can be built into a reusable compilation as seen in the image below:
There are several transfer types:
- Delete\Insert
- All rows from the target database will be deleted. Each row from the source database
will be inserted into the target.
- Update\Insert
- All rows from the target will be compared to the source (based on matching primary
keys). If a row from the source database is found in the target, the target will
be updated. If a row from the source database is not found in the target, the row
will be inserted into the target.
- Insert Only
- Only rows from the source that do not exist in the target will be moved.
- Update Only
- Only rows from the source that exist in the target will be updated.
After a table is selected from the table drop down, all columns will be loaded into
the column grid. Here, columns can be removed and it's position moved. This gives
you the flexibility to match a source table to a target table when the structure
is not the same. You can also add "static" values to the source column list so that,
for example, a date column in the source always has a specific date or a char column
always has a specific character value.
To restrict the rows that are moved from the source to the target, you can declare
a where clause. This where will be applied to the source before the source data
is retrieved. You can see how many rows will be retrieved from the source by clicking
the validate button.
You can transfer data for a single table by opening it (double clicking in the list)
and clicking the execute button on the toolbar within the opened tab. A transfer
report will display for that one item.
Note: To facilitate the transfer of information
from two completely different data sources, the client needs to act as the intermediary.
What this means is that all applicable data is retrieved from the source and all
applicable data is retrieved from the target. In the event of a Delete\Insert, no
data is retrieved from the target, just the source. Keep this in mind because moving
millions of rows of data can tax your available memory and possibly take a long
time to finish.
Note: When applicable, Identity fields are disabled
while inserting data. This is done to preserve relationships between tables where
one table contains a foreign key to another tables Identity column. If you're transfering
data between tables that contain identity columns, it may be best to use the Delete\Insert
option. Using Update\Insert may result in undesirable updates.
Note: Before data is transfered the foreign keys
for the table are disabled. The process of deleting, inserting and updating may
not satisfy foreign key constraints until data from other tables are present.
|
|
QweryBuilder's SQL Editor provides you with a rich ad-hoc query experience that gives
you full control while you query your database.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
|
"This is a great program, a good developer's tool. It is snappy and to the point. It is the best that I have seen and tried."
Read More Testimonials
|
|
|
