Screen shots for exporting SQL CE data to SQL Server Express.
Download SQL Server Compact Toolbox tool from http://sqlcetoolbox.codeplex.com/.
Visit http://sqlcetoolbox.codeplex.com/releases and choose Standalone Version 4.0.
Right click on left pane and choose Add SQL Server Compact 4.0 Connection... menu item.
A toolbox window will appear. Click Browse button to choose your sdf file.
Under [MyDocuments]\SambaPOS4 folder find SambaPOS4.sdf file or the sdf file you’re actually using.
Click Test Connection button. If it succeeds click Close button.
SambaPOS4.sdf file should appear here.
Right Click on SambaPOS4.sdf and choose Script > Script Database Schema and Data menu item.
File Save dialog will appear. Enter a name to the export file (I’ve named is MySambaPOSData) and click Save button.
Table Selection Dialog will appear. Don’t change anything on this screen and click OK. __MigrationHistory table is unselected by default and there is no need to export it.
Few seconds later export will complete and you’ll see this confirmation message.
Tool Created a file named as MySambaPOSData.sqlce. This file contains required SQL scripts to recreate your database under SQL Express. If you edit that file with a text editor like notepad you should see some auto generated SQL code similar to that.
Open SQL Management Studio. Create new Database, Create new Query, Copy & Paste everything that file contains inside Query editing window and execute Query. That will create tables and data.