SQL Server 7 and SQL Server 2005 Express question

SQL Server 7 and SQL Server 2005 Express question

Post by Benjamin F » Sun, 10 Jan 2010 03:05:44


Hi,

Is is possible to configure standard transactional replication if my local
distributor and publisher is SQL SERVER 7.0 and my subscriber is SQL SERVER
2005 EXPRESS?
 
 
 

SQL Server 7 and SQL Server 2005 Express question

Post by Paul Ibiso » Sun, 10 Jan 2010 19:11:42


As long as there is a max of 2 versions difference you are ok:
http://www.yqcomputer.com/ (SQL.90).aspx
HTH,
Paul Ibison

 
 
 

SQL Server 7 and SQL Server 2005 Express question

Post by Benjamin F » Sun, 10 Jan 2010 22:09:28

my SQL Server 2005 is EXPRESS!

"Paul Ibison" < XXXX@XXXXX.COM .(donotspam)> wrote in
 
 
 

SQL Server 7 and SQL Server 2005 Express question

Post by Paul Ibiso » Sun, 10 Jan 2010 23:21:27

Doesn't really matter tho'.
Unless you want a pull subscription then you'll have to sync up using code
or WSM due to the absence of SQL Server Agent.
HTH,
Paul Ibison
 
 
 

SQL Server 7 and SQL Server 2005 Express question

Post by Benjamin F » Mon, 11 Jan 2010 04:02:27

I will make SQL SERVER 2005 EXPRESS my subscription and SQL SERVER 7 my
PUBLISHER/DISTRIBUTOR... is that ok?

"Paul Ibison" < XXXX@XXXXX.COM .(donotspam)> wrote in
 
 
 

SQL Server 7 and SQL Server 2005 Express question

Post by Paul Ibiso » Mon, 11 Jan 2010 04:40:56

Yes - please take a look at the link - this is the first combination. Fine
assuming read only subscribers. Another relevant linke here:
http://www.yqcomputer.com/ (SQL.90).aspx
HTH,
Paul Ibison