- or
3 results found
-
excel
Include attributes to be changed in an object to an excel report in sql compare. include not only the object name to be changed but the actual change to fields
within the object or the script change to be made for programability items users roles and permission. e.g. Database.schema.objectinsource.change(details of change column to be altered in a table its original value its new value its datatype and length its nullability and any default constraints.1 vote -
sqlsompare report
xml, html and excel reports for database differences (using options) include everything similarities as well as differences. Since, xml is excellent way to import data to SQL, it would be great if those reports included only differences (so that the file size is smaller). Right now the differences can only be output to text file if I am not mistaken.
13 votesWhen you generate a report, there is a check box just above the last line in the dialog ‘Also include identical objects’ – if you uncheck this, then only differences will be output in your report.
-
Add line comparison at the bottom of the object comparison pane
In the excellent file comparison tool Beyond Compare from Scooter Software, there is a full width line comparison view across the bottom of both comparison panes. This is extremely useful when comparing long lines of text and saves scrolling left and right all the time.
6 votesSQL Compare does have this functionality: If you click on the Show dropdown (just above the differences pane), and select Line Differences. Is this the behaviour you were looking for?
245 results found
-
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.
1 vote -
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 side 1 SchemaB to side 2 SchemaA) or it will fail. If you do remap the schemas, then you get essentially duplicate records of changed objects because you're doing the comparisons twice.
It would be nice if you could either exclude the second half of owner mapping without errors or be able to filter each side individually so that you can effectively compare a database to itself on different schemas.
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.
9 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 a failure to apply Grant Execute to the 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 time at that moment to update SQL compare
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 -
Add next to table object names the record count in the table
When comparing tables I saw that for two tables auto-map has mapped some columns. Since I know the tables are not compatible I had to check that the target does not have any rows in the table. Please add some indicator on the object list so that I can know easily if there are any rows in the table
1 vote -
beyond
Allow an object / script comparison to be opened in an external Diff viewer, such as Beyond Compare. Provide configuration settings to configure external diff viewer EXE, similar to what source comparison tools do.
1 vote -
Inconsistent IgnoreWhitespace = false behavior in SQL Compare
SQL Compare in some instances trims the whitespace characters at the beginning and end of object definitions. While in other instances it takes them into account.
For example when comparing objects directly with IgnoreWhitespace = false it will show the whitespace differences at the end of the object being compared. (See attached screenshot of single direct object comparison)
However, when you generate a script to based off this comparsion the script does not include the expected whitespace changes.
SQLServer considers whitespaces at the end of object to be part of the object definition. SQLServer will include any whitespace characters until it encounter EOF or a GO statement. You can see these whitespace characters via the sp_helptext function. (see attached screenshot)
SqlCompare should be consistent with SQLServer definitions when IgnoreWhitespace = false for all functionality including script generation.
SQL Compare in some instances trims the whitespace characters at the beginning and end of object definitions. While in other instances it takes them into account.
For example when comparing objects directly with IgnoreWhitespace = false it will show the whitespace differences at the end of the object being compared. (See attached screenshot of single direct object comparison)
However, when you generate a script to based off this comparsion the script does not include the expected whitespace changes.
SQLServer considers whitespaces at the end of object to be part of the object definition. SQLServer will include any whitespace characters until…
3 votes
![I7SOdc3[1].png 9 KB](/assets/237430438/I7SOdc3%5B1%5D.png){kind=link}
- Don't see your idea?