261 results found
-
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 -
Fix the installer. Could not install SQL Tool belt trial as Redgate Client service could not be stopped.
I tried to install the SQL Tool belt trial numerous times but was blocked each time saying the Redgate Client service could not be stopped. I tried to stop it manually but that did not work. I called support but they just sent an email telling me to stop the service. What part of "I can't stop the service" did they not understand?
1 vote -
Report preferences should be stored in the project
It would be helpful if the definition for SQL Compare reports were stored in the individual projects and not as an application preference. I have 5 different databases and use the report on differences for all 5. I always have to switch the path for the reports. This change would solve that issue.
1 vote -
1 vote
-
Remove schemabinding
I think its not removing the 'WITH' when doing remove schema binding for dependent objects
v 13.7.3.9483
1 vote -
pin "object definition box"
Allow for pinning of the Object Definition Box so that it is always visible.
It would be nice if you could make the ODB (that's what I'm calling it from now on) could be pinned or made to float so that I could reference it as i type.
The object explorer does provide the same functionality... technically but its nice have the "source" immediately visible as opposed to the multiple folders in the Object Explorer.
1 vote -
CONSTRAINT of current_timestamp generates code that will not run in SQL
tsql source has line:
[CreateDate] datetime default CURRENTTIMESTAMP,
the script that is generated:
ALTER TABLE [dbo].[AirFlowData] ADD CONSTRAINT [DFAirFlowDaCreat82DA8F3] DEFAULT (currenttimestamp()) FOR [CreateDate]Error executing script:
Incorrect syntax near '('.1 vote -
monthly subscription
I would like to start using the Red Gate Toolbox but I cannot afford the cost nor will my company pay for it. Is there an option to be billed monthly?
1 vote -
Post script bit value column auto-update
Add an option that will run post-script to set newly added columns that are of a bit value type and that are scripted with a default value to that value after the addition of a bit column.
1 vote
- Don't see your idea?