Create SqlCe SDF database on desktop?

  • Thread starter Thread starter Tim Johnson
  • Start date Start date
T

Tim Johnson

Is there a way to create an SQL Ce database on the desktop, either by api or
by a conversion utility? Basically I'd like to hand-craft both the schema
and some test records in Enterprise Manager/Query Analyzer, then *poof* turn
it into a SDF file I can push down onto my PDA.

--

Tim Johnson
High Point Software, Inc.
www.high-point.com
(503) 312-8625
 
SQL Mobile and SQL 2005 SQL Server Managment Studio Allows you to do
this also. You can create a SQL Mobile Database within the studio and
edit it all you want. But this is all still in the Beta Stage.

Cody Olsen
 
RemoteSQL is an excellent product and a great aid for anyone who
develops SQLce applications.

Also I have to mention the great support Pete provides for the product.
 
Not sure if this is what you're after, but what I do is...
- have two projects for an app (one for pocketpc and one for windows) but
both using the same source files (except for forms)
- have classes that wrap both the SQLServer and SQLServerCe database objects
- detect what platform app is running on and use appropriate underlying data
access - this lets me run on either platform without modifying code
- generate both the SQLServer and CE databases using scripts - just a
semicolon list of sql commands such as CREATE TABLE ... - just read from a
resource or file and split on semicolon and execute each cmd
- this means you can work on sql server db on desktop for development and
testing and then just compile and send down for pocket pc when wanting to
test on it
 
If you have two separate projects with the same source files, you can
define conditional compilation constant (e.g. DESKTOP) in one of your
project. And write something like this in your source code:

#if DESKTOP
adapter = new SQLServerDataBase();
#else
adapter = new SQLServerCeDataBase();
#endif

To define conditional compilation constant follow this:
Project -> Properties -> Configuration Properties -> Build ->
Conditional Compilation Constants.

Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com
 
Back
Top