How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?

1 Answer 1


Azure Data Studio is like SQL Server Management Studio: these are client programs that access SQL Server, but ADS and SSMS don't touch the MDF files directly.

What you need is SQL Server to open the MDF. Try downloading SQL Server Developer Edition - it's free. Once it's installed, follow the instructions on how to attach a database. Attaching a database is kinda like opening a .doc file in Word - you need Word installed first.

  • Is SQL Server Developer Edition available for Mac?
    – Jacob
    Oct 31, 2018 at 23:45
  • Sure, on the Mac, you can use a Docker container.
    – Brent Ozar
    Nov 1, 2018 at 1:47
  • I uploaded Microsoft Access files into Azure Data Studio, and it worked great. Thanks!
    – Jacob
    Aug 28, 2019 at 22:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.