greenpower
New Member
Hi,
I have the following situation.
My Db is 35 GB and one of our department restores every night the full backup to a local system. From there they query 90% of the data tot a datawarehouse enviroment. This takes about 6 to 8 hours. This gives of course more and more time schedule problems.
Per day i only need the adds, deletes and changes of the data with i can add tot my DWH. I tried to load a incremental backup into en empty DB. But this doesn't work.
The only solution i am now aware of is making triggers on each table, but this is of course a lot of work and when we get a change from our software supplier my adds will be lost.
Can anybody help me with a nice solution.
Greetings,
Jan
I have the following situation.
My Db is 35 GB and one of our department restores every night the full backup to a local system. From there they query 90% of the data tot a datawarehouse enviroment. This takes about 6 to 8 hours. This gives of course more and more time schedule problems.
Per day i only need the adds, deletes and changes of the data with i can add tot my DWH. I tried to load a incremental backup into en empty DB. But this doesn't work.
The only solution i am now aware of is making triggers on each table, but this is of course a lot of work and when we get a change from our software supplier my adds will be lost.
Can anybody help me with a nice solution.
Greetings,
Jan