How can we help you today? How can we help you today?

Deploying from a Script Folder to a Database

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.
Michael Berkowitz
0

Comments

2 comments

Sort by
  • David Atkinson
    Hi - thanks for reaching out. Are you comparing a scripts folder to a database in SQL Compare? What is the nature of the change that you've made. Screenshots may help here!
    David Atkinson
    0
  • MichaelBerkowitz
    Thanks, David, for the quick response.  In the process of collecting supporting information I think I've solved my problem.  It seems that the table I was editing is system-versioned and I did the edit in the history table but not in the primary table.  When I make the edit in both, the deployment script generated seems to be correct.

    Thanks again.
    MichaelBerkowitz
    0

Add comment

Please sign in to leave a comment.