SQL Server Compact/sqlite Toolbox uses

Recently friends an embedded database with sqlce needs to be imported into SQLite, the web found this tool--sql Server compact/sqlite Toolbox. But in the use of the time encountered a little twists and turns, recorded to the needs of friends.

This is a plug-in visual Studio, in VS2010, 2013 and other environments can be used, very convenient. See official website http://sqlcetoolbox.codeplex.com/

Body

1) Download and install the plugin from the official website or from Microsoft's website. Address https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/;

2) Start visual Studio and connect to the database first!!! (Tools--connect to a database);

3) connect the SQLCE database. Start the SQL Server compact/sqlite Toolbox plug-in (View-Other Windows--sql Server compact/sqlite Toolbox);

4) Import the sqlce into SQL Server. First select the SqlCe database, right---migrate to SQL Server;

5) Import the SQL Server database into SQLite. In the plugin window data connection--Right-click Export SQL Server to SQLite;

6) OK

SQL Server Compact/sqlite Toolbox uses