Using Containers to Avoid Installing SQL Server

Question

Using Containers to Avoid Installing SQL Server

Steve Jones - SSC Editor

SSC Guru

Points: 740071
More actions
September 6, 2024 at 12:00 am

#4447782

Comments posted to this topic are about the item Using Containers to Avoid Installing SQL Server

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

andy.chalk Newbie Points: 1 More actions · Answer 1

Typo?

"I added this in a batch file with a CD command, which looks like the listing below. This sets me into the right folder, then it runs docker using the docker compose file above. The –d runs this detached, which closes the cmd window after this runs.

cd C:\Data\SQL2019 <====================== HERE!

docker-compose up -d

This is saved as startsql2022.cmd in my c:\utilities folder, which is in my path.

I also add a StopSQL202

Steve Jones - SSC Editor SSC Guru Points: 740071 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 740071

September 6, 2024 at 9:53 pm

#4455296

Yes, fixed

jasona.work SSC Guru Points: 50237 More actions · Answer 3

A possible clarification to add to the article, that the docker-compose file has two requirements that threw me for a bit:

It must be in the folder you're looking to use for your database files (ex: c:\sqldata\sql####\) not another location
It must be named "docker-compose.yml"

Initially I thought there was a problem in the directions.

(Also, my apologies for mugging you at Summit during the vendor reception about this)

Lowell SSC Guru Points: 323753 More actions · Answer 4

there's an option to call the compose for a specific filename with the -f parameter: otherwise it assumes the current folder and specific filename

docker compose -f "G:\My Drive\_Data\Docker\DockerCompose\SQL2022.yaml" up -d

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 740071 More actions · Answer 5

I didn't call those out, but I'll edit the post to note the file needs to be in the same folder. I wrote later about using a specific file name.

And good to see you at PASS. Sorry we didn't chat more. It was slightly crazy for me.