Re: Data loading from production to development

It sounds as if you have configuration management issues as well as
development environment issues.  However, we don't live in a perfect world.
If management is not willing or able to address their greater needs and
insisits that you make the current system work (as if it wasn't their fault
that it doesn't work now) then you have to bite the bullet.

Dynamic SQL is probably not the answer.  While it might be easier to
administer, it would run serially and probably not fit your maintenance
window.

One possibilty is to make your development tables materialized views of
production. You'd have to set up refresh groups so that foriegn key
constraints would not be violated and you'd have to maintain the views has
development mutated but it would probably work with your maintenance window.

You hae my sympathy.  Getting developers to understand the non-goodness of
their brilliant ideas is very difficult.

Other related posts: