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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2005-01-25 : 15:57:03
|
| What is the best way to keep the current (same) data between tables without using trigger/replication?I have tables called A, B, and CTable A is created by both table B and CI would like to keep the current data in table A as the data in table B and C.For example, if there are any record changes (insert, update, or delete) in table B or C, the data in table B should be automatically inserted, updated, or deleted. How can I accomplish this without using triggers / replications |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-01-25 : 16:33:47
|
| Why are you storing the same data in multiple places? |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2005-01-25 : 16:52:49
|
| Table A is a fact table in DB warehouse( reporting purpose). Table B and C are in the production DB. |
|
|
|
|
|
|
keep the current (same) data between tables withou