Re: Database Problem ??

From: William Ryan eMVP (bill_at_NoSp4m.devbuzz.com)
Date: 03/21/04


Date: Sun, 21 Mar 2004 11:55:07 -0500

A Sql Server 2000 or 97 DB isn't going to work on CE. Different file types,
different everything. You'll need to set up Replication
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcemergereplication.aspx

The main thing is going to be calling the Synchronize method of your
SqlCeReplication object. You can do this in form_load, when the application
starts, when it ends, wherever it's appropriate in your app.

HTH,

Bill

"Jess" <anonymous@discussions.microsoft.com> wrote in message
news:BD8D6E74-0F6C-4303-A3CD-DC0B9B592FCE@microsoft.com...
> How to download the database From SQL Server 2000 or 7 to SQL Server CE.
Can This work on emulator ??? Where should I put the code to download the
database ?? Is it in "Form_Load"
> Thanks



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.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)
  • Re: How convert from Desktop to PDA
    ... Replication is used when you want to synchronize the SQL Server ... You may also do that with RDA, ... > How can I convert an Sql Server database on desktop into a Sql server CE ...
    (microsoft.public.sqlserver.ce)