Visual Studio schema compare can't find generated script
I am performing SQL Server schema comparison using Visual Studio 2017. I am pressing on "Generate script" button of Schema Compare utility and see the message
"Update scripts generated successfully"
However, I am unable to see the generated script. Any idea where this went or if it failed?
Solution
According to this page "The generated script appears in a new Transact-SQL Editor window".
When this didn't work for me, i closed all open windows other than the schema compare window and re-checkmarked all differences in the list (i had un-checked some). After doing this and running "Generate Script" again, Visual Studio did actually open a new window with the script (The filename was "C:\Users\me\AppData\Local\Temp\MyDbName_Update1.publish.sql").
- SSRS 2014 date range parameters not working with an OR clause
- Calculate duration using T-SQL
- Conversion failed when converting the nvarchar value to data type int while inserting records into table
- How can I run just the statement my cursor is on in SQL Server Management Studio?
- SQL rollup to add a total row for multiple columns
- Select SQL Server database size
- INSERT INTO a temp table, and have an IDENTITY field created, without first declaring the temp table?
- Create single image for database diagram in SQL Server
- Automatically define the DataTable in C# from the schema of SQL server tables?
- TSQL: how to write this query?
- CREATE TABLE permission denied in database 'tempdb'
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Does database compound index order matter if the first column is only queried with an equal operation?
- Difference between .NET, OLEDB, and Native Providers in SSIS
- Is there a way to populate a HTML table from a database? (SQL Server, VB.NET, ASP.NET)
- ExecuteScalar() not returning full contents of cell
- Why does normal execution resume after Raiserror in Catch block
- PRINT output doesn't appear immediately in the Messages pane in SSMS
- Comma delimiter is not being respected
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- Select all unique values in SQL table with additional information
- How to avoid the "divide by zero" error in SQL?
- How do I get list of all tables in a database using TSQL?
- Basic SQL commands in Terraform
- Could there be a deadlock when using optimistic locking?
- Get list of tables but not include system tables (SQL Server 2K)?
- How to change keyboard shortcut - F5 to Ctrl + Enter to execute SQL command in SQL Server Management Studio
- Self join to compare rows of table?
- Transform DateTime field to provided format in where clause
- SSMS crashes instantly