Re: tool for copying all data from one schema into another

Christophe Marcel wrote:

> Hi,
>
> This utility works a little bit like the imp/exp utility, except that it
> - has a nice interface
> - doesn't require multiple steps
> - doesn't create a large intermediate file
> - has no problems with changes in schema names (e.g. copying from schema
> 'dev' to schema 'sept_04')
> - can handle differences between the schemas (e.g. if you had added a column
> to a table in your dev schema, and forgotten to replicate it in your build
> scripts for your production database).
>
> The performance is good (it uses bulk loads, and disables constraints before
> copying).
>
> The intended usage is for cases where you have a ~read-only production
> database (used for data mining), with updates being created at regular
> intervals (e.g. once a week, once a month). Once you have finished your
> work on your currently updated database, you copy it over to a new (blank)
> schema on the production server. Once the copy is finished and things look
> good, you re-direct your applications to the new schema and retire the
> previous production database.
>
> You can download it at:
> http://cmarcel.home.mindspring.com/Programming/CopySchema/CopySchema.htm
>
> Best regards,
>
> Christophe Marcel
> http://cmarcel.net

Is there some mental process that compels people such as yourself to not check out the rules for a usenet group and not read the FAQ before posting?

[Quoted] Please apology for spamming us and repost at c.d.o.marketplace if you don't want a reception that is as warm as liquid hydrogen and substantially more flammable.

Thank you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)