Pages

Monday, 13 August 2012

Exporting SQL Server Compact to SQLite


The current available local relational database storage options on WinRT (Windows 8) are limited to SQLite (and maybe some others). Also on Windows Phone 8, both SQL Server Compact and SQLite will be available. So a natural path solutions currently based on SQL Server Compact will be to migrate to SQLite, and the first step would be to move the schema and data to a SQLite database.
I have therefore “bitten the bullet”, and the next version of the SQL Server Compact Toolbox,currently available for download in an alpha version, includes a feature to “dump” a SQL Server Compact database in SQLite .dump format.
Exporting SQL Server Compact to SQLite
Read full article here

No comments:

Post a Comment

Web Informer Button