Start a new topic

Quotewerks SQL on LINUX (SYNOLOGY) How To ...

We managed to deploy Quotewerks (SQL) on a NAS server (SYNOLOGY - Linux OS) to be able to implement QuoteWerks Web.

We have a few SYNOLOGY NAS servers, one of which we use to host our website and an FTP site for our clients' file transfers. We don't have Windows servers.

We needed to implement QuoteWerbs Web.

QuoteWerks Web requires that the database be in SQL format, and managed by Microsoft SQL Server.

Microsoft does not offer an SQL database management application on Synology, since it is LINUX, but on the other hand Synology does offer DOCKER software.

Docker is a tool designed to make it easier to create, deploy, and run applications by using containers. Containers allow a developer to package up an application with all of the parts it needs, such as libraries and other dependencies, and deploy it as one package. By doing so, thanks to the container, the developer can rest assured that the application will run on any other Linux machine regardless of any customized settings that machine might have that could differ from the machine used for writing and testing the code. In a way, Docker is a bit like a virtual machine. But unlike a virtual machine, rather than creating a whole virtual operating system, Docker allows applications to use the same Linux kernel as the system that they're running on and only requires applications be shipped with things not already running on the host computer. This gives a significant performance boost and reduces the size of the application.

And importantly, Docker is open source. This means that anyone can contribute to Docker and extend it to meet their own needs if they need additional features that aren't available out of the box.

And the good news, we NAS user have Microsoft SQL Server available for DOCKER, isn't that nice ……

So we first install DOCKERS in a second step, microsoft / mssql-server-linux, configured some ports, And voila! The system is super stable, everything works internally and externally.

We had doubts, deploying an SQL database, with dedicated servers, can become complicated. We are a small company and very happy to have found this solution ...

Good QuoteWerks on the road!












1 Comment

That is VERY useful to know. Thank you Bernard!

Login or Signup to post a comment