i'm trying to transfer data from my SQL Server 2005 DB to a SQL Mobile DB.
I found the only way is to configure a merge replication.
When i create the subscription, the process starts but then:
-------------------------------------------------------------------------------------

I have successfully set up a merge replication between a SQL2K database and
SQLCE on the device, however:
If I just wish to update data from a local SQLCE database to the SQL2K
server then what is the best way of going about this. Currently on

and sorry for crossposting - I first wrote this message in the
compactframework
newsgroup, sorry.
I wrote a little Test-Application which fetchs about

I have managed to get RDA Push working between SQLCE and my remote SQL
SERVER 2K but have the following problem.
The remote DB that I am pulling from / pushing to has an id column as
primary key with an auto incrementing value. If I push new data from SQL CE

To enumerate all tables in a SSCE 2.0 database, i used the following
request :
"SELECT * FROM MSysObjects"
But it seems this table (MSysObjects) does not exist with SSCE 3.0. Is

I get records from form and insert into database but i have a littel
problem.
One of my coloumn data is Identity and increases 1 and another coloumn of
same sql ce table must get this coloumns

I have a few quick questions: Can either SQL Server CE 2.0 or SQL Mobile
connect to SQL Server 2005 Express via RDA ?
If indeed SQL Server 2005 Express accepts RDA connections, can SQL Server CE
2.0 connect to it or does it only work with SQL Server Mobile ? I know SQL

I'm using the RDA - Pull method to download data from my SQL Server
2000 database to my PDA.  I have this working fine in my environment,
but when I try to run it on a clients network I am getting an error.
Source: Microsoft SQL Server 2000 Windows CE Edition

Can Sql 2005 Integration Services (SSIS / new DTS), be used to generate Sql
Mobil (SqlCE3.0) databases.  If so, can someone tell me where I can find
more info?
Thanks,

I heard that it's possible to use Sql Mobil with the full .NET framework 2.0
from the desktop.  Can somebody point me in the right direction where I can
find more info?
Thanks,

After installing VS 2005, i've found Sql Mobile .cab files for PPC 2003
device, but not for PPC 2003 emulator (X86). Does it exists ?
Thanks in advance.

I have a SQL server instance on the local machine.
IIS is running on the local machine.
Using Active Sync 3.7 on local machine.
I am able to use RDA to sync with it fine as long as the local machine is

I am needing to replace ADOCE functionality (using a desktop MDB file
converted to a CDB file) with SQL CE functionality.
Would someone be so kind as to send me a link to where newbie sample Pocket
PC VC++ code for SQL CE might be?

The designer for SQL Mobile 03 databases in VS 2005 is quite cool, but it
doesn't seem to let you create relationships between tables at all.
Anyone know a way to do this without resorting to writing SQL?
I think the designer in SQL 05 lets you. Is there any way to use just the

I have an application on a PPC with a SQL Mobile Server (3.0). I need to
syncronize data from a SQL Server 2000 to it. For that, I select data on the
SQL Server 2000 with the Data.SQLClient namespace and create Insert
statements for the SQL Mobile database. After I collected the ...