Can SQL Mobile data be replicated with SQL Server Express DB's?
Thx,
Kim.

I hope someone may give me such a good hint then last time someone did :)
I got an PPC application with .NET CF 2.0 made in VS2005 using SQL
Mobile 3.0
Mainly I got 3 big tables (A,B,C) which were (logically) related to each

I'm currently writting a Pocket PC application using the .NET Compact
Framework v1.0 to ensure portability to older handsets that don't support
.NET Compact Framework v2.0.  In the same spirit I want my application to
access an underlying SQL Sever CE database, and I'm concerned ...

The primary key of a table has the Identity attribute. Using VN 2005, I
have the xsd schema and I have built a form. The DataAdapter has
automatically the InsertCommand value.
The problem is that when I insert records, the Identity value is not

hi.. sorry if i'm using broken english..
i'm developing application using PDA with sql server ce.. my problem is.. how
can i sync data from sql server 2000 x sql server ce or vice versa? is anyone
can tell me what to do? what step or any idea? thank you..

Can I do SQLCE replication of part of a table? (2-way replication)
Evan

Just wondered, what querying tools does one have, once SQL CE is installed
on the PPC?
Kind Regards
Ricky

Is it possible to deploy a non encrypted no user protected database with
my application and then give the user the chance to set an user afterwards?
My application is coded in C# / .NET CF 2.0
Thanks!

I've finally got SQL CE 2.0 installed on my PPC, not as hard as I first
thought it would be :-).  Although now, I seem to be having problems
actually getting the database on the PPC, I've followed some instructions
online, which uses Replication, but does not really make any sense.

I am trying to manually install the required files for SQL CE, it tells me
to install from the following directory :
   Program Files\Microsoft SQL Server CE 2.0\Device\processor
family\processor type

I have recently started to test out replciation between SQL and SQLCE. It
works ok,  but on some more test I dicovered that when I synchronize, the
Device database always accepts SQL data (when that is changed), thus
overwriting any data that was entered in the Device.

I've got a table with a bunch of nvarchar columns that need to be
converted to Memo.  Is there a way to do this without having to build a
new database?
THanks

What can I best use for the best performance:
SQL mobile server 2005 or XML on a Windows mobile 2005 PDA.
I have to use about 10 file's with about 40 records each.
The file are just plain text with a delimiter in between and I have to use

I am trying to achieve the following. Is there any way to accomplish
this?
I have two table,  t1 contains
    ActCatID, ActiveID, CategoryID

I've got a SqlCeCommand, that I am calling ExecuteReader on (passing the
CommandBehavior.CloseConnection enumeration value).  Anyhow, suprisingly I
get a FileNotFound exception.  Here's the exception:
System.IO.FileNotFoundException occurred