After you've deployed the changes to your database you can refresh Prompt's suggestions with Ctrl+Shift+D (or "Refresh Suggestions" from the SQL Prompt menu).
Alternatively you can use the experimental auto-refresh feature which can be turned on through SQL Prompt->Options->Experimental Features to automatically detect the changes in your database.
Thanks for the reply. I'm very surprised that SQL Prompt can't use the project as the connection. Guess I'll put in my two cents in the User Voice forum.
It's something that we really want to implement but we've got a few other features that are seen as a higher priority so it's hard to justify it over them at the moment. Once we've got some of those implemented we can turn our attention to improving this.
Comments
After you've deployed the changes to your database you can refresh Prompt's suggestions with Ctrl+Shift+D (or "Refresh Suggestions" from the SQL Prompt menu).
Alternatively you can use the experimental auto-refresh feature which can be turned on through SQL Prompt->Options->Experimental Features to automatically detect the changes in your database.
Thanks,
Aaron.
For anyone who would like this feature, please vote here:
http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/5985591-load-suggestions-from-sql-files-in-visual-studio-s
Thanks!
It's something that we really want to implement but we've got a few other features that are seen as a higher priority so it's hard to justify it over them at the moment. Once we've got some of those implemented we can turn our attention to improving this.
Thanks,
Aaron.