Activity overview
Latest activity by jamieburns
I realise this is a few years old now, but I'm trying to do the same thing. Has there been any progress on this since this was originally raised? / comments
I realise this is a few years old now, but I'm trying to do the same thing. Has there been any progress on this since this was originally raised?
Thanks - voted! / comments
Thanks - voted!
Did this ever make it into the uservoice forum?
We need the exact same thing, so if it's not there, I might raise it myself. / comments
Did this ever make it into the uservoice forum?
We need the exact same thing, so if it's not there, I might raise it myself.
Hey Sam,
Now I come to think of it, I really can't think of why I don't have that checkbox checked. I vaguely remember a time when deploying dependencies caused a problem, but this is literally going back 5+ years ago. This was the first time when I actually needed to deploy a dependency in all that time.
99% of the time, I deploy all changes between two databases, and so the synchronisation just seems to work without having to include dependencies.
I guess I like to feel in control of what changes are going to be made. I use the first comparison page (where I can choose which items to include, and preview the changes) to make sure that these are indeed the changes I want to make. As soon as I click 'Deploy' I've already decided what I want to change, and nothing more. When I get given the option to include more changes (which is how dependencies feels), then I avoid it, because I don't want any unintentional changes - if I had wanted those changes, I would have picked them on the first comparison page. I think this feeling would be even stronger if I only choose to deploy a subset of changes - I wouldn't want something that I've excluded to be included again.
Now, if there had been an option to 'temporarily alter dependencies to allow the chosen changes to be deployed, but those dependencies will end up in their original state' (obviously needs a much better name than that!), then I would see that as a perfectly safe thing to leave checked, because I know only the changes I've selected will be deployed and even though other things will be affected during the deployment, I know the end result is exactly what I'm expecting.
Does that makes sense?
For now, though, I'll make a conscious decision to leave the 'dependencies' checkbox checked! / comments
Hey Sam,
Now I come to think of it, I really can't think of why I don't have that checkbox checked. I vaguely remember a time when deploying dependencies caused a problem, but this is literally go...
Right, this was definitely me being daft. [image]
Ticking 'Deploy all dependencies' fixes this issue. / comments
Right, this was definitely me being daft.
Ticking 'Deploy all dependencies' fixes this issue.
Cannot synchronise changes in User Defined Table Types when they are in use
So, in my SQL Server 2012 database, I've got a User Defined Table Type, which is used by a stored procedure. If I make a change to this type (e.g., change a column from varchar to nvarchar) and tr...