> Has anyone ever heard of using a separate administration database
> which is used to modify business data, and then periodically that data
> would be pushed out to the other database running the customer web
> application? Does this idea make any sense at all?
This sounds like a task for separate schemas rather than for two
separate databases. The advantage of the former is that you can
move data between the two in SQL fairly easily, moving data between
two independent databases is (currently) more challenging.
--
Mike Nolan
