How to get SQL Server Compact 4.0 Database content query?
You can use my ExportSqlCe command line tools to export the schema and data, and then use sqlcmd to run the resulting script against a SQL Server 2014 database https://exportsqlce.codeplex.com/wikipage?title=Command%20line%20utilities&amp;referringTitle=Documentation