Get Latest - script

[andreas_agren]

Hello

When getting the latest changes from e.g. svn into a database there is a script created behind the curtains that does the changes, I have two questions regarding this.

1. Is it possible to get to review and edit this script before it is run when clicking "Get Latest"?

2. Data loss - I had a change in svn that dropped a column and a table (that contained data), "Get Latest" happily did these changes without any warning. This seems very dangerous since people makes mistakes. Can I somehow tune which changes are acceptable when clicking "Get Latest"?

[David Atkinson]

Thanks for the feedback. What we hope to do in an upcoming release is to pop up a warning when any data loss could occur as a result of a 'get latest', so you can validate that this is indeed what you expect before going ahead with it.

David Atkinson
Product Manager
Red Gate Software

[andreas_agren]

Thanks for the information.

What about my first question, is it possible to review and edit the script before it is run by "Get Latest"?

[David Atkinson]

There's no way of doing that right now. If the script fails to run successfully, for whatever reason, the script can be viewed.

David

[andreas_agren]

I've added a feature request for the data loss-warning:
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1865615-warn-when-get-latest-cause-data-loss

Please vote!