Re: URGENT: Need data migration tool

On 4/5/07, Paula Stankus <paulastankus_at_yahoo.com> wrote:
>
>
> I need a good tool for quickly refreshing dev/test using a random and
> easily adjustable percentage of data. A tool that will preserve all
> relationships, constraints and that will migrate schemas and definitions.
> Including one that will migrate relationships between schemas that may only
> be in views and stored procedures or database links.
>
>

What you are asking for is inherently difficult.

Consider for a moment that a well developed schema will have primary keys and foreign keys. In this case the task of getting a subset of data is greatly simplified, but still a fair amount of work.

If you have such an application to work with, something like DataBee may work well for you.

If however you have schema that appears to have been designed by a room full of young children tossing magnetic words at the fridge ( and who doesn't ) then retrieving a subset of the data becomes very difficult. This type of schema often has little or no referential integrity built into it.

Such schemas require intimate knowledge of the data and structures in order to extract a subset, and doing so requires significant effort.

So, if your schema is strong on RI, you might want to give DataBee a shot. It if is not...

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l