visual-studiodatabase-projectrider

Publish database function of visual studio in Rider


I recently moved from visual studio to Rider and I love it. However I've noticed that Rider does not have a function to publish your database project to a server. Does Rider have this option or anything like it? If not what would be the best alternative? I'd rather not have both IDEs open at the same time just for 1 function.


Solution

  • Database projects (*.sqlproj) in Visual Studio allow you to publish a database, which is useful.

    Rider doesn't support this type of project at the moment:

    enter image description here

    However, there are some alternatives. For example, Rider has supported EF code-first since 2018, so that would be one way of managing your database. EF lets your code generate and update a database, via migrations. Or even via SQL scripts which it generates.

    Another example, would be to generate and publish scripts via SQL Management Studio. The scripts could be added to your project/source-control as SQL files.