Database Project or SSMS

  • Hi

    Do you write your code in a database project in visual studio or directly on SSMS?

    Just weighing up the benefits of starting to use the database projects exclusively.

    Thanks in advance

  • I build and maintain databases using VS projects, but have configured VS to open .SQL files in SSMS – so a combination of the two.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • ok great thanks

     

  • Database projects are more than a little difficult to work with in source control, and I do source control my databases. So, external tools are generally better. For free, when talking SQL Server only, Visual Studio offers a solution that works well. Otherwise, third party solutions are wildly superior. Open source, look to Flyway. Otherwise, look at vendors. I work for Redgate who makes tools for this (full disclosure).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Excellent mate, thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply