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

Doesn't drop items when deploying to Scripts folder

When we deploy changes from a database to a Scripts folder containing a Visual Studio solution with sub-projects, any objects to be dropped aren't handled correctly.

Instead of deleting the .sql file for the dropped object and removing the reference from the .sqlproj, the contents of the .sql file are removed leaving a zero-size file. The object still appears in Visual Studio.

We have to delete the file and reference ourselves.

ccfs
0

Comments

2 comments

Sort by
  • sam.blackburn
    We've done some work in this area recently.  We believe this should be fixed in SQL Compare 14.1.5, which you can get by enabling frequent updates from the Help menu.  Does this solve your problem?
    sam.blackburn
    0
  • ccfs
    Good morning Sam,
    I've tested this and can confirm that SQL RedGate Compare 14.1.5 does now delete the dropped object files rather than leaving them as zero-length.
    Thanks,
    Peter
    ccfs
    0

Add comment

Please sign in to leave a comment.