Search code examples
exportsql-server-cecreate-table

How to export SQL server compact 3.5 database (or view the "Create table")

I have a SQL server compact 3.5 database (.sdf) and I would like to use it to recreate the same schema in a new SQL server database. So my question is: Is it possible to export the structure of my tables somehow?

Ideally, the result would be an SQL file with lot of "Create table..." that I could use to create a similar database. I don't need to export the data as this stage.

Thanks for your help!

Solution

  • Use my SQL Server Compact Toolbox (VS add-in or standalone) - http://sqlcetoolbox.codeplex.com