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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-03-18 : 16:14:38
|
| Can you use Transactional replication for exchange data between tables where schema is not matching?------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 16:44:52
|
| Yes you can. After you setup Publication, Go to Publication Properties - Choose Articles Properties- Set destination Schema (whatever you like). |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-18 : 16:48:59
|
| Can that be two way replication?------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 16:50:32
|
| I can't tell.It worked for me one way though. You have to test with Updatable subscription. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-18 : 17:01:43
|
| Thanks Soddep. In merge, all the tables in replication have 3 triggers! One each for INSERT/UPDATE/DELETE. Depending on the DML the trigger fires and the data is stored in system merge tables. Then the merge agent runs and synchronises the data. Does transactional replication works in a similar fashion?------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 17:06:10
|
| Yep, it creates a trigger too when you do tran rep with updatable subscription:Check this out:http://msdn2.microsoft.com/en-us/library/ms151718.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-03-18 : 17:08:45
|
| Thank you, Sodeep!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
unmatched schema - Transactional replication