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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-07-23 : 07:23:37
|
| Dear MemberI have two database in two diffrent server. i have transfer some table data in one database to another database . i know that it is posible to replication facility. so which one i have used to any your experience. send any link step by step process to shedule this process.thanks in advance |
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2010-07-23 : 08:02:19
|
| First u should explain the scenario and then have to choose which mode of replication u have to configure... If u need both ends to be online at the same time ie , u need both ends to get updated at the same time if any data updates at that moment ..go for Transaction replication .. there u have to taken care of that both the remote server should be online ..a dedicated communication between then.... another one if both the server can work independently and at a particular time you need to make it update the both side so that data is same in both ends ...better go for Merge Replication... here u can resolve some type of conflicts occurs if same row of data updates at both ends .. need to consider which one will remain in both sides ( can be figure out by giving some formula or condition regarding the situation u assume) |
 |
|
|
|
|
|
Replication in sql2005