Marco said:
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)
