Exportsqlce [better] «Official ◆»
: Generates T-SQL scripts containing table definitions (schema) and statements (data) from Cross-Platform Migration
While SQL Server Management Studio (SSMS) provides some support for SQL Compact, it often lacks the ability to generate a comprehensive "SQL dump" that includes both the table structures and the data in a single script. ExportSqlCE fills this gap by producing standard T-SQL scripts that can be used to: ExportSQLCE
This generates a .sql file containing CREATE TABLE statements and INSERT statements. It is ideal for migrating to SQL Server, MySQL, or PostgreSQL with minor tweaks. or PostgreSQL with minor tweaks.