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 |
|
sandesh.ravi
Posting Yak Master
110 Posts |
 Posted - 2011-09-26 : 06:26:21
|
| I need to replicate the data between two servers where one has sql server 2005 and the other sql server 2008 R2. Please suggest me whether to go with log shipping or replication. I am giving more importance to performance. which one of this is more faster?Thanks,Sandesh |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2011-09-26 : 06:31:10
|
| The Performance and Latency as concern Transational Replication will be a good choice. If you configure Logshipping , the secondary server can be used for Reporting purpose (Readonly). Senthil.C------------------------------------------------------MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2011-09-27 : 11:28:17
|
quote:
Originally posted by senthil_nagore
The Performance and Latency as concern Transational Replication will be a good choice. If you configure Logshipping , the secondary server can be used for Reporting purpose (Readonly). Senthil.C------------------------------------------------------MCTS - [Microsoft][ODBC SQL Server Driver]Operation canceled
Not sure about replication, but you can also do this with Mirroring, so I imagine you can do it with replication in the same way. I'm just guessing here, as my experience with replication is minimal.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
|
|
|
Log shipping vs Replication