Hello everyone,<\/p>\n
Recently I’ve stumbled upon a small nifty tool, that’ll allow you to retrieve the database schema of your SQL Compact Edition database ^.^<\/p>\n
The tool is relatively easy to work with, provided you have the correct SQLCE runtimes installed..
\nIn my case (having a x64 system) I had to install the x86 runtime first, and after that the x64 runtime.<\/p>\n
Anyhow, the tool is not made by me, but it’s made by Erik Ejlskov Jensen. The tool can be downloaded here<\/a><\/p>\n It’s available as an addin for SQL Server Management Studio 2008 (Express) or as a simple CLI<\/p>\n <\/p>\n Using the CLI tool is pretty easy. ‘ExportSqlCE.exe “Data Source=MyDataBaseFile.sdf<\/strong>;” MyDataBaseSchema.sql<\/strong>‘<\/em><\/p>\n Mind you that the “MyDataBaseFile.sdf” is the location of where your SDF file is located. If you have place the file in the same directory as the ExportSqlCE tool, then you’ll only have to put the filename there. Hit enter and when the operation is complete, you’ll have a nice *.sql file containing the sql commands to create your tables and insert data that was already in there. Hello everyone, Recently I’ve stumbled upon a small nifty tool, that’ll allow you to retrieve the database schema of your SQL Compact Edition database ^.^ The tool is relatively easy to work with, provided you have the correct SQLCE runtimes installed.. In my case (having a x64 system) I had to install the x86 runtime … Continue reading ExportSqlCE<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[38,6],"tags":[],"_links":{"self":[{"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/posts\/391"}],"collection":[{"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=391"}],"version-history":[{"count":1,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":778,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions\/778"}],"wp:attachment":[{"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dirk.schuermans.me\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nYou can find his blog here<\/a><\/p>\n
\nJust open up your CMD window, point to the directory where the EXE is located and type, for example, the following:<\/p>\n
\nOtherwise you’d have to place the full file path \ud83d\ude42<\/p>\n
\nThere are also several flags<\/em> available to be used with the EXE, more info when you use the \/?<\/em> flag \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"