Migrate a SQL Server database to SQL Server Compact or SQLite
This page demonstrates how to migrate a SQL Server database to SQL Server Compact or SQLite.
First, add a Connection from the Toolbox to your SQL Server / Azure SQL database
If you are migrating to SQLite or SQL Server Compact 4.0, you can choose to use the simple one-step GUI:
If you prefer script or must migrate to SQL Server Compact 3.5, use the script base solution.
From the SQL Server connection, choose "Script Database", then "Script Database Schema and Data". This will create a script file on your disk.
Then connect to a new or existing SQL Compact or SQLite database file
Open a New Query window
In the query window, open the script generated above (first button highlighted below) , and then run it (second button highlighted below)
And you are done!