Activity overview
Latest activity by james.strath
As an example on a tangent, when i'm creating a script for a database install i will compare my source database to the empty model database and compare auto-selects in general all of the items. But as i go thru each of my source databases i will move to one where it neglects to select all of the items. When i reorder the list to bring the unselected items to the top to view them i'm left wondering what's so [un]special about these that they have not been auto-selected? [image] and on this database it seems to know that i will want to exclude these 2 synonyms whereas on the above example i don't want to exclude that list it has decided not to select [image] / comments
As an example on a tangent, when i'm creating a script for a database install i will compare my source database to the empty model database and compare auto-selects in general all of the items. But...
What is the auto check logic and how do i turn it off?
Something for years which has annoyed me and i've just grinned and beared it thinking it must be some behaviour toggle i haven't found yet so today i finally ask the question.Why does SQL Compare d...
Sorry Christian , no i don't recall when this behaviour started occurring. / comments
Sorry Christian , no i don't recall when this behaviour started occurring.
Anyone advise on resolving "Failed to locate" object error
i can see the object in my SSMS object browser and in the working folder source control is pointing at so I am not expected this error. (if it cannot locate it should it not just be listed in the d...
Looking at views at the moment and it appears that when you right-click and script out an existing view (CREATE, ALTER, DROP AND CREATE, CREATE OR ALTER) where the object has been created with the object type (VIEW) on a new line then the scripting inserts extra white space that's not needed and therefore adjusts the exact script of what it was before: [image] The whitespace inserted is inconsistent between the script methods: [image] [image] Any reason why they can't all just have no or one whitespace in each - or is this an SSMS issue rather than redgate scripting? / comments
Looking at views at the moment and it appears that when you right-click and script out an existing view (CREATE, ALTER, DROP AND CREATE, CREATE OR ALTER) where the object has been created with the ...
I should have mentioned i'd already tried that option but turning that option off means you get countless differences that i do want to ignore and renders that option pointless. regards, James / comments
I should have mentioned i'd already tried that option but turning that option off means you get countless differences that i do want to ignore and renders that option pointless.regards,James
Though i just had it happen on a normal ALTER so I have noticed this One whitespace after my ALTER keyword (renders as CREATE in redgate comparison) things are ok in the generated script [image] No whitespace after the opening keyword things are ok in the generated script [image] But two whitespaces after the opening keyword then the generated script outputs on one line [image] Three whitespaces after the opening keyword then the generated script outputs on one line [image] Tab after the opening keyword and things are ok [image] Even though i've now determined the workaround it will be a bit tedious to police myself and others in code-review to prevent it corrupting the environments. the reason I make this change is that i have litany of code that has ended up similar to this; [image] where there are varying big gaps between the keywords - i don't know exactly where these have come from (SSMS modifications or redgate compare deployments) but in order to stop them from creeping in - i try and enforce a consistent syntax - which the redgate whitespace bug is therefore undermining. Hope above helps resolve. James / comments
Though i just had it happen on a normal ALTER so I have noticed thisOne whitespace after my ALTER keyword (renders as CREATE in redgate comparison) things are ok in the generated scriptNo whitespac...
Hi Christian, In your own test, did you take my proc script as is? Because i think the issue is when the script has CREATE OR ALTER PROC in it, whereas if the script is a CREATE PROC or an ALTER PROC it works Regards, James / comments
Hi Christian, In your own test, did you take my proc script as is? Because i think the issue is when the script has CREATE OR ALTER PROC in it, whereas if the script is a CREATE PROC or an ALTER PR...
the software is saying there aren't any updates to apply as i'm on latest version. [image] RedGate.SQLCompare.UI.exe C:\Program Files (x86)\Red Gate\SQL Compare 15 15.4.13.28096+ebd604dab73334a415f1205f61fa1334ccdf8910 4.0.30319.0 False my current depoloyment showing below where in the screen behind it shows the comparison with PROC keyword on second line but the script window then shows the PROC on first line [image] if i scroll down the script all other procedures have PROC keyword as first word of second line - but this first entry shows it differently for some reason / comments
the software is saying there aren't any updates to apply as i'm on latest version.RedGate.SQLCompare.UI.exeC:\Program Files (x86)\Red Gate\SQL Compare 1515.4.13.28096+ebd604dab73334a415f1205f61fa13...