Visual Studio schema compare can't find generated script

sql-server visual-studio schema sql-server-data-tools schema-compare
Steve Coleman picture Steve Coleman · Jun 22, 2018 · Viewed 7.5k times · Source

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?

enter image description here

Answer

j.r picture j.r · Oct 18, 2018

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").

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How to get the connection String from a database

I have created a database with SQL Server Management Studio, I would like to now use it in my C# application. I need the connection string? Where can I find the connection string, and where is my database stored? Do …

Read More
SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More