Hi, is the an application other than sql server management studio to run queries on database? If not i have to install sql server express? Will 2022 be ok?
SQL Express Server 2022 is compatible with SambaPOS.
If you are restoring an older database on this SQL Server, you will have to edit Properties of the database and set it to 2022 as it doesnt happen automatically.
SQL Studio is generally used to run queries for the database or test report queries before you implement custom report queries within SambaPOS itself.
So there is no alternative?
Alternative to what exactly? Run queries for a database?
For MySQL you’d use MySQL Workbench, for PostgreSQL you’d use PostgreSQL Studio, for Microsoft SQL Server you’d use Microsoft SQL Server Studio or some other open source alternatives.
If none of that works, you can use Command Prompt or Powershell to enter SQL shell and run queries there.
Alternative for Microsoft SQL Server Studio. My sambapos db is Localdb and i dont want to install Sql Server express this moment. I want to know if the is any other application to connect to the localdb .
There are loads of options for software to run queries for LocalDB, most of them are proprietary software that usually come in Free Trial or Community version and are paid for (dbForge, Toad, Navicat etc) and to be honest, I wouldn’t know what the tricks or features they have.
For me personally the most cost effective solution is latest version of MS SQL Server Studio for Microsoft SQL
I tried to connect with dbeaver with no success. I will install Sql server express as you are suggesting! Thanks for the help
1 Like
Just an update to anyone who might need it. Azure Data Studio can connect to localdb.
Mssms can connect to it as well. There is a lot of examples on this forum and on web with how to connect mssms to localdb
1 Like