Autogenerating SQL CE databases scripts?

[Marco]

I'd like to know if there is any desktop program/utility that allows a
developer to create a SQL Server CE DB without having to write by hand the
required SQL CREATE TABLE/INSERT statements. The program should either
create the DB, or autogenerate the statements to execute to create the DB.
After years of SQL Server CE existence, is there such a simple tool, or not?
Thanx
Tony

 

[Tomer]

Try using SQLCE Query, it's cab file name is :
sqlce.dev.ppc3.arm.CAB

And it's location is (for pocket pc arm):
C:\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce300\arm

you will also need to install the sqlce.ppc3.arm.CAB also, which is in the
same dir of the first cab.

 

[khorad]

I'd like to know if there is any desktop program/utility that allows a
developer to create a SQL Server CE DB without having to write by hand the
required SQL CREATE TABLE/INSERT statements. The program should either
create the DB, or autogenerate the statements to execute to create the DB.
After years of SQL Server CE existence, is there such a simple tool, or

not?

i know at least one such utility exists because i wrote it

it's a vb6 app that takes an access db and converts it to a list of sqlce
commands

then on the pocketpc side it parses the txt file and executes each line

i'm really new to all this and it only took an hour to do so it's not hard

of course it only does the bare minimum to meet my needs and the code is too
embarrasing to release, but if i can do it, anyone can!

if you're looking for a more OTS solution try these links:

http://www.efeyazilim.com/pocketsync/
http://www.emfakt.com/en/teknologi/database/database.html
http://www.fitiri.com/F_Wireless_Apps2.html
http://www.innovativedss.com/sqlink.asp

on a side note microsoft is making a very big mistake by ignoring
non-enterprise customers.

transferring data between the desktop and pocketpc is such a basic and
important operation it should have been made stupidly easy

instead i see so many people (including me) struggle with this that it is
unbelievable

the stock response of 'just use sql replication' or whatever is idiotic for
many, many people. Like grandma is going to install sqlserver on her machine
.. . .

or it's 'use this third party control/wrapper' which may not be supported in
the future and why should i have to pay extra for a basic service? It's like
having to pay extra to get forms to work. Not to mention many people will
never find these utils and will just give up in frustration.

enterprise apps might have the fat margins, but it's consumer apps that are
going to drive mind and marketshare and MS is just shooting itself in the
foot by pretending this market doesn't exist

(yes i know it can be done as i'm doing it myself, i'm just saying it should
be stupidly easy, there should be no struggle with such a basic operation)

 

[Marco]

And there is no supported (shareware, commercial, freeware, anything) that
does this? Basically, having a program that takes a MDB Access file and
generates all the SQL statements to recreate a DB for SQL CE would be a good
addition to my toolbox. I could then execute those statements with
SqlCeCommands easily. I can;t believe such an app does not exist...