tool for copying all data from one schema into another

[Quoted] 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 Received on Fri Oct 01 2004 - 23:33:06 CEST