Intalling SQL server CE?

  • Thread starter Thread starter Zanna
  • Start date Start date
Z

Zanna

What I have to do to install the SQL server CE 2.0 engine and DB on the
pocketPC so I can manage data locally?

Into the BOL are described only the reference to add (SqlServerCE) to my
app... (if I have right understanded), but noway about how can I project
a SQLserverCE DB and deploy it on the device.

There is something I miss? :)

Thanks
 
Zanna ha scritto:
What I have to do to install the SQL server CE 2.0 engine and DB on the
pocketPC so I can manage data locally?
Click to expand...

And how to copy a table from SQLserver to SQLserverCE?

Thanks again
 
By locally, if you mean managing a SQLCE database from the desktop, then SQLCE 2.0 does not include this functionality. Otherwise, you
may use ISQLW on the device. This program is included in the sqlce.dev cab file included with your Visual Studio installation.

The easiest way to copy tables from the server to the client is to use Remote Data Access (RDA) pull method, or to use Merge Replication.
Both of these are described in the SQLCE books online found at:

http://www.microsoft.com/sql/ce/techinfo/20bol.asp

Jon Heide
([email protected])
SQL Server CE Team
Microsoft

----------------------------------------------------------------------------

Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp

----------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at

http://www.microsoft.com/info/cpyright.htm.

----------------------------------------------------------------------------
 
Jon Heide ha scritto:
By locally, if you mean managing a SQLCE database from the desktop, then SQLCE 2.0 does not include this functionality. Otherwise, you
may use ISQLW on the device. This program is included in the sqlce.dev cab file included with your Visual Studio installation.
Click to expand...

Yes, I mean this, and I find out all this stuff :) thanks.
The easiest way to copy tables from the server to the client is to use Remote Data Access (RDA) pull method, or to use Merge Replication.
Both of these are described in the SQLCE books online found at:

http://www.microsoft.com/sql/ce/techinfo/20bol.asp
Click to expand...

Found this too... but... the SQL server 2000 DB from wich I have to do
the Pull can be simply on LAN or it has to be on a IIS site?

Thanks again!
 
Back
Top