replication

Hello,
I wrote a desktop application with a SQL Server 2000 database and a mobile
application for PocketPc with a SQL Server CE Database and I realized a
replication mechanism that when the user presses a button on the PocketPc
application the data will be synchronized via WLAN and the updated data will
be displayed automatically. Is it possible when the user synchronizes the
database from the desktop, do the data on the PocketPc automatically be
updated? or can I perform the synchronization only from the mobile
application?
i hope anybody has understand my question.
thx
robert
When you are replicating to a SQL CE database it is always a pull
subscription. Your only option is to continually poll the publisher and then
somehow trigger the pull. You can't do this within SQL CE, but could
probably use another mechanism to trigger it. I can't think of a mechanism
to do this however.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"robert" <robert@.discussions.microsoft.com> wrote in message
news:B7AFD6DE-70FA-403F-82C5-7101DABA3DC8@.microsoft.com...
> Hello,
> I wrote a desktop application with a SQL Server 2000 database and a mobile
> application for PocketPc with a SQL Server CE Database and I realized a
> replication mechanism that when the user presses a button on the PocketPc
> application the data will be synchronized via WLAN and the updated data
will
> be displayed automatically. Is it possible when the user synchronizes the
> database from the desktop, do the data on the PocketPc automatically be
> updated? or can I perform the synchronization only from the mobile
> application?
> i hope anybody has understand my question.
> thx
> robert
|||Hello
I did not understand your answer in details. So it is not possible to
synchronize a desktop database with a sql server ce database from the
desktop? - So the data will be synchonized and updated on the sql server ce
database?
robert
"Hilary Cotter" wrote:

> When you are replicating to a SQL CE database it is always a pull
> subscription. Your only option is to continually poll the publisher and then
> somehow trigger the pull. You can't do this within SQL CE, but could
> probably use another mechanism to trigger it. I can't think of a mechanism
> to do this however.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "robert" <robert@.discussions.microsoft.com> wrote in message
> news:B7AFD6DE-70FA-403F-82C5-7101DABA3DC8@.microsoft.com...
> will
>
>
|||it is possible, but you must always initiate the synchronization from the
SQL CE device.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"robert" <robert@.discussions.microsoft.com> wrote in message
news:3F1FA26C-1FC3-4F2F-AF63-9C03A43486A4@.microsoft.com...
> Hello
> I did not understand your answer in details. So it is not possible to
> synchronize a desktop database with a sql server ce database from the
> desktop? - So the data will be synchonized and updated on the sql server
ce[vbcol=seagreen]
> database?
> robert
> "Hilary Cotter" wrote:
then[vbcol=seagreen]
mechanism[vbcol=seagreen]
mobile[vbcol=seagreen]
a[vbcol=seagreen]
PocketPc[vbcol=seagreen]
data[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]