Deploying from a Script Folder to a Database
MichaelBerkowitz
Posts: 2 New member
Hello.
I use Redgate to link my database schema to Git, via a Script Folder. Both the SQL Source Control tab in MSSMS and SQL Compare 15 (which I assume are based on the same underlying code) correctly identify the differences between the database schema and the DDL in the Script Folder files. When I "Commit" my schema changes, the files are correctly updated. However, when I made a change to the DDL in a file, the tools again correctly identified the difference but failed to generate a script to deploy the change in the file to the database. Instead, there were a lot of calls to sp_refreshview and a call to sys.xp_logevent.
I'm hoping someone can explain how I'm misusing these tools.
Thanks in advance.
I use Redgate to link my database schema to Git, via a Script Folder. Both the SQL Source Control tab in MSSMS and SQL Compare 15 (which I assume are based on the same underlying code) correctly identify the differences between the database schema and the DDL in the Script Folder files. When I "Commit" my schema changes, the files are correctly updated. However, when I made a change to the DDL in a file, the tools again correctly identified the difference but failed to generate a script to deploy the change in the file to the database. Instead, there were a lot of calls to sp_refreshview and a call to sys.xp_logevent.
I'm hoping someone can explain how I'm misusing these tools.
Thanks in advance.
Tagged:
Answers
Product Manager
Redgate Software
Thanks again.