Load suggestions from sql files in Visual Studio/SSDT Projects
Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".
It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.
Aaron Law
shared this idea
Thomas Walsh
responded
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.
If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.
Kind Regards,
The Prompt Team
-
Chris
commented
Red Gate, you are losing .Net developers using this product because of the lack of integration to the project!
-
Sergey
commented
Tried a trial version of SQL Prompt 7 with Visual Studio 2015 and looks like it is almost useless without proper SSDT integration - I have to re-deploy the project anytime I make changes to its schema in order to see those changes in IntelliSense.
-
Andre Light
commented
One other thing: I find myself turning off SQL Prompt regularly because it gets in the way of SSDT IntelliSense, which actually works on changes made to the local project without having to sync to the database first. If Redgate doesn't add more robust SSDT support, they're likely going to lose Visual Studio users.
-
Andre Light
commented
Now that I have SSDT, I rarely use SSMS because SSDT enables me to keep my entire solution, including the database, in one place. It also is a much more advanced development environment than SSMS (including the text editor), allows finding/updating code and DB references using a single Find/Replace, etc. Because of that, you can be sure that any developer using Visual Studio is soon going to migrate from using SSMS to using SSDT most of the time.