Publishcation Types 4 SQL-NS

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


JIM

Ok, hadn't gotten that far yet in my SQL-NS 101 but did just look it up in
the SQL Server TechCenter and it does look like the more elegant approach.
Thanks for the tip.

JIM


"Joe Webb" wrote in message

> 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
>>
>>
>> JIM
>
>
> 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?
>
> HTH...
>
> Joe
>
>
> --
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com