Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sagarpbora
Starting Member
12 Posts |
 Posted - 2007-04-11 : 05:09:55
|
| Hi,I am working on one application, which retrieves data from multiple tables in the database and all the fields retrieved, are exported as an excel sheet. All the export functionality is done through DTS. And the data is retrieved using an SP.I am supposed to use an "incremental backup" approach here. Means, for the 1st scheduling of the package, all the database dump will be there in excel file. But, after that only fields that are updated/inserted are to be filled in the excel file. Each time, when the dump of the database is taken, the excel file is stored in an archive folder with Date and tiemstamp(e.g. TEST_11_04_2007_15_00_00.xls)e.g. For the first dump, I get 100 records from the database. Before next execution of the package, 10 rows get inserted and 1 row gets updated. So, on the second time execution of the package, I should populate the excel sheet with those 11 rows only, and not 110 records.I am not authorised to change the database schema. So, is there any approach to try out this? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-11 : 13:31:23
|
| "So, is there any approach to try out this?"I would create a Delta process:Make a second database.Copy the relevant data to that, and to the XLS at the same time.On subsequent runs I would compare the "live" data with the copy-database, and for any differences send the data to XLS and update the copy-database.Kristen |
 |
|
|
|
|
|
|
|
Implementing Incremental Backup through DTS