I often need to copy complete transactions from the production system into the test system. The database structure is the same. Some of the fields in a table might have NULL values.

My objective is to write a program that will fetch records associated with a particular transaction and copy them over to the test system.

The database is Oracle 9i (production system) and Oracle 10G (on the test system).

The records will exist in multiple tables.

A simple example -->
MEMBER_MASTER
MEMBER_ID
JOIN_DATE
FIRSTNAME
LASTNAME

MEMBER_ADDRESS
MEMBER_ID
ADDRESS_ID
STREET_NAME
APTNO
CITY
ZIP

If I give a specific member id, it should fetch all records in MEMBER_MASTER and MEMBER_ADDRESS tables and insert these records in the test system.

What is the best way of developing this app? Currently I use sqlloader to do this.

I want to build a front-end and I am thinking I could learn some VB .NET along the way.