Is it true that merge replication between SQL7.0 and 2005 is not supported?
I would like to setup SQL2005 as a publisher and distributor and SQL7.0 as a
subscriber.
Can someone confirm that please...
Other options in that case would be to use transactional replication or to
upgrade 7.0 to 2000 and then use merge replication.
Tom
Hi Tom,
Merge Replication in SQL Server 2005 does indeed support SQL 2005
distributor and SQL 2005 publisher with SQL 70 subscribers.
You'll want to check out the following topic in SQL Server 2005 BOL:
"Using Multiple Versions of SQL Server in a Replication Topology"
Hope this helps,
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" wrote:
> Is it true that merge replication between SQL7.0 and 2005 is not supported?
> I would like to setup SQL2005 as a publisher and distributor and SQL7.0 as a
> subscriber.
> Can someone confirm that please...
> Other options in that case would be to use transactional replication or to
> upgrade 7.0 to 2000 and then use merge replication.
> Tom
>
>
Showing posts with label sql7. Show all posts
Showing posts with label sql7. Show all posts
Wednesday, March 21, 2012
Tuesday, March 20, 2012
replication and upgrade of SQL7 to SQL2000
Hi all,
We are preparing to upgrade from SQL 7 to SQL 2000 and we have transactional replication running from this server to Sybase 12.5. We also have couple of batch jobs puling data from Sybase and Oracle to this SQL & server. I'd like to here your experience a
bout moving from SQL7 to SQL2000, especially with replication upgrades. What should be our major concern about the whole upgrade?
Thanks very much
I have migrated many SQL 7 to SQL 2000 servers which have been publishers/subscribers/distributors.
The correct upgrade sequence is update the distributor, publisher and then subscribers (you won't have to do this in your case).
I had no problems with the upgrades, but had a few while applying SP3 - which really is essential when running SQL 2000.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||What is actually the major change in replication of the SQL server 2000?
|||SQL Server 2000 builds upon SQL 7 replication. It offers enhanced performance and greater functionality as well as new functionality. Check out replication enhancements in BOL for more details.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
We are preparing to upgrade from SQL 7 to SQL 2000 and we have transactional replication running from this server to Sybase 12.5. We also have couple of batch jobs puling data from Sybase and Oracle to this SQL & server. I'd like to here your experience a
bout moving from SQL7 to SQL2000, especially with replication upgrades. What should be our major concern about the whole upgrade?
Thanks very much
I have migrated many SQL 7 to SQL 2000 servers which have been publishers/subscribers/distributors.
The correct upgrade sequence is update the distributor, publisher and then subscribers (you won't have to do this in your case).
I had no problems with the upgrades, but had a few while applying SP3 - which really is essential when running SQL 2000.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||What is actually the major change in replication of the SQL server 2000?
|||SQL Server 2000 builds upon SQL 7 replication. It offers enhanced performance and greater functionality as well as new functionality. Check out replication enhancements in BOL for more details.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Subscribe to:
Posts (Atom)