Comments
Sort by recent activity
I guess what confuses me is that if I have two tables fred and bob, the UI doesnt say: Fred --> Bob
It says Fred -->
Bob (red)
So say I add: create index AnotherAbsolutelyDifferent on fred(fredId)
To my RedGateCompare2 database.. This time the result is: DefinitelyDifferent -> AbsolutelyDifferent
Same -> AnotherAbsolutelyDifferent
X Same
Now, same actually does match, so this seems to be a real bug, but the results I would have desired would be: Same Same
DefinitelyDifferent ->
X AbsolutelyDifferent
X AnotherAbsolutelyDifferent
Technically, the net effect is exactly the same, but it is completely clear what is taking place.
Now, if I could check only the subordinate items I want to ignore individually, that would be super too [image] (Should I make another post on that?) / comments
I guess what confuses me is that if I have two tables fred and bob, the UI doesnt say:Fred --> Bob
It saysFred -->
Bob (red)
So say I add:create index...
That actually explains it quite well. I had always wondered why when things were clearly the exact same sometimes it suggested moving them.
Thanks,
Louis / comments
That actually explains it quite well. I had always wondered why when things were clearly the exact same sometimes it suggested moving them.
Thanks,
Louis
I see what you think I meant, but all I wanted was to have the totally different items on different lines so I could choose to add the new index and not drop the existing index. When they are on the same line with an arrow between them, it looks like the tool thought they were the same.
Just like if you have two tables with different names, you don't match them up, I would prefer that the two indexes be clearly denoted as distinct, different things so I could choose to keep both indexes. / comments
I see what you think I meant, but all I wanted was to have the totally different items on different lines so I could choose to add the new index and not drop the existing index. When they are on t...
On further review, it seems to be a bug with the option:
General, Commas, Multiple Line Statements
The two "Space after comma" settings. When they are not checked, there will be no space between the As and the first value. For example: select 'hi' as fred,
'bye' as barney
from test
is layed out as: select 'hi' as fred
, 'bye'as barney
from test
Apparenly it is removing the space from the wrong location. So the workaround is to turn on the Space after comma. Not a big deal, but it looks funny : select 'hi' as fred
, 'bye' as barney
from test
/ comments
On further review, it seems to be a bug with the option:
General, Commas, Multiple Line Statements
The two "Space after comma" settings. When they are not checked, there will be no space between t...
Installed on one of my machines easily, but had a dog of a time on the other. I searched for refactor, and deleted all of the files it found and it finally installed.
A couple of suggestions I have would be to:
A. Label something on the install process to make it clear what you are downloading (version number, CTP, Private Beta, etc). I am guessing that the thing we download fetches the new download, but it saw mine in cache and just kept installing it.
B. Have the new version purge the old version (of course this is beta, so I understand this one.)
Thanks. Like the product, I must say [image] / comments
Installed on one of my machines easily, but had a dog of a time on the other. I searched for refactor, and deleted all of the files it found and it finally installed.
A couple of suggestions I hav...
From Redgate About (which it would be nice if you included some form of copy/paste [image] :
Add-In Version 1.0.0.603
Rewriter Version: 5.7.0.430
SQL Compare Engine version 5.7.0.430
Ast Parser version 5.7.0.430
From SSMS Help, About:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600 / comments
From Redgate About (which it would be nice if you included some form of copy/paste :
Add-In Version 1.0.0.603
Rewriter Version: 5.7.0.430
SQL Compare Engine version 5.7.0.430
Ast Parser version 5.7...
It just depends on how much of the functionality you might use. I for one will use the SQL formatting all of the time, but none of the pure refactoring much at all, so for $295 (I thought you all were in UK, which is confusing since the price is in dollars American [image] that might be a bit steep. I really like the code formatting aspect though [image] / comments
It just depends on how much of the functionality you might use. I for one will use the SQL formatting all of the time, but none of the pure refactoring much at all, so for $295 (I thought you all ...
I can understand that [image] One more thing I didn't notice. It left the menus for the tool in SSMS. Clicking on the menus returns:
Microsoft SQL Server Management Studio
The Add-in supporting this command could not be loaded. Do you wish to remove the command?
If you choose yes, you can re-create the command by reinstalling the Add-in.
Yes No
Doing this removed the menu items, but the SQL Prompt menu item remains, disabled... / comments
I can understand that One more thing I didn't notice. It left the menus for the tool in SSMS. Clicking on the menus returns:
Microsoft SQL Server Management Studio
The Add-in supporting this c...
It is making me shut down Media Player 11 and remote desktop [image] / comments
It is making me shut down Media Player 11 and remote desktop
I totally agree about the usefulness. Web code, coworkers code that is rarely indented (I like private forums), etc. My favorite use so far has been to take some dynamic sql I had embedded in my code and straighten it out using refactor.
I like adding AS for sure, and certainly OUTER (I wouldn't quibble with INNER, mind you). Same pass I would like to apply dbo. to the table names (or whatever their actual schema is) and change the aliases to be the full name of the table (without dbo.))
I know it is personal preference, but the main reason for posting here tonight is to say: Great Job, I will probably use the refactor thing more than any of the other gadgets I am beta testing with you right now. It is super handy. / comments
I totally agree about the usefulness. Web code, coworkers code that is rarely indented (I like private forums), etc. My favorite use so far has been to take some dynamic sql I had embedded in my ...