250 results found
-
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 -
SSMS integration - compare single object
hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...
right-click an object in SSMS and click an option called something like 'compare against other environment'.
it would then bring up a message box where you could browse an object-explorer for the corresponding object.
the use cases I see all the time for this are
- when people have stored procs next to each other called
spSomeProc
spSomeProcv2
spSomeProcnew
spSomeProc.oldetc on the same database.
2 when you…
6 votes -
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 -
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 -
Option to ignore preserving data when adding a NOT NULL column to a table
SQL Compare tries to preserve data from table when adding a new NOT NULL column and adds below steps to deployment script:
1. Create a new table B with same structure from original table A
2. Perform INSERT INTO table B SELECT * FROM Table A
3. DROP Table A
4. Rename Table B to Table AThe issue:
For example if we add a new column to a ETL table with 1M rows. We don't need data to be preserved since table gets populated during ETL process. The deployment script without manually remove INSERT statement will take a very…5 votes -
Allow the scripting of individual sql objects
optionally have the ability script out all individual objects, rather having one monolithic deployment script, from the source that are unmatched or have diffs on the target. In my case I have a git repo that needs to brought up to date from a production server (a bit of a reverse of the usual workflow)
4 votes -
Remove schemabinding
I think its not removing the 'WITH' when doing remove schema binding for dependent objects
v 13.7.3.9483
1 vote -
Allow SQLCompare to compare and synchronize Broker Priority objects
Most of the first-class objects for Service Broker are comparable by SQLCompare (i.e. queues, services, message types, contracts, service bindings, etc). One omission is Broker Priorities. It would be nice to have those at least comparable by the tool with an obvious next step having the ability to synchronize from source to destination
4 votes -
SQL Compare - Highlight Date of newer item
It would be extremely helpful for the compare to highlight the one that is newer. When trying to decide if server 1 or server 2 wins, we need to know which ones were updated more recently on one or the other server.
Since the date fields are on extreme sides, it's difficult to compare dates.
Color for the newer one or putting the date columns in the center would be two ways to help with this. Color/bold would be ideal.
8 votes -
in sql compare, list of items changed should be readable from scp file
Sql compare produces an scp file which is an xml file. However, the contents of the change is compacted and encoded, and not readable in text editor.
I wish the list of objects to change can be directly readable from the xml. "Generate comparison results report" is bulky and cumbersome. It would be nice if we have some very short summary in the scp file itself.3 votes -
1 vote
-
Next/Previous Difference buttons to keep cursor in middle of text
Currently, when going through differences, the highlighted line can be at the bottom of the window, so subsequent lines cannot be seen. It would be better if the view scrolled around the cursor position so that the current difference was always in the middle of the window.
3 votes -
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
7 votes -
Ignore datatypes
I created a new database based on an existing but replaced all datetime columns by datetime2(2) and do not want to show this as difference neither want it be rolled back, when I create deployment scripts.
Same could happen, if I change the size of a varchar, decimal or integer datatypes (bigint <> int <> smallint ...) and even, if a number is in one database is stored in a varchar field, I could want to ignore this and deploy only everything else
See also
https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/7109654-an-ignore-option-for-differences-between-varchar
which suggests to ignore varchar vs. nvarcharBTW: I solved my problem by syncing…
9 votes -
Let SQL Compare adopt the Comparison Options of Source Control Source
Unfortunately SQL Compare does not adopt the Comparison Options specified by the Source (here git repository created by SQL Source Control) which are saved in "ComparisonOptions.xml" in the git repository. Instead in SQL Compare I have to click on "Edit project" -> "Options" and check again "Ignore users' permissions and role memberships". This feels somehow not intuitive. During setup of the SQL Compare project a checkbox "adopt comparison options from source" would be nice - or maybe an "adopt" button just after setup.
I saved the SQL Compare project as an .scp file which in fact is an XML file.…
9 votes -
Connections page
I cannot connect to my databases on startup. The credentials are the same as I use in other programs and scripts but no dice. Some more meaningful error messages as well as options to specify the port and not clearing down the user/password fields would also be useful.
4 votes -
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
4 votes -
Option to ignore rowguid column generated by Merge Replication
When SQL Server sets up merge replication it creates a rowguid column to maintain integrity between the tables of the publisher and subscriber. Typically this setup doesn't exist in non-prod environments which ends up generating false positives differences.
31 votes -
4 votes
-
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
- Don't see your idea?