Create SqlCe SDF database on desktop?

[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

 

[Sergey Bogdanov]

Currently it is not possible to create SQL CE database on the desktop.
But you can create it in SQL Server and use synhronization to move this
structure to device.

This topic has already been discussed here. See:
http://groups-beta.google.com/group...work.compactframework&q=SQL+CE+desktop&qt_g=1

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

 

[Tim Johnson]

Good thought, I'll give that a try.

--

Tim Johnson
High Point Software, Inc.
www.high-point.com
(503) 312-8625

 

[Sergey Bogdanov]

Also this might help:
http://www.pocketpcdn.com/forum/viewtopic.php?t=4365

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

 

[code]

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

 

[Pete Vickers [MVP]]

Hi,
RemoteSQLCE at our site lets you do this, and much much more

Thanks

Pete

 

[chora]

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.

 

[j.edwards]

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

 

[Tim Johnson]

I like it!

What's the trick to detect the underlying platform?

--

Tim Johnson
High Point Software, Inc.
www.high-point.com
(503) 312-8625

 

[Sergey Bogdanov]

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

 

[Daniel Moth]

At runtime use System.Environment.OSVersion.Platform:
http://msdn.microsoft.com/library/d...rfsystemoperatingsystemclassplatformtopic.asp
http://www.danielmoth.com/Blog/2004/09/retargetable-256.html

However best is this:
http://www.danielmoth.com/Blog/2004/09/share-code-if-fullframe_17.html

Cheers
Daniel