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 |
|
Hallaghan
Starting Member
2 Posts |
 Posted - 2009-11-25 : 09:56:43
|
| Hi Community,Here in my office we're working with both SQL Server 2005 and SQL Server 2008.I'm developing an application which uses 2 databases (as required from my team leader) and he expects one database to replicate data to the other. One of these databases is hosted at a SQL Server 2008 instance and the other one is hosted at a SQL Server 2005 instance.What I'd like to know is if it is possible to establish a replication server between the two instances, given that they are different versions of SQL Server, and if so, how would I go about that.Any help would be deeply appreciated.Kind regards,Hallaghan |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-11-25 : 13:54:57
|
| Yes. it should work in either direction. Just make sure the distributor is at least same version as publisher.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-25 : 14:23:48
|
| also with 2005 --> 2008, then 2005 must be at least SP2 |
|
|
|
Hallaghan
Starting Member
2 Posts |
Posted - 2009-11-26 : 07:38:54
|
| Hi,Thank you both for your replies. I made sure and our SQL Server 2005 is SP3 and our SQL Server 2008 is SP2. I'll be using the 2005 instance as the publisher and distributor.I'll get back here should anything go wrong.Kind regards,Hallaghan |
|
|
|
carolina
Starting Member
1 Post |
Posted - 2010-03-28 : 16:50:36
|
| In addition to replication, in SQL Server 2008, you can synchronize databases by using Microsoft Sync Framework and Sync Services for ADO.NET. For complete documentation, see this MSDN Web site.Carolina |
|
|
|
|
|
|
Replication between SQL Server 2005 and SQL Server