Category : sql

just finish installing sql server 2019 alwaysOn on docker container. (references: https://dbtut.com/index.php/2020/06/09/sql-server-2019-alwayson-availability-group-on-docker-containers/ https://www.sqlservercentral.com/articles/sql-server-alwayson-with-docker-containers ). in the above references and others, they are not getting to the "listener" configuration point on docker containers. the question is: how to connect to SQL through listener on DOCKER environment? (how to configure it on docker) thanks Source: Docker..

Read more

I’m new to SQL databases and to Docker containers. I’m trying to follow up a simple tutorial and I have started by downloading Docker and the MSSQL database (and its command tools). After it, I have tried to run the command sqlcmd to check if everything was fine until now and this error appears in ..

Read more

I’ve been having some problems to build with docker compose and dockerfile. There are some errors related to msqltools and sql while I’m building. Here’s the dockerfile: FROM ubuntu:18.04 ARG DEBIAN_FRONTEND=noninteractive ARG PHP_VERSION=7.3 ARG COMPOSER_ALLOW_SUPERUSER=1 Install development packages and clean up apt cache. RUN apt-get update && apt-get install -y –no-install-recommends ca-certificates curl g++ git ..

Read more

I have setup DB2 v11.5.5.1 in a Docker container and accessed it via DBeaver. I want to run a script with a CREATE PROCEDURE statement on DB2 database. But it returns SQL Error [42601]: An unexpected token "END-OF-STATEMENT" was found following "E IF EXISTS TEMP_IDS". The sample script I tried is here. –#SET DELIMITER $$ ..

Read more

This is the docker-compose.yml file I have. Everything is perfect until it starts inserting data into table. I have tried various postgres images like 13-alpine, 12-alpine, 10.5-alpine according to answers replied to other questions but still getting the error at the end. version: ‘3.9’ services: productservice: build: ./productservice container_name: productservice ports: – ‘5000:5000’ depends_on: – ..

Read more

I run the sql image from docker using docker-compose: c:sqldocker-compose.yml version: "3.7" services: mssql: image: mcr.microsoft.com/mssql/server:2017-latest ports: – "1433:1433" environment: – "ACCEPT_EULA=Y" – "SA_PASSWORD=pass.." – "MSSQL_PID=Developer" – "MSSQL_AGENT_ENABLED=true" volumes: – type: volume source: data1 target: /var/opt/mssql/data volume: nocopy: true volumes: data1: I want to restore the database from my bak file in the disk. it’s ..

Read more