250 results found
-
Add window management to detached pop=out window
In SQL compare, if you open the pop-out widow to view differences in a separate window, the normal window controls like maximize and minimize are not available. you cannot double-click the title bar (or Alt+enter or F11 or anything) to maximize it.
Request adding missing window management to the differences window
2 votes -
Software updates not appearing when Help, Check for updates is used
Currently using version 14.1.7.14336. clicking on Help, Check for updates. I get you are running the latest version. But there has been 3 updates released since. The current update is 14.1.10.14805 released 01/27/20.
Trying to see why this happening. How long does it take for the software to see these updates.2 votes -
powershell cmdlets for SQL Compare
It would be nice to have clean powershell cmdlets (like SCA) for SQL Compare rather than having to use the old-school command line and arguments.
2 votes -
Ignore permissions doesn't
SQL Compare 14.2.4.15334
I have checked "Ignore permissions" and "Ignore users' permissions and role memberships", but deployment script is creating grants for existing permissions on tables being recreated (replacement table created & populated, old table dropped, & replacement table renamed). Expectation is that it obeys the ignore options.2 votes -
SQL Search Right Click Modify
If would be handy in SQL Search to be able to right click/Modify instead of double clicking, waiting for what could be a last treeview list in SSMS to open, then having to right click/modify.
2 votes -
Rebuild partition instead of dropping & recreating primary key when only changing data compression
SQL Compare currently attempts to drop and recreate a primary when changing compression.
REBUILD PARTITION ALL WITH (DATA COMPRESSION PAGE|ROW|NONE
would be more efficient and less intrusive since, among other things, it doesn't require dropping and recreating all foreign keys.2 votes -
Trigger Comparison/Ordering
I have TableOne in DatabaseA and DatabaseB. DatabaseA.TableOne has Trigger1,Trigger2 and Trigger3. DatabaseB.TableOne has Trigger2 and Trigger3. After all table columns are analyzed, DatabaseA.Trigger1 is compared to DatabaseB.Trigger2 and naturally they show as different. I'd like to see Trigger1 "compared" to blank, then both Trigger2s compared, ... Try to match up on trigger name and if there isn't a match, show blank
2 votes -
Unecessary table rebuild
The tool will try to rebuild the whole table even when the only thing needed is the addition of one column. If you need it, I can send an image of the comparison results. To work around it, I search for rebuilds within the generated script and substitute them by the needed command, specially if the table is a very large one.
1 vote -
SQL Compare Flagged store procedure difference but could not see where
SQL Compare Flagged a difference between Test and Production Store Procedure but I could not see where. I had to use notepad++ compare to see a Single Space. Please make this visible in the next release.
1 vote -
Flter save location does not exist causes exception
After you specify a file path and save your filter.
Delete the directory where the filter was saved
Click the "Save" button again and you get an exception. Need a "Save As" function or something to override the setting you set last time.1 vote -
Ignore indexes option should not query indexes
If indexes & partition schemas/functions are set to be ignored, SQL Compare should not attempt to query them. Additionally would be helpful for other object types that are ignored so that the queries are streamlined to only what is selected for compare. This would be a performance enhancement, the pain is where there is a high number of partitions where the intention is just to compare something simple like stored procedures and UDFs.
1 vote -
Add Summary View command line option
Currently there are 3 output options when running sql compare via the command line /quiet /verbose and the default. I'd like to see an option between the default and verbose logging similar to the "Summary view" present in the main application.
For example: I'd like to see the tablename that has diffs (default option) AND the name of the index on said table that is different (new summary option), but not the entire table definition (verbose option).1 vote -
Compare View with a table
just like in sql data compare, it would be nice to compare a view with a table.
1 vote -
Possible bug -- changed behavour of Swap left and right button on the data sources page
In the latest version (updated this morning), the swap button changes server names, etc. shown in the header part of the page (source and target), but leaves info filled in on the bottom half alone. Can be confusing as to which server/database/etc. will be the source/left side and which will be the target/right side.
1 vote -
find wildcard
plz, add filtering object names by wildcards(* ?) in find box.
thanks...1 vote -
Problem printing the interactive report
When I print an interactive html report to a color printer, some texts and images of the header come out printed, and the green, red and yellow colors of the types of differences are lost.
1 vote -
When deciding to synchronize some objects, at the first screen of the wizard must exist a check-box for not checking for dependencies
When deciding to synchronize some objects, at the first screen of the wizard must exist a check-box for not checking for dependencies, if checked (also I would like this to be the default behavior). This should allow the wizard not even to check for dependencies, which could be faster
1 vote -
compression
When applying data compression differences (table or index), use rebuild partition or rebuild index rather than drop & create, both to minimize impact, and in the case of primary keys on replicated tables, avoid failure because replicated tables can't be dropped.
e.g.,
ALTER TABLE schema.TableName REBUILD PARTITION = ALL WITH (DATACOMPRESSION = PAGE);
ALTER INDEX [IndexName] ON schema.TableName REBUILD PARTITION = ALL WITH (DATACOMPRESSION=PAGE);1 vote -
Option to Ignore "WITH EXECUTE AS CALLER"
The only difference in our comparison of the numerous tables is the "WITH EXECUTE AS CALLER". Add option that will allow to ignore this options
1 vote -
Include a description of the active filter settings used for the comparison in the report output
When generating a comparison to validate/review a deployment, you may use a fairly complex filter to identify the objects to deploy.
If you generate a report to send/configure to a third party, the filter settings you used to generate the comparison are not shown/output (looking at the Active HTML output specifically, but may be true across other formats).
The criteria used for the comparison are integral to the information being generated and should therefore be represented.
1 vote
- Don't see your idea?