Post reply

Vagrant and SQL Server 2017 on Linux

  • November 14, 2017 at 12:00 am

    #104323

    Comments posted to this topic are about the item Vagrant and SQL Server 2017 on Linux

    LinkedIn Profile

  • November 14, 2017 at 12:57 am

    #1967898

    Great stuff.

    We’ve done something similar on the DbFit project, but using Chef to pull the installer package from the MS package repo, and install it. On the Vageant VM.

    It’s here if you’re interested:

    https://github.com/dbfit/dbfit/pull/577

  • November 14, 2017 at 1:30 am

    #1967901

    That's great.  I'll have a look to see if I can get DbFit working with Vertica

    LinkedIn Profile

  • November 14, 2017 at 2:33 am

    #1967913

    Awesome. We’re always open to contributions!

  • November 14, 2017 at 9:37 am

    #1968025

    Awesome article (as usual 🙂 ), Dave. Thanks for sharing the info. Two questions:

    • In the network config section, you first show a commented-out line of:
      # config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"
      and the next line shows the "configured" value being:
      host_ip: "127,0,0,1"
      Are the commas instead of periods in the IP address a typo?

    • For getting VirtualBox images, do you have to get them from the Vagrant site, or will Vagrant work with images taken from sites such as OSBoxes: http://www.osboxes.org/ubuntu/ ??

    P.S. I am also a huge fan / supporter of DbFit. I even wrote an article about it years ago, here on SQL Server Central (probably obsolete now):  Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

    SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
    Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
    Info sites — Collations     •     Module Signing     •     SQLCLR

  • November 14, 2017 at 12:24 pm

    #1968071

    Hi Solomon, I've no idea where the commas came from so it's a typo.  
    When you get a Virtual Box image it puts the template for the image in your Windows profile somewhere.  If the box exists on the Hashicorp site it will detect if the template version differs from the one on the site and recommend that you run Vagrant box update.
    If you get your box instance from another site you can tell Vagrant to package it up as a template so you can run Vagrant up.
    I have had virtual boxes from many sources, not just the one mentioned in the article.  I've not always been successful when trying to package them up as Vagrant boxes though.  It's theoretically possible, I just don't know enough to do it reliably every time

    LinkedIn Profile

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

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