Migrate/Import entire database from one SQL instance to another

[fickle_123]

I would suggest you Use Database Backup Module

How to use Database Backup Module

Backup Module is an Add On Module for SambaPOS. You can install it through SambaMarket. When you install Database Backup Module it will add Database Backups link to Management > Settings section. [image] Since we don’t have any backups yet the main screen is empty. [image] Click Backup Database button to create your first backup. [image] You should see backup details on the list. New backups will appear on top of the list. You can select a backup on the list and click Restore Dat…

Here’s my Workflow and it works just fine

1. I have 2 sambapos machines, one is a operational-version at the restaurant. Another one is for development/experiment purpose stored in my personal laptop that i always carried around
2. I used Database Backup Module to automatically backup my operational-version database to dropbox after the work period ended. This allows me to Restore(Import Database) operational-version database into my laptop for experiment/development purpose.
3. Once i’m happy with what I modified, I manually backup the database from my laptop and restore the database on the machine at workplace on the following day.

hope that helps