I was told that I need to change the database I use. It is laggy, and now I’m on a super duper fast till system that i built I can literally do anything I want without having to worry about running out of memory anymore.
Whats the best database to run with samba, and how do I go about changing to it?
Ok, if I said that, it is because you are running SQL Compact Edition (CE), and yes, it is slow. You can check this by double-clicking the SambaPOS title in the top-left. This will reveal the Title bar, and the last 2 characters indicate the Type of DB you are running. If it says CE, you should definitely upgrade your engine.
You need to download and install SQL Express 2014:
Ok so far, I have samba4 connected to the database that I created but its showing the sample data and not what I transferred over using the script.
Im presuming I’ve done something wrong?
If I look at my database using the server manager i can see tat it is the correct database and it shows my products, so I presume its just as simple as loading my database onto the one i created? I can’t see how to do that.
What is the problem with having three output files? It probably splits them because files becomes too big. You should be able to merge them inside SQL management studio query editor by pasting file contents in order.
Also you can try checking SQL CE toolbox settings as it may have a setting to control how it splits files.