<div>
Are you thinking of maintaining two databases in two different server 2005 &amp;&nbsp;2008 R2.<br />
If so then replication strategy will work fine..depends on your requirement how you want to replicate.<br />
<br />
If you are thinking for just data transfer and that's one time process then Linked server will be good option.
</div>


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.

<div>
You can't mirror between two different versions of SQL Server, so that option is out.<br />
<br />
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.
</div>


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.

<div>
We need to replicate it close to realtime and that was the reason i didnt consider linked server or log shipping.
</div>


We need to replicate it close to realtime and that was the reason i didnt consider linked server or log shipping.

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
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<br />
<br />
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?
</div>
</div>


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?

Suggestion needed for sql server 2005 to 2008 replication

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.