Menu
I need dockerized database that supports T-SQL and some other things of SQL Server. Of course, there is a container with SQL Server but it takes too much space. So I try to put SQL Server LocalDB (about 200mb) in a docker container.
It has silent mode of installation and can be easily installed. But the problem is how to access it from outside the container? (I need to access it from my local PC too) Is there any solution for this case? For now I have only one idea to implement some service for communication between SQL Server LocalDB and external connections then expose it near the db in the same container. Could you guys please advise something?
416
With Docker, you can also run multiple SQL Server Containers on the same host machine.
The system database files for the database are stored in the local AppData path, which is normally hidden. For example, C:\Users\<user>\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\LocalDBApp1\ .
You can use Docker to run a database in a container as if it were a remote server, and test how your application interacts with it. This tutorial describes how to run a Docker container with a PostgreSQL server and connect to it using IntelliJ IDEA.
Localdb only allows named pipes connections from the machine it is running on. You can use SQL Server Express, 400 MB, which allows TCP connections
115
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
