How to change the connection in Sql Server Data Tools Editor in Visual Studio
My goal is to keep SQL Server stored procedures under source control. I also want to stop using SQL Server Management Studio and use only Visual Studio for SQL related development.
I've added a new SQL Server Database project to my solution. I have successfully imported my database schema into the new project, and all the SQL objects (tables, stored procedures) are there in their own files.
I know that now if I run (with F5) the .sql files then my changes will be applied to my (LocalDB). This if fine, but what if I want to very quickly run something on another machine (like a dedicated SQL Server shared by the entire team)? How can I change the connection string of the current .sql file in the Sql Server Data Tools editor?
I have the latest version of Sql Server Data Tools extension for Visual Studio 2012 (SQL Server Data Tools 11.1.31203.1). I don't know if this is related to the current version, but I cannot find anymore the Transact-SQL Editor Toolbar.
I have also tried to Right-click on the sql editor, choose Connection -> Disconnect. If I do the reverse (Connection -> Connect...) the editor directly connects automatically (probably to my LocalDB), without asking me a dialog to choose my connection.
Another strange thing I've observed, if I try to run a simple SQL query (like select * from dbo.ApplicationUser I receive the following message (even if the autocomplete works):
Thanks.
(Note: I have the same issue with Visual Studio 2013)
This should be a fairly simple and straight-forward thing to do, that is, if you are using SSDT version 12.0.41025.0 (or newer, one would suppose):
- Do either:
- Go to the
SQLmenu at the top of the Visual Studio window - Right-click inside of the SQL editor tab
- Go to the
- Go to
Connection -> - Select
Change Connection
Then it will display the "Connect to Server" modal dialog window.
If you do not see the options for "Disconnect All Queries" and "Change Connection...", then you need to upgrade your SSDT via either:
Visual Studio:
Go to the "TOOLS" menu and then "Extensions and Updates..."
Direct download:
- SQL want to calculate time hours and mints of each emp
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Hackerrank Winners chart SQL advance level question
- How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
- How do I retrieve SQLite engine introspection information via Rust SQLx?
- How can I add machines to data already been sharded in SQL database?
- Doing a WHERE IN on multiple columns in Postgresql
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- What is the most suitable data type for a column in a table?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How to select non-integers (varchars) that possibly have leading zeros?
- PHP mysql table for comments
- String interpolation inside a formattable string in C#
- SQL - How to insert unique id in XML tag
- What represents a double in sql server?
- sql select query name -value pair
- What difference does WITH GRANT OPTION make?
- Replace null with 0 in MySQL
- What does # mean in SQL?
- Renaming foreign-key columns in MySQL
- The named 'CommandType' does not exist in the current context
- Build SQL queries in Python
- Insert multiple rows in ORACLE by referring 2 tables
- How can I work with SQL NULL values and JSON in a good way?
- Incorrect syntax near ''
- Extract epoch from column of timestamps in Postgres
- SQL - insert rows preserving overall number of duplicate values
- Columns to rows in one scan and one query