• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 829
  • Last Modified:

Suggestion needed for sql server 2005 to 2008 replication

Hello experts,

I need to replicate few tables from Server A (sql server 2005 enterprise) to server B (sql server 2008 R2 enterprise) for an ACTIVE-ACTIVE environment

I need help deciding the best methodoly to achieve my goal. I was thinking transactional replication or mirroring. Which one do you think is best achieved? and can i get a step by step process to set up?
0
parpaa
Asked:
parpaa
  • 2
1 Solution
 
Hiran DesaiSolution ArchitectCommented:
Are you thinking of maintaining two databases in two different server 2005 & 2008 R2.
If so then replication strategy will work fine..depends on your requirement how you want to replicate.

If you are thinking for just data transfer and that's one time process then Linked server will be good option.
0
 
Carl TawnSystems and Integration DeveloperCommented:
You can't mirror between two different versions of SQL Server, so that option is out.

Transactional replication should work ok between versions. How up to date does your replicated version need to be? Log shipping could be an option too, but usually has a less frequent update cycle than replication.
0
 
parpaaAuthor Commented:
We need to replicate it close to realtime and that was the reason i didnt consider linked server or log shipping.
0
 
Carl TawnSystems and Integration DeveloperCommented:
In that case transactional replication is pretty much your only option.

You can find a simple guide to setting it up here: http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now