Hello,
I am new to SQL ce and i want to ask some questions.
I want to built a vb.net aplication for pocket pcs.
I know how to do this. The think that i dont know is how i
can use the sql ce as my database.

And i want to ask this.
Must I install SQL CE on the pocket pc device, then create an SQL
database on my SQL server ( on my pc) and then syncronise the 2
databases (SQL CE on the pocket pc and SQL server on my pc)?
And if this scenario is correct, how can i install SQL CE on the pocket
PC ? Where can i download it?

Thanks in advance

Savvas

RE: SQL CE by RobertBurdickeMVP

RobertBurdickeMVP
Wed Nov 02 16:40:03 CST 2005

There are both desktop and device components of SQL Server CE that you need
to install. After that, you can create databases and tables on the device
either programatically or with the device equivalent of enterprise manager.
You don't need to build the database on the desktop and then sync in order to
get the database on the device (although SQL Server CE suports desktop to
device database sync.)

The MSDN help under System.Data.SqlServerCe has tons of sample code to get
you started.

"savvaschr@nodalsoft.com.cy" wrote:

> Hello,
> I am new to SQL ce and i want to ask some questions.
> I want to built a vb.net aplication for pocket pcs.
> I know how to do this. The think that i dont know is how i
> can use the sql ce as my database.
>
> And i want to ask this.
> Must I install SQL CE on the pocket pc device, then create an SQL
> database on my SQL server ( on my pc) and then syncronise the 2
> databases (SQL CE on the pocket pc and SQL server on my pc)?
> And if this scenario is correct, how can i install SQL CE on the pocket
> PC ? Where can i download it?
>
> Thanks in advance
>
> Savvas
>
>

RE: SQL CE by RobertBurdickeMVP

RobertBurdickeMVP
Wed Nov 02 17:06:02 CST 2005

I posted a sample DatabaseUtils class at
http://rburdick.blogspot.com/2005/11/sql-server-ce-sample-code.html

"Robert Burdick [eMVP]" wrote:

> There are both desktop and device components of SQL Server CE that you need
> to install. After that, you can create databases and tables on the device
> either programatically or with the device equivalent of enterprise manager.
> You don't need to build the database on the desktop and then sync in order to
> get the database on the device (although SQL Server CE suports desktop to
> device database sync.)
>
> The MSDN help under System.Data.SqlServerCe has tons of sample code to get
> you started.
>
> "savvaschr@nodalsoft.com.cy" wrote:
>
> > Hello,
> > I am new to SQL ce and i want to ask some questions.
> > I want to built a vb.net aplication for pocket pcs.
> > I know how to do this. The think that i dont know is how i
> > can use the sql ce as my database.
> >
> > And i want to ask this.
> > Must I install SQL CE on the pocket pc device, then create an SQL
> > database on my SQL server ( on my pc) and then syncronise the 2
> > databases (SQL CE on the pocket pc and SQL server on my pc)?
> > And if this scenario is correct, how can i install SQL CE on the pocket
> > PC ? Where can i download it?
> >
> > Thanks in advance
> >
> > Savvas
> >
> >