Nightly Refresh

Please help.
I have Database A (Archived data), Database B (Transactional data).
Both A and B do not have any timestamps in any tables.
I need to bring A (only once because it is archived data) and B with
only differentials into Database C for reporting purposes.

Currently C is cleared before loading B with differentials every night
and A is not loaded since it takes 15 hours to load.

Now I want to bring A once and leave it and then bring B every night
with differentials without clearing C.

Please suggest some solutions.

Thank You

Re: Nightly Refresh

(rohini.srigiriraju@gmail.com) writes:
> I have Database A (Archived data), Database B (Transactional data).
> Both A and B do not have any timestamps in any tables.
> I need to bring A (only once because it is archived data) and B with
> only differentials into Database C for reporting purposes.
>
> Currently C is cleared before loading B with differentials every night
> and A is not loaded since it takes 15 hours to load.
>
> Now I want to bring A once and leave it and then bring B every night
> with differentials without clearing C.
>
> Please suggest some solutions.

It's very difficult to suggest solutions from this high-level description.
And it's not exactly clear what you mean with differentials. I would
guess new and changed rows since last load. Do you also need to deal
with deletions?

Maybe you could examplify with some tables to give us some more meat?

Please also specify which version of SQL Server you are using.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx