Re: Using replication
From: Michael--J (MichaelJ_at_discussions.microsoft.com)
Date: 10/01/04
- Next message: Neil Kiser: "Securing the connection string (mainly the password within the string)"
- Previous message: John M: "Opening the .sdf file on my PC"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Next in thread: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Reply: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Sep 2004 17:29:07 -0700
That is quite unfortunate. The reason i asked is because my SQL Server 2000
database is connected to a system which detects a particular event. When that
event occurs, we wanted that system to "ask" the SQL Server 2000 database to
request a download of data from the CE device. Since that's just not possible
and there have been frequent requests of this functionality, in your opinion,
what do you think would be the best alternate option to take to implement
this? I was thinking, maybe i could instead "ask" the CE device to initiate
the upload via IP or something? Thanks a lot.
Michael--J.
"Kevin Collins (MS - SQL Mobile)" wrote:
> Unfortunately there is no server side initiated sync with merge replication.
> Since RDA does not run on the server at all, there is also no concept of a
> server side initiated sync. However, the concept of a server side initiated
> sync is something that is frequrently requested.
>
> In the future we are considering a feature that when you cradle a device and
> use ActiveSync, that all subscription databases that are chosen would sync.
> However, that would not apply to RDA.
>
>
> "Michael--J" <MichaelJ@discussions.microsoft.com> wrote in message
> news:2AD2B3A6-88A6-400D-A2FF-59ED341CEFF0@microsoft.com...
> > Hello,
> >
> > I see what you mean. I have actually implemented what i wanted by using
> > RDA
> > SubmitSQL which inserts new rows into tblMetersDesktop based on
> > tblMetersCE.
> > This however is initiated by the CE device. Is there anyway of doing this
> > one
> > way RDA method from CE to desktop but with the desktop initiating when it
> > wants the data to be sent? Thanks.
> >
> > Michael--J.
> >
> > "Kevin Collins (MS - SQL Mobile)" wrote:
> >
> >> You could also set up dynamic horizontal filtering in the publication.
> >>
> >> However, if you just need to re-download a table and not keep the
> >> existing
> >> rows and the data is always coming down from the server to the device,
> >> using
> >> the RDA PULL method will be your best option.
> >>
> >>
> >> "Ralph" <quakefest@ozemail.com.au> wrote in message
> >> news:99151267.0409252148.40018b84@posting.google.com...
> >> > hi Michael,
> >> >
> >> > This is feasible.
> >> > If you are going to look into merge replication, then look into the
> >> > ExchangeType Property in the SQL Server CE books online.
> >> >
> >> > This flag should allow you to synch the data in the direction you wish
> >> > tblMetersCE -> tblMetersDekstop
> >> >
> >> > Also, if you are doing a one way sync look into RDA. Its much simpler
> >> > to work with and has a method called Push() that allows you to synch
> >> > data from your SQL Server CE table up to an SQL Server with a few
> >> > lines of code.
> >> >
> >> > regards,
> >> > ralph
> >> >
> >> > "Michael--J" <MichaelJ@discussions.microsoft.com> wrote in message
> >> > news:<B1DC95E8-55FE-4CA3-A4AE-163EF705132B@microsoft.com>...
> >> >> Hello,
> >> >>
> >> >> I am working with an x86 embedded device
> >> >> (http://www.abiatech.com/fb6500.htm) running Windows CE.NET 4.2. On
> >> >> this
> >> >> device, i have a database which has a table containing 40 rows. This
> >> >> table
> >> >> contains metering information for 40 gaming machines. Call this table
> >> >> "tblMetersCE". I have a C# app which continously updates this table.
> >> >>
> >> >> A server on the network is running SQL Server 2000 and it has a
> >> >> similar
> >> >> table to "tblMetersCE", call this table "tblMetersDeskop". Instead of
> >> >> having
> >> >> a fixed size of 40 rows, it continuously grows by appending snapshots
> >> >> of
> >> >> the
> >> >> current status of all 40 gaming machines at certain times. So in
> >> >> effect,
> >> >> appending a snapshot increases the size of this table by 40 rows. At
> >> >> the
> >> >> moment, the size of "tblMetersDekstop" is over 59,000 rows.
> >> >>
> >> >> I was then asked to use replication such that if changes are made to
> >> >> "tblMetersCE" an automated snapshot of this table is added to
> >> >> "tblMetersDesktop", thereby logging the current status of the gaming
> >> >> machines. Can replication be used this way? To my understanding, i
> >> >> thought
> >> >> replication was used to keep tables located on different machines
> >> >> consistent.
> >> >> So to replicate "tblMetersDesktop" as "tblMetersCE" on my device,
> >> >> "tblMetersCE" cannot remain fixed to 40 rows in size and needs to grow
> >> >> like
> >> >> "tblMetersDesktop"? I need to know because i have to tell my
> >> >> supervisor
> >> >> about
> >> >> the feasibility of this concept.
> >> >>
> >> >> Kind Regards,
> >> >>
> >> >> Michael--J.
> >>
> >>
> >>
>
>
>
- Next message: Neil Kiser: "Securing the connection string (mainly the password within the string)"
- Previous message: John M: "Opening the .sdf file on my PC"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Next in thread: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Reply: Kevin Collins \(MS - SQL Mobile\): "Re: Using replication"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
