248 results found
-
Add default collation to match source database when you create a new target database in SQL Compare
When I schema compare in order to copy a database, I often want to create a new database as target. Could it be possible to default the collation of the new database to the one of the already selected source? Or at least make it possible to see the collation of the source database right there in the tool? There are hundreds of collations to choose from, and mostly I get it wrong and then I have to await the compare process and go back and delete the new database and do it all over. Seems like an easy fix.…
3 votes -
Read from SQL Native Compressed Backups
Similar to the idea from Steve Hall for SQL Data Compare, SQL Compare should also get the ability to read backups compress by SQL Server.
There is a feature for compressed backups, but unfortunately "this compression is not supported" if you try to read from a BAK with the standard compression of MSSQL.
That would be very important to make partial restores and to have an efficient way to deal with the day-to-day tasks, because bih DBs cannot be handled without compression.3 votes -
Add support for SQL Server Management Studio 20.
If I open up Tools --> Application Options in SQL Compare, I see SQL Server Management Studio 19, but not 20 which has been out for months now. And I believe it is the same in SQL Data Compare as well.
1 vote -
Highlight newer last modified date.
Highlight newer last modified date.
In SQL Compare, highlight somehow the Last Modified date that is newer/more recent especially in the "in both, but different" category of SQL object comparisons.
Thinking it would help pick the appropriate object that was worked on most recently.
3 votes -
Allow me to exclude users in DB compares.
I use something like domain\UserDEV for development and domain\UserPRD for production.
I can ignore a users permissions but I don't need a list of users that I know won't exist in different environments.
This confuses business users when I try to show/demonstrate the exported report.
1 vote -
SQL Data Compare\SQL Compare between SQL database tables and Azure Synapse Serverless database external tables
It would be great if SQL Data Compare/SQL Compare work with External Tables in Azure Synapse Serverless database.
1 vote -
Compare two schemas in the same database as if they were different databases
Sometimes databases are set up such that each schema is supposed to have the same objects, defined in the same way, as all the others. Ex: SchemaA.Table1, SchemaA.Table2, SchemaB.Table1, SchemaB.Table2, SchemaC.... This is used as an alternative to multiple databases. Unfortunately, not all objects are always set up the same and thus the need to compare them.
SQL Compare will let you compare a database to itself, and you can use the "Owner mapping" tab to cross the schema names (e.g. map side 1 SchemaA to side 2 SchemaB), but the comparison has to go in both directions (also map…
3 votes -
Don't prompt to save project when it's not dirty
Every time a SQL Compare project is closed, a modal dialog pops up to save unsaved changes every time, even if the project was just saved. This dialog should not pop up if the project is not dirty.
9 votes -
Cannot edit the Scripts folder name
On Data Sources modal, make the Scripts folder dropdown box editable so the folder name can be edited/pasted without having to go into the open folder dialog box.
3 votes -
In SQL Compare, have "SQL Prompt view tab" with SQL Prompt Professional licence, not just the SQL Toolbelt licence
We want to use the SQL Prompt view tab in SQL Compare, but you apparently specifically need the SQL Toolbelt or SQL Toolbelt Essential licence.
We don't have SQL Toolbelt (anymore), but we have both Redgate Deploy and SQL Prompt Professional, and i believe we also have all the tools shipped with SQL Toolbelt.
Can't this tab also be made available for people using Redgate Deploy and/or SQL Prompt Professional, as we have all the tools/software of the Toolbelt already (i guess), but the bundle is named different...?
12 votes -
Option to deploy dependencies without referencing objects
Currently, the deployment wizard allows us to select referenced objects and referencing objects. It would be nice if these could be separated so there were two different options. My scenario is wanting to create a small testable DB and only bringing over the minimal amount of schema to get things working. Dependencies are clearly needed, but I don't need objects that rely on the objects deployed.
3 votes -
3 votes
Have you tried the options in SQL Compare?
-
Replace modal widows with tabs or something
Managing multiple projects is cumbersome with the modal windows that pop up. They also force a clunky workflow when copying credentials from a 3rd party manager to the popup windows.
3 votes -
Bring back the neat and handy ability to popup the differences window.
I used to review the changes on a separate windows on a vertically aligned monitor. This allowed me to fast review changes of most objects without using the scrollbar.
Now, for even a small table with constraints, FKs and permissions there is scrolling needed. I need constantly to resize either that upper panel to see objects or bottom one to see changes. SQL review tasks are taking much longer now.
The Summary view is a nice concept but far from production usability.
1 vote -
Allow migration of Indexes ONLY
I have multiple databases which have the same columns (mostly) but sometimes differing defaults.
They also have different indexes.
I'd like to choose to ONLY sync indexes across.
Obviously the system would need to be intelligent enough to sync only those that have the columns they use/include in both source and destination.
1 vote -
Always trust server certificate via option
Version 15 adds checkboxes for Encryption and to Trust a server certificate, but if you don't maintain proper certificates you now always need to check the Trust server certificate box on both servers for new comparisons. It would be great if there was an option to default the behavior of these checkboxes to fit your environment.
10 votes -
user defined type
I recently had to use SQL Compare to create a rather large add new and update deployment script.
I was pleased that it picked up User Defined Types in addition to the normal tables and stored procedures.
But it did not pick up the permissions for the User Defined Types, and that was a failure point when executing the stored procedures.
This was my first time working with User Defined Types before, and I thought it odd they needed permissions at all. I did not apply any in the development environment, and they worked there.
But the error was clearly…1 vote -
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 -
Constraint and Index Names
Currently, there is an option to ignore constraint and index names. Please separate out indexes from constraint names.
4 votes -
auto hide update available notification
When starting SQL compare, a blue panel appears on the top notifying me about a new version. This panel hides the names of the database servers I am working with and that is problematic. I think that once I start working/touching anything in the SQL compare UI the ribbon should auto-hide so I will see the database server names I am working on.
I know I could click install and be done with it but sometimes I am in the middle of something else which cannot wait and the notification is just in the way and I do not have…
3 votes
- Don't see your idea?