Visual Studio 2015 Tools SQL Server Schema Comparison does NOT work with SQL Server 2017
I have wasted a whole day trying to get VS 2015 Schema Comparison to work with SQL Server 2017 Express. As per the screenshot, upon selecting a connection, choosing server / database - it connects OK, but upon returning to the 'Select Source Schema' window, the OK button is always disabled; therefore I cannot complete the step to specify the 'Select Source' or 'Select Target' databases to compare:
This only happens for databases on SQL Server 2017; For databases on SQL Server 2016, the OK button is enabled and I can choose a Source and Target to compare.
Download latest version of SSDT for VS 2015; version is v17.4 (in Sep 2018).
NB: The microsoft downloads 'market' is a mess... i found a few links from msdn, technet, etc. make sure you obtain the version above.
- Audit table update trigger does not work using a stored procedure
- Entity Framework | Sequence contains more than one matching element
- How can I alter column name in Sql server
- How to partition into batch of records with max batch size limit
- LOAD DATA INFILE error in MySQL
- Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
- Perform a row count of each table in my list of tables
- Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
- Split a string with no delimiters into columns
- Each GROUP BY expression must contain at least one column that is not an outer reference
- Add custom columns to pivot table
- Parameterized raw sql query much slower than query with actual values
- SQL Server database backup restore on lower version
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Summation of a column using certain conditions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to Renumber Set/Subset of Table Based on Numbering of A Second Table
- Using Azure Devops deploy release to multiple repos
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?