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 |
|
ravi14
Starting Member
1 Post |
 Posted - 2004-07-21 : 20:15:06
|
| Is there a way to capture transaction logs on only a sub_set of tables as DML into a file so that this can be applied directly to another database of identical schema.Both source and target servers are SQL2000.I'm looking for a facilty similar to Oracle Streams.ThanksRAvi |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-21 : 20:37:49
|
| Depending on how real-time the data needs to be, you might be able to use transactional or merge replication.Check those topics out in BOL for more details.-ec |
 |
|
|
|
|
|
Transaction Logging - Rule based