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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-15 : 08:37:34
|
| Ravi writes "I need to capture transactions happening only to a sub_set of tables in a sql2k database, as DML statments (inserts/updates), so that this can be applied directly to another database of identical schema.Oracle 9i has a feature called Streams, which can perform meet the above requirement.We have an application that runs on bothe DB platforms and I need to come up with a solution for minimizing db upgrade down time.A rule base transaction logging would solve the problem for me.ThanksRavi" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-15 : 14:19:38
|
| Use transactional replication.Tara |
 |
|
|
|
|
|
Transaction Logging - rule based