Re: How convert from Desktop to PDA

From: João Paulo Figueira [eMVP] (joao.figueira_at_primeworks.takethisout.pt)
Date: 09/23/04


Date: Thu, 23 Sep 2004 09:35:37 +0100

There are a number of ways to do it. If you want to use Microsoft-provided
tools, you have Merge Replication or (probably better for a simple
conversion) RDA (Remote Data Access). These tools require an active internet
connection to the SQL Server through IIS. These are different approaches,
though. Replication is used when you want to synchronize the SQL Server
database with one or more device databases. You may also do that with RDA,
but at a "lower level". RDA is great for importing tables and full databases
and for synchronizing when data is "partitioned", like when each device will
generate and use data that will not be used by other devices. Replication is
better for unpartitioned cases.

You can also use third party tools like the one I have developed (see it in
www.primeworks.pt). This one will do the trick over ActiveSync.

-- 
João Paulo Figueira
Embedded MVP
"Rita" <Rita@discussions.microsoft.com> wrote in message
news:159F0D70-3BB5-47C4-A864-EE477F551D73@microsoft.com...
> Hi all.
>
> I am beginner with Sql Server.
> How can I convert an Sql Server database on desktop into a Sql server CE
> database on PDA
>
> Thaks in advance.


Relevant Pages

  • Re: How to Replicate an SQL Server 2000 Database
    ... If i do this in Query Analyser should i have the DB closed? ... Now regarding Replication, i am brand new to this... ... And then stop and start SQL Server. ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.access.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge replication or manual one?
    ... administration you can tolerate. ... If you're on a high speed network, Merge, RDA, or a web-services ... based approach to replication are all great options. ... >I have a one SQL Server 2000 and plenty of SQL Servers CE on PocketPC's. ...
    (microsoft.public.sqlserver.ce)