Hi,
We are currently developping an application that have two version, a PC version, that uses SQL Server 2005 as a database server, and a Mobile version that use SQL Server CE version.
I know how to create a CE database using Management Studio, but I have to create all table definition by hand.
Since the CE version will have the same structure that the 2005 version, but with only a subset of the informations (which will be inserted by the PC version while the Mobile will be docked), and that the software is still in development (so the table structure is open to change more than once a day), I was wondering if there is any way to copy the structure of the 2005 version into the CE version (with some compromise if needed)?
Do I really have to recreate the structure by hand??? 🙁