Hi Group,

I just started at a company and am trying to come up with a solution
to streamline the datawarehouse.

The problem is, we have two databases.  Database1 (548 tables) is
generated from user input and we cannot control the schema.  Database2
(40 tables) is a staging DB that optimally will contain some of the
Creates and Updates from the previous day from within Database1.
Database2 is built from a conglomeration of tables in Database1,
therefore we have created 40 views which encapsulates data from
multiple tables in Database1 and are using DTS to call these views and
populate Database2 with a snapshot.

There are 2 problems with the above setup.  First is, we do not need
to take an entire snapshot of the views to populate Database2, we only
need the previous days changes (the DB is growing and we cannot afford
it).  Second, DTS is a pain because we are using a separate view for
every table and a separate DTS package to copy every view to
Database2.  Maintenance is tough.

Currently, we are investigating the use of triggers, but I think this
will end up being a maintenance nightmare also.  Is there anyway to
use replication in conjunction with views to copy *only* the previous
days changes to the other Database?  Or does anyone have any other
suggestions to the best way to set this up?  *Any* insight or advice
on a better setup is welcome.

Thanks much,
Derek