July 10, 2024 at 8:43 am
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
July 10, 2024 at 9:08 am
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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
July 10, 2024 at 9:19 am
ok great thanks
July 10, 2024 at 12:58 pm
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
July 10, 2024 at 1:37 pm
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