Options
SQL Prompt Core doesn't work in Visual Studio 2017
Jovanny
Posts: 3 New member
Hello everyone
SQL Prompt Core doesn't work in my Visual Studio 2017.
When I type any SQL statements I haven't got any hints.
How can I fix this issue?
Microsoft Visual Studio Enterprise 2017
Version 15.4.2
Redgate SQL Prompt 8.2.5.2924
SQL Prompt Core doesn't work in my Visual Studio 2017.
When I type any SQL statements I haven't got any hints.
How can I fix this issue?
Microsoft Visual Studio Enterprise 2017
Version 15.4.2
Redgate SQL Prompt 8.2.5.2924
Tagged:
Best Answer
-
Options
Jessica R
Posts: 1,319 Rose Gold 4
Hi @Jovanny,
SQL Prompt Core will not load suggestions for SSDT projects I'm afraid, for the reasons Michael described above. You would need to use SQL Prompt Pro.
Please note though that SQL Prompt Pro does not have full support for SSDT projects either. We encourage both Pro and Core users to still vote on SSDT support on our uservoice forum: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5985591-load-suggestions-from-sql-files-in-visual-studio-s
Answers
I think this issue may be related to this thread.
https://forum.red-gate.com/discussion/82047/sql-prompt-core-suggestions-for-ssdt-projects#latest
What version of SQL Prompt are you using? Is it SQL Prompt Core or SQL Prompt Pro?
You can find the version in the menu SQL Prompt -> Help -> About SQL Prompt
We changed behaviour in the latest release so that we do not override SSDT autocomplete if you have a SSDT Database Project in your solution.
Best wishes,
Michael
Technical Lead, SQL Monitor
The SQL Prompt version is 8.2.5.2924 Core.
It doesn't work, ifa type of an opened project is SQL Server Database Project.
In this case only the inner intellisense works, even for scripts connected to an SQL Server database.
If an opened project type is another, SQL Prompt works well.
Best regards.
We disable SQL Prompt for SSDT because we do not yet support offline suggestions from SQL files in Visual Studio/SSDT Projects which was causing users to lose capabilities provided by the Native Intellisense. There's not currently a workaround except using SQL Prompt Pro, but we would like to understand a bit more about how you are trying to use SQL Prompt Core.
Would it be possible to ask a little about how you are using SQL Prompt with the SSDT project? Are you using a connected query window while in a database project for instance? What do you prefer about SQL Prompt's autocomplete?
Best,
Michael
Technical Lead, SQL Monitor
I just tried to use SQL Prompt Core in my SSDT Projects connecting an opened scripts to a target database. It was unsuccessful to make SQL Prompt works in such way.
Best regards.