1

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

2

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.

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

Your Answer

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

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