What are JFM, MDL files in Visual Studio Database Project?

Deepak Vasudevan 96 Reputation points
2021-04-02T07:19:39.387+00:00

I am trying to create a Visual Studio Database project to ensure my databases are scripted and version controlled. Post creating the project file I see the following files being created in the folder

.sln (Solution File) (Need to checkin, IMHO)
.sqlproj (.SQL Project File) (Need to checkin, IMHO)
.sqlproj.user (My guess is that it can be added to .gitignore)

.jfm (Could not understand the significance of this file)
.mdl (Could not understand the significance of this file)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
Accepted answer
  1. Vaibhav Chaudhari 38,601 Reputation points
    2021-04-02T07:36:29.507+00:00

    JFM, MDL should be temporary files. I usually stage only required files like .sln, .sqlproject and checking the staged changes

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest