extract schema for sql server compact edition

Question

Is there a way to generate the sql statement for tables in sql server compact ? same as for sql server express+ ?

Essentially a create table( .... ) statement as output ?

Cotenant

Answer 1

There is a project on Codeplex that someone has actually built the functionality to be able to do scripting for sql server compact edition databases.

Harebrained

Answer 2

There is a tool to do this. Check out http://www.antipodeansoftware.com/Home/Products This will iterate the entire SQL server, and write all the table, view, stored procedure and UDF scripts to a local drive. Great for adding SQL schema or DDL to source control.

Hach

Answer 3

The plugin SQLite & SQL Server Compact Toolbox has versions for Visual Studio and SQL Server Management Studio. I've used the latter version successfully to add columns and export the schema as CREATE TABLE statements from SQL Server Compact Edition 3.5.

Stannwood

Answer 4

You can connect to SQL Server Compact Edition using SQL Server Management Studio(SSMS), which in turn allows you to script out all database objects.

Please refer to: Managing SQL Server Compact Edition with SQL Server Management Studio

and then also, How to: Generate a Script

Significs

Script generation (and many other features) are hidden/disabled when you open a .sdf file (SQL Server CE) in SSMS. – Mishmash