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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-08-23 : 02:11:22
|
| I want to know the best approach for incremental data export. What I have planned is to keep the Last value of the primary key and next time when data is pulled that will be after that stored value. if there is any other best approach please advise me. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-23 : 03:34:44
|
| "incremental data export"Do you want to periodically export changed data to "some other system"?Kristen |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-08-23 : 03:47:33
|
| I want to export Newly Inserted data to other system |
|
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2005-08-23 : 10:37:09
|
| That's good approach if your primary key is on identity column, otherwise it may not work. |
|
|
|
|
|
|
Incremental data export