SambaPOS

Documentation Website

User Tools

Site Tools


Sidebar

Installation

User interface

Basic concepts

  • Departments
  • Terminals
  • Users & user roles
  • Work periods
  • Tickets & orders
  • The POS menu
    • Products & product categories
    • Menus
    • Recipes
    • Product modifiers

Quick-start: setting up a (very basic) POS configuration

Advanced concepts

Customizing your POS system

Extra

Mobile Client

SambaPOS License

converting_ce_database_to_sql_express

Exporting CE Database to SQL Express

Download SQL Server Compact Toolbox tool from http://sqlcetoolbox.codeplex.com/. This tool will export your whole CE database into a text file (*.sqlce) that contains required SQL Scripts to create your database under SQL Server Express. So what you'll do is exporting your data to a text file and importing it with SQL Server Management Studio (SSMS). If you followed SQL Server Express Setup documentation SSMS tool should be already installed.

 If your database contains a lot of tickets Export tool may create multiple export files due to file size 
 limitations. In this case you'll execute these files with SSMS one by one in creation order.
 
 

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 Savebutton.

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 open that file with a text editor like notepad you should see some auto generated SQL code similar to that.

  1. Open SQL Management Studio.
  2. Create new Database.
  3. Create new Query,
  4. Copy & Paste everything from generated .sqlce file content to inside Query editing window.
  5. Execute Query. That will create tables and data.

converting_ce_database_to_sql_express.txt · Last modified: 2017/02/24 11:12 (external edit)