SQLTeam.com | Weblogs | Forums

How to copy an MDF file


#1

I have a question , if I detach the sql db as .mdf file and I sent it to another pc which program I must install it to open the file


#2

ssms is one tool you could use

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017


#3

While technically correct, I think the response should be

Why are you detaching and attaching MDF files?
BACKUP and RESTORE is very, very probably what you ought to be doing (using SSMS or Azure Data Studio or whatever)


#4

Replying to myself after reading Very important question

You might want to look into deploying a "dacpac" as well (https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/deploy-a-data-tier-application?view=sql-server-2017)