SSDT schema compare, removing and then renaming stored procedure result is incorrect
0
votes
1
answer
551
views
The initial setup contains two scripts:
-
stored_procedure.sql
- stored_procedureV2.sql
What I did is:
- Remove stored_procedure.sql
- Rename stored_procedureV2.sql to stored_procedure.sql
When I perform a schema compare in SSDT between a .dacpac not containing this change and my project the action it proposes is to just remove stored_procedure.sql and do nothing else, whilst it should remove stored_procedureV2.sql and update stored_procedure.sql to its new content.
As I assume this is where schema compare gets its information:
The .sqlproj of the source:
...
On
On
On
On
...
The .sqlproj of the target:
...
On
On
...
Is this a known issue? Do I need to perform this in two steps? Is there a way to make SSDT behave the way I want?
Asked by Steve Van Opstal
(101 rep)
Apr 1, 2015, 03:13 PM
Last activity: May 13, 2016, 02:43 AM
Last activity: May 13, 2016, 02:43 AM