Sneak Peak: Data Transfer Utility

We're currently hard at work putting the final touches on a new data transfer tool that will be available in QweryBuilder 6.2.0.

The new data transfer window will let 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:

Click to enlarge

There will be several transfer types:

1) Delete\Insert

•  All rows from the target database will be deleted. Each row from the source database will be inserted into the target.

2) 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.

3) Insert Only

• Only rows from the source that do not exist in the target will be moved.

4) 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.

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.

That pretty much sums it up. We hope that this tool will make an excellent addition to your database toolkit. If there are any questions, please email support@werysoft.com.

Thanks,

The Werysoft Team
www.werysoft.com