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 |
chbala85
Starting Member
49 Posts |
Posted - 2013-09-16 : 05:44:11
|
Hi All,i have database here tables don't have primary key and foreign key relationship.if any dml operation done test1 database but need reflect test2 database please tell me ......thanks,krish |
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-09-16 : 07:46:07
|
You need to have a primary key on the tables you want to replicate.mohammad.javeed.ahmed@gmail.com |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-09-16 : 07:50:06
|
You can have a trigger to do the changes for you.That's how things were done before cascaded updates were introduced. Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|