How to download and restore adventureworks database on MacOS using docker and azure data studio

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 37

  • @codewithkemi
    @codewithkemi  2 роки тому +1

    Please , let me know if there's anything you would want me to make a video on

  • @dorthysavage6660
    @dorthysavage6660 Рік тому +1

    i dont know who you are but i love you, it worked !!!!

  • @icontola1464
    @icontola1464 24 дні тому

    Thank you. This was really helpful

  • @starwaveprime7398
    @starwaveprime7398 2 роки тому +1

    Exactly what I was looking for! Thank you!!

  • @IbteeDApunisher
    @IbteeDApunisher 2 роки тому +1

    Thanks a lot! Your video was very helpful in solving my issue.

  • @elgunhaqverdiyev1577
    @elgunhaqverdiyev1577 Рік тому

    Great Explanation . It worked for me

  • @vanessacheng4543
    @vanessacheng4543 Рік тому

    This is soooooo efficient and brilliant! Thanks for sharing!

  • @a.s3983
    @a.s3983 3 місяці тому

    Thank you so much this was so helpful appreciate your efforts sincerely.

  • @sangameshbhairi6453
    @sangameshbhairi6453 3 місяці тому

    Thank you so much :)

  • @evanadguzel3155
    @evanadguzel3155 Рік тому

    Perfect sharing, thank you!!

  • @cynthiaechefu3361
    @cynthiaechefu3361 Рік тому

    You just saved me😊..thank you ❤

  • @Python24-7available
    @Python24-7available Рік тому +1

    Hi Thanks for such a wonderful explanation. I just have a doubt. Can you explain or anyone here explain why restore failing for adventureworkDW2022.bak file? Thanks in advance.

    • @bibinkunjumon
      @bibinkunjumon Рік тому

      yes..i think in docker the sql we download is not latest.Image may yet to arrive.Thats why in mac it happens

  • @twinsmusic45
    @twinsmusic45 Місяць тому +1

    Why in my Azure Data Studio, it doesn't have a restore button?

    • @codewithkemi
      @codewithkemi  Місяць тому

      Can you make a screenshot?

    • @twinsmusic45
      @twinsmusic45 Місяць тому

      @@codewithkemi Yeah, but to describe it briefly, the button beside the [New Notebook Button] it's just refresh

    • @encinoman740
      @encinoman740 Місяць тому +1

      @@twinsmusic45 Were you able to work around this issue? Or figure it out? I came across the same scenario also.

    • @twinsmusic45
      @twinsmusic45 Місяць тому

      @@encinoman740 I have also seen someone solve this issue by changing to work on windows., but I changed to use MySQL instead of MsSQL.

    • @encinoman740
      @encinoman740 19 днів тому

      @twinsmusic45- Nevermind I figured it out dude.

  • @wisdomhighlights
    @wisdomhighlights Рік тому

    Perfect! *Thank you.*

  • @marizeekmabifa3935
    @marizeekmabifa3935 11 місяців тому

    Thank you so much!

  • @bibinkunjumon
    @bibinkunjumon Рік тому

    thanks..good

  • @jorgeespinola3565
    @jorgeespinola3565 Рік тому

    brillante, gracias

  • @danielnduka
    @danielnduka Рік тому

    THANKS

  • @samlee6740
    @samlee6740 Рік тому

    I don't have 'backup' folder under mssql any help?

    • @samlee6740
      @samlee6740 Рік тому +1

      nevermind i watched another video on how to create files, damn

    • @codewithkemi
      @codewithkemi  Рік тому

      @@samlee6740 You could just use another path if you can not find the backup folder. Just ensure you copy the correct path

    • @samlee6740
      @samlee6740 Рік тому +1

      @@codewithkemi initially i tried putting into data folder but it didn't work. So I ended up creating backup folder by using terminal

    • @Python24-7available
      @Python24-7available Рік тому

      @@samlee6740 Hi Can you explain how you created backup folder using terminal? Any help will be appreciated. Thanks!!!

  • @Elyor_Nabijonov
    @Elyor_Nabijonov 26 днів тому

    not working i don't know why isn't working ? 😔😔😔

    • @wannaknowwhenitsover
      @wannaknowwhenitsover 13 днів тому

      i do all the stuff but the restore button at the end is not getting activated. right?????

  • @BeautiFuFu
    @BeautiFuFu Рік тому

    I've tried this step 3 different ways with 3 different tutorials, and I still cant get it. Everytime I run it I get "restored database failed: Microsoft data.sqlclient.sqlerror:the database was backedup on a server running database version 957. That version is incompatible with this server, which supports version 931. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server."

    • @BeautiFuFu
      @BeautiFuFu Рік тому

      never mind! I figured it out, its because I was using adventure works 2022

    • @bibinkunjumon
      @bibinkunjumon Рік тому

      @@BeautiFuFu You should have figured out soon.. docker image may be yet to update ..so as of now 2019 only possible for us