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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-08 : 14:32:20
|
| which are the efficient & easier ways of carrying out the following task in SQL server 2005 ?Scenario:We have two databases A & B. B is an exact replica of A...database administrators replaces B with A nightly and B is used for reporting.We want to replace this nightly bulk refresh and want to write a DTS/SSIS package to export differential data (records that are modified only).I am new to SQL 2005....and, wondering how can we achieve this? Can I do this data export in any other way other than DTS or DTS would be the better approach? Also, can this DTS be scheduled? I appreciate your help in this...Thanks ! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 03:04:18
|
| i think what you need is to use SCD task (slowly changing dimension). it will automatically look for changes and do insert/update based on defined key value of records. |
 |
|
|
|
|
|
Differential export of data