Networks

Ask something
Question Locked

SQL Server 2000 to SQL SERVER CE

0 helpful
3 replies

by dbrunelle

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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??? :(

3 replies

by robo_dev

In Enterprise Manager:
1) open the databases folder
2) highlight the database you want to generate a SQL script for
3) right-click and select "All Tasks..."
4) select "Generate SQL Script"
the "Generate SQL Script" window pops-up.

At this point, just click on the "select all" button near the
top-right corner. You can select objects individually for scripting at
the bottom-left section of the window or, at the top-left section, you
can select "all tables", etc.

by dbrunelle

Once I created the scripts ( I knew that existed but didn't know if I could use it for that or not), how can I apply them to the .sdf file? I connected it to the database server so I can see it on management studio, but I can't 'use' the database with the path.

Thanks

This discussion is closed to new replies.