239 results found
-
New Option to Ignore Statistics_Incremental
I would love to have the option to ignore the StatisticsIncremental setting on indexes much the way "Ignore StatisticsNoRecompute" works. I currently have two DBs - one has this option on all indexes and one has it on none. Currently SQL Compare flags all indexes as different even with "Ignore Statistics" turned on. The only option is to ignore Indexes entirely which isn't practical because those are the most frequently changing objects between the DBs. I'm currently still using SQL Compare 10 because it does not pick up the Statistics_Incremental option but I would love to be able…
16 votes -
Add Last Modified Date Column to Comparison Report
Add the Last Modified Date Column to the Comparison Report, like it's shown in the Application.
16 votes -
Option to ignore SQLCMD variables in SSDT scripts
Any differences involving usages of SQLCMD variables would be ignored with the option turned on.
16 votes -
ignore constraints
Option to ignore missing default constraints. Often when comparing two table defs, I want to see if columns or data types have changed but am not concerned at that moment about default constraints. Would like to see an option to ignore missing contraints.
16 votes -
Avoid creation of Recovery tables
Please give an option to ignore Recore tables creation. I am trying to use SQLCompare in DevOps model to avoid long release timings. But if there is any data type change to a huge table then current concept of creation of recovery tables is disabling all the FK's, removing indexes and eventually creating a new table. This is very long process and not benefitting the projects. There should be an option to avoid the creation of Recovery tables. Please think in that perspective.
16 votes -
Make SQL Compare Three-part identifiers aware and filterable
Not always a deployed database has the same name of the source database due to customers' naming conventions. So it'd be great if SQL Compare will be three-part identifiers aware, so that if you compare the same table from different named databases as following:
SELECT *
FROM MyDatabaseA.MyTableSELECT *
FROM MyDatabaseB.MyTableSQL Compare will not show them as different if you want a three-part identifiers insensitive comparison.
15 votes -
Ignore Database Name in Stored Procedures, Views, and Functions
We have 3 environments for one of our core applications. Each environment has a different database name: dbproto, dbuat, and db_live for an example.
We keep all the SP, Views, and Functions we develop in a separate database so at no time do we alter the database supplied by the vendor. This database name is the same in all three environments.
Because of the name difference for the vendor database all the SP, Views, and Functions are flagged as different. The only difference for 95%+ of them have is the database name (eg dbproto vs dbuat).
…
14 votes -
compare two different commits from GIT
Add support for comparing two source control commits through the UI.
Currently this requires cloning a second repository to perform the compare.
13 votes -
Colors and screen format need help
Main window which displays comparison results needs more color so differences standout. Little black boxes to indicate same, differences, left, right are not easy to quickly focus on. Must be a bug with the window sizing. Cannot size comparison results screen which spreads all content out and server/db for source and target at opposite sides of my 24' monitor. Can't size columns either.
13 votes -
Tab size should be configurable
The comparison window seems to use a hard-coded value of 8 spaces for tab characters. The SSMS default value is currently 4 spaces per tab. So things that align just fine in SSMS are always wacky when displayed in SQL Compare. Couldn't you make this a user-configurable option?
13 votes -
Compare database settings such as snapshot isolation
Have SQL Compare be able to compare database level settings in sys.databases such as isolation level
12 votes -
compare multple databases
I'm going through an exercise of determining object changes between versions of an app suite containing 55 databases.
It would be nice to be able to specify which databases to compare during a single run instead of processing it one database at a time.12 votes -
Synapse Compatibility
Can the compare engine be enhanced to work with Azure Synapse?
12 votes -
Pull filter from source controlled database
When comparing a source controlled database (SSC) to a live database, it would make sense to use the source controlled database's object filter (filter.scpf file) when running the comparison instead of having to manually recreate the filter inside of the SCP project. Also, it would be better if the SCP project stored a link to the filter file used instead of storing the filter string, as it is very inconvenient to have to maintain these separately. If the filter file is changed in SSC, I want SCP to be able to pick up the change automatically.
11 votes -
SSIS package compare
I would like to suggest that SQL compare tool also have to support SSIS package compare. Currently I am at the position that I have to compare SSIS packages between two servers and find out if any SSIS packages missing plus if any SSIS packages on old version etc. Currently I am talking about SSIS packages reside in MSDB but even if it can be compare between file system, that will be great.
11 votes -
Similar to other ideas, any project option to ignore should give ability not to display ignored option finds in comparison result
The project option gives you the ability to ignore based on certain filters e.g. white space. However, if any other difference is found, when you display the comparison it highlights the things you told it to ignore. If in the case of white space, every line shows a highlighted difference for a white space difference, but the one actual difference you are looking for is impossible to find without scanning the whole comparison. Ignore should give you the ability to ignore in the comparison view also (for any ignore project option).
10 votes -
Sync a Database to a Source Control Repository
We really need the ability to "sync" a database to VCS repository, not just compare. I know this limitation exists by design because conflicts can be missed, but we have a scenario that demands it. We have batch check-ins that can take up to a half a day to commit manually.
10 votes -
Excluding a user should also exclude their mappings to roles
Using SQL Compare version 11 for Microsoft SQL Server, I can exclude a user from the schema comparison:
<exclude>Role:MyCustomUser</exclude>
This works fine for excluding the user.
However, the comparison engine does not exclude the user's mapping to roles. The script includes sp_addrolemember commands for the excluded user.
When excluding a user, I expect their role assignments to also be excluded.
I suspect this behavior may exist with object exclusions for other object dependencies. Have not tested other scenarios.
10 votes -
Ignore database variables used in Visual Studio Project
There are cases when for continuous intergration we use Visual Studio Project 2013 to build our databses. Sometimes we need to use database variables these look like: [$(DatabaseName)]. Though Visual Studio can recognize it as a variable, redgate will not and will output that as it is for deployment or comparison.There need to be an option where these variables can be ignored or output using the variable name which is specified in the project.
10 votes -
CSV should use entirely empty value (no "") for null
Current behaviour: the CSV file represents null as the 8-character string “<NULL>” . e.g. If I have a table with an integer primary key column id, a varchar column a, and a varchar column b, and the table has one newly-inserted row (1, NULL, “asdf”), the CSV file would look like this:
o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
o “In1”,”1”,”<NULL>”,””,”asdf”,””Desired behaviour: allow the CSV file to represent null as a completely empty entry. E.g. the CSV file would look like this:
o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
o “In1”,”1” ,, ””,”asdf”,””Suggested options:
1) Command line switch toggling between…
10 votes
- Don't see your idea?