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 |
|
JoeM
Starting Member
1 Post |
 Posted - 2007-08-31 : 09:46:53
|
| Hi,What is the best way to do a two way data transfer between Sql server 2005 and sql server 2000. These data transfer should take place on triggers happening on either of these databases. Please help. Is there any tutorial online which addresses this. Thank You |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:23:47
|
| Take look at linked server in books online. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-03 : 16:57:29
|
| you do realize if something happens within the link, rollbacks will happen?i haven't explored much of replication in 2005 nor do I even know if it's possible with 2000 and 2005, but check that out.--------------------keeping it simple... |
|
|
|
|
|
|
data replication