So I wanted to compare the sql server which gets installed with samba, and the other sql sever if you need multiple terminals.
I ham using SQL server 2014 and seem to get quite a bit of slowdown on my pretty low spec register, so Im considering moving to the CE as I have no need for the full server, or so I dont think.
With the CE am I still able to script the database with Jscript, and still able to view the datbase? Also would it be relatively easy to convert back.
If the sql server 2014 does have a minimal footprint I might just stick with it, but atm Im just trying to speed up samba in any way and that seems like something I dont need as I only need 1 register.
Do local dB instead of ce. CE will eventually get slower and it does not support some advanced queries. There are things you can do to increase performance of SQL server including disabling any active virus scan. No its not easy to revert back. CE has to be manually scripted back into SQL. You won’t be able to use your Web management stuff and likely some of your scripts will not work.
CE is horrible if you ask me.
Local dB backups can be loaded into full SQL so converting is easy.
Local dB is SQL express but it runs as a process specifically for Sambapos instead as a service.
You can install a minimum install of SQL express as well. Do not install any reporting services etc. I’ve ran SQL express on some very low spec atom based systems and it ran just fine.
My standard terminal hdd image has minimal SQL Express installed to make ready for expantion.
As machines are spec enough no problem with this and never really bothered with localDB.