I installed Sambapos with all the default options ticked. I then installed SQL Express and entered the connection details for the newly created database into Settings > Local Settings >Database.
It’s connecting fine but how has the POS already got data in it like tables and sample products when I never did all the “Migration” steps suggested in the knowledgebase? In theory the database should be empty?
There is a tick box that says “Auto Migrate old version databases” and I wonder if that has taken the default/demo sample data from the LocalDB and placed it into my newly created SQL db?
Please follow these steps. Although I know the process involves SQL Server first, then Sambapos. Don’t worry about the information Sambapos installs; you’ll add your own.
However it then seems to tell you to install it again as part of step 2.
I never did that but the data is there after setting SQL connection parameters in settings.
I think it must have automatically migrated the data from the LocalDB when I entered the new SQL Server DB details.
My only concern is having two DBs on the one system as for example if the db connection settings are removed does it just go back to using LocalDB… or what?
I understand. Go to Program Data (it’s a hidden folder). In Sambapos, find the Samba Settings file and delete it. Open Sambapos and connect to the server and your database, or a new database.
Thank you. The settings in that file are the same as the ones I entered into the software for the server and database you mention. Surely deleting it and repeating the step will just make the file the same as it is now?