[Top] [All Lists]

Re: Publishcation Types 4 SQL-NS

Subject: Re: Publishcation Types 4 SQL-NS
From: Joe Webb
Date: Tue, 17 Jul 2007 05:00:46 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
On Mon, 16 Jul 2007 16:34:43 -0500, James wrote:

> I have our production database on an SQL 2000 DB Server.  I am developing a 
> notification application in the new 2005 Server.  My theory is to create a 
> publication from the 2000 Server to the 2005 Server and then the Instance 
> Applications on the 2005 Server will operate against the published data.
> 1. Will this work?
> 2. Which type of publication? (Snapshot, Transactional...)
> *** I have complete control over both servers and databases so all options 
> are open.
> If the publication is periodically wiping out the or over the previous 
> 'snapshot?' will notifications be re-sent as the SQL-NS Server sees the data 
> as being new?
> Ideas welcome.
> thanks

With SSNS, you can have a hosted event provider running on the SS 2005
box, regularly retrieving event data from the SS 2000 box. 

Or have I misinterpreted your question? 



Joe Webb
SQL Server MVP

<Prev in Thread] Current Thread [Next in Thread>