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(rohini.srigiriraju@.gmail.com) writes:

Quote:

Originally Posted by

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

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
>