sqlsql-server-data-tools
Access SSDT without a database project
Is it possible to access the SQL Server Data Tools menu and features without having a database project? I want to compare two databases without creating or opening a database project.
Solution
The SQL Server menu has been moved under them main Tools menu in recent Visual Studio updates. You can use this to start a Schema Compare or Data Compare without opening a project:
Alternatively go to View -> SQL Server Object Explorer, connect to your server from there, and right-clicking on any database will give you the same options:
- Why 5.0 / 2 returns 2.5000000000000000 (scale of 16) instead of 2.5 (scale of 1)?
- SQL - How to SUM and use WHERE clause on this SUM using 4 tables?
- The best way of storing many to many hierarchical data in sql
- How to group and number SQL results?
- How to prevent PostgreSQL from altering my nicely formatted SQL definitions
- How to perform division in SQL Server?
- Table Primary Key and Foreign Key Relationship Design for Invoices with Summary and Detailed Sections
- How to put the select result (column) in an array in PL/SQL
- SQL Query to use a Case Statement within and Aggregate Function
- How to get date difference from a column?
- Prioritization of data in SQL
- Operand type clash: date is incompatible with smallint error in sql server
- Are GUIDs timely ordered ? If ORDER BY used with a GUID variable type, will records created lately come late?
- Find SQL Server Job Related to Existing SSIS Package in Visual Studio
- Normalize Google Sheet table (1st step)
- How to get column between two values as per user input
- Problems selecting multiple column
- SQL convert nvarchar to float
- MySQL Workbench edit data
- Combine overlapping date ranges
- How to use values from CTE in ON CONFLICT UPDATE
- Expand the date range between two dates
- pyspark statistical window function keeps calculating NULL values
- sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'
- Sum a record with its previous not-null ordered by timestamp
- Prevent redundant results in SQL query
- SQL Query in Snowflake - Calculate Days of Supply
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- How to extract column names from SQL query using Python
- Select on self-referencing table where all chains meet a condition