Nightly refresh

Please help. Taking over somebody's half done job. Here is my
situation:
I have Database A (with Transactional data), Database B(Archived
data). I need to bring both Database A and Database B Into Database C
after cleaning for reporting purposes.
Database B should be brought into Database C once it is archived data
and Database A should be brought into Database C with differentials
only.
Also Database A and Database B do not have any timestamps in any
tables.
Currently Database C is cleared every night to load Database A.
Database B is not loaded since it takes 15 hours to complete the job.
I can successfully bring Database A into Database C with
differentials. Now I would want to add Database B into Database C and
keep it as is and would want to load only the differentials into C
from A without clearing C.
Please suggest some workarounds.
Thank YouDoes it take 15 hours to load database C with the data from database A? or
15 hours to load database B into database C?
What size of databases are we talking about here?
You also said you can already bring A into C with differentials but then in
the next sentence you said you want to load only the differentials into C
from A without clearing C.
If you could clarify some of those it would make it easier...
--
Geoff Chovaz
MCTS: SQL Server 2005
MCITP: Database Administrator
MCITP: Database Developer
<rohini.srigiriraju@.gmail.com> wrote in message
news:1190211476.759596.123330@.50g2000hsm.googlegroups.com...
> Please help. Taking over somebody's half done job. Here is my
> situation:
> I have Database A (with Transactional data), Database B(Archived
> data). I need to bring both Database A and Database B Into Database C
> after cleaning for reporting purposes.
> Database B should be brought into Database C once it is archived data
> and Database A should be brought into Database C with differentials
> only.
> Also Database A and Database B do not have any timestamps in any
> tables.
> Currently Database C is cleared every night to load Database A.
> Database B is not loaded since it takes 15 hours to complete the job.
> I can successfully bring Database A into Database C with
> differentials. Now I would want to add Database B into Database C and
> keep it as is and would want to load only the differentials into C
> from A without clearing C.
> Please suggest some workarounds.
> Thank You
>|||Restore DB B to DB D.
Differential load DB C into DB D.
Differential load DB A into DB D.
Rename DB C to DB E (in case you need it later)
Rename DB D to DB C.
Set up regular differential load DB A to (the new) DB C.
Drop DB E.
hth
Quentin
<rohini.srigiriraju@.gmail.com> wrote in message
news:1190211476.759596.123330@.50g2000hsm.googlegroups.com...
> Please help. Taking over somebody's half done job. Here is my
> situation:
> I have Database A (with Transactional data), Database B(Archived
> data). I need to bring both Database A and Database B Into Database C
> after cleaning for reporting purposes.
> Database B should be brought into Database C once it is archived data
> and Database A should be brought into Database C with differentials
> only.
> Also Database A and Database B do not have any timestamps in any
> tables.
> Currently Database C is cleared every night to load Database A.
> Database B is not loaded since it takes 15 hours to complete the job.
> I can successfully bring Database A into Database C with
> differentials. Now I would want to add Database B into Database C and
> keep it as is and would want to load only the differentials into C
> from A without clearing C.
> Please suggest some workarounds.
> Thank You
>