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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2007-11-01 : 13:54:05
|
| Hi,We are implementing push transaction replication from Production SQL Server 2000 database to SQL Server 2005 reporting server and SQL Server 2000 Test server.SQL Server 2000 PROD to 2000 Test is simple but from SS2000 to SS2005 I have following questions:Is it feasible to create push subscription from SQL Server 2000 to SQL Server 2005 database?When I am trying to setup publisher/subscription properties, It only give me options to pick SQL Server 7.0 or 2000 or heterogeneous databases.When I am trying to register SQL Server 2005 database in EM of SS2000 it don't allow me to add it and through exception that I need to use Management studio, Is there any alternate way to register?Thanks--rubs |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 23:05:11
|
| Try create subscriber on sql2k5, or register sql2k publisher in ssms. |
 |
|
|
|
|
|
SS2000 to SS2005 transactional replication issues?