Re: Replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Darren Shaffer (darrens_at_nospam.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 09:53:15 -0600

The SQL CE Books Online contain a nice chart that shows you the data type
mappings
that are compatible between SQL Server 2000 and SQL CE and how some of these
types get translated from one to the other. I'd start there.

Then realize that there are some other differences between the two that will
affect your
schema design decisions. These include replication of identity columns,
ability to set a PK on
text-based columns, stored procedures, triggers, etc. Good coverage of
these topics in either
the .Net Core Reference from MSPress or Yao's book ".Net CF Programming with
C#".

-Darren

"robert" <robert@discussions.microsoft.com> wrote in message
news:415DE041-524D-435E-95CB-79AD2261BC28@microsoft.com...
> Hello,
>
> I have delevoped a Smart Device Application on my PocketPc with a local
> Sql
> Server Ce database. Now i want to develop a desktop application with the
> same
> functionality and replication between these two databases.
>
> Can anybody explain what i have to consider referring the creation of the
> database on the desktop? - does the types of the columns in the database
> have
> the same type as on the Sql Server Ce database? -etct.
>
> thx
>
> robert

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)