Filling SQL CE on Desktop ?

  • Thread starter Thread starter info
  • Start date Start date
I

info

Hi There
is it possible to filll the SQL CE Server on the Desktop PC?

So I could for the first time import fill the Server on my PC and then
transfer the filled server to the PDA ?
 
You can only do this with SQL Mobile (3.0). With SQL CE 2.0 this is not
possible.
 
If you have Visual Studio 2005 B2 installed, you can use the
SqlServerCE namespaces from a desktop app.
Or, you can use SQL Server 2005 to build a bulk copy file.
 
You can create a DTS package that fills a SQLMobile database with the
contents of just about any datasource using SQL Server 2005 Integration
Services (old name = DTS), -or-, you can simply create a SQLMobile database
in SQL Server 2005 Workbench and make it a subscriber to a publication
which is a SQL Server database. Once you add the subscription to the
newly created SQLMobile Database, it will be filled with the contents of
the publication.

You can also do this programmatically using the System.Data.SqlServerCe
namespace. Use normal DDL commands to create the schema and then
fill the tables via replication or load from CSV files. (or type in rows by
hand in either the VS2005B2 Data Source window or SQL Server 2005
SQL Workbench.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
Back
Top