250 results found
-
Export HTML via "Generate Comparison Results Report" using Command Shell
There should be a way to Export HTML via "Generate Comparison Results Report" using Command Shell.
When we have a ".scp" file which contains the Information about the Databases to be compared, which is saved as a project.scp.
In this case, if we have a ".scp" file, then is there any command to export the html.?3 votes -
Create deploy and rollback at one invoke
My company is using SQLCompare 14 and always create roll forward and roll back sql with 2 calls by reversing the input arguments., We output the database into file system and compare both directories. It took 15 sec for the "Registering data sources" because we have a big Database. We have 10 or more database so that adds up the time to several minutes to build a patch every time we check-in .
Can we add a switch to create both forward.sql and rollback.sql at one time instead of call this 2 times? This can cut our build time in…8 votes -
Filter for sensitivity of column data type comparison
For example, I would like to ignore when a column is a VARCHAR on both databases but with different lengths so I can focus on when the 2 data types are completely different eg. VARCHAR and NUMERIC.
1 vote -
Fix the selection of working folders
Let me change the location of the users data folders. The application creates a folder inside the Documents folder. When I change the location in the Application options dialog still a folder inside the Documents folder is being used. I want my Documents folder not to be used by this application
3 votes -
Databases with a large amount of objects hangs
I am trying to do a schema compare and deploy but the source database has 99k objects. Is it possible to chunk the deploy feature?
6 votes -
Add window management to detached pop=out window
In SQL compare, if you open the pop-out widow to view differences in a separate window, the normal window controls like maximize and minimize are not available. you cannot double-click the title bar (or Alt+enter or F11 or anything) to maximize it.
Request adding missing window management to the differences window
2 votes -
Create scripts folder ignoring fill factor
File->Create scripts folder should script index fill factor. When the created folder is compared against a DB I can optionally include/exclude the fill factor as I need
6 votes -
powershell cmdlets for SQL Compare
It would be nice to have clean powershell cmdlets (like SCA) for SQL Compare rather than having to use the old-school command line and arguments.
2 votes -
Software updates not appearing when Help, Check for updates is used
Currently using version 14.1.7.14336. clicking on Help, Check for updates. I get you are running the latest version. But there has been 3 updates released since. The current update is 14.1.10.14805 released 01/27/20.
Trying to see why this happening. How long does it take for the software to see these updates.2 votes -
Option to Ignore Temporal/History Table
It would be handy to have an option to ignore Temporal/History table configuration when comparing two like databases where one has had some tables configured as temporal with a history table. This would be helpful to isolate any other changes outside of the temporal/history configuration.
20 votes -
1 vote
-
It would be helpful to provide the capability to examine two objects within the same database.
I've worked over many years with multiple teams and I observe the same phenomenon. The proliferation of OLD, _BAK, _20191123, _ETC objects as developers try out new things for all sorts database artifacts; Tables, Views, Sprocs, etc. I would find it immensely helpful to compare two such artifacts, TABLE and TABLEOLD (for example) to see what has been changed.
4 votes -
Search within objects
Compare already has a search filter, however it would be great if you could also search within the objects and not just by the object names.
8 votes -
More efficient scripting for non-varchar/nvarchar extended properties
At the moment, extended properties that are varchar or nvarchar are scripted out by SQL Compare as literals ('value' or N'value'). Unfortunately every other data type is scripted out over three lines (plus a GO), declaring an @xp variable of the appropriate data type, SELECTing (not SETting) its value, and finally adding the property.
With heavy use of extended properties, or even mild use of non-(n)varchar properties, change scripts (and object scripts in SQL Source Control) can become huge pretty quickly. This causes various issues, not least of which is readability during peer review/PR approval.
I'd like to see this…
3 votes -
Option to "Ignore index named like nci_wi_%
Please add an option to "Ignore index named like nciwi%
These index are added by SQL Server (starting with Azure SQL DB), as part of optimizing the workload on a database.
They make it impossible to compare two databases, as too many "false" differences exists.
28 votes -
Script subfolder exclusion
When using script as a comparison source allow the ability to exclude one or more of the subfolders.
4 votes -
Prevent ProjectGuid changes in RedGateDatabaseInfo.xml (conflict with SQL Source Control)
We use both SQL Compare and SQL Source Control to track schema changes. When you update scripts using SQL Compare, it sets the ProjectGuid property in the RedGateDatabaseInfo.xml file. When you check in changes using SQL Source Control, it removes the ProjectGuid from the file. This creates extra work because source control indicates there are differences or conflicts when this is the only change. It would be helpful if the two tools functioned the same.
2 votes -
Add a possibility to update all installed Redgate tools
I have installed the SQL Toolbelt and I would like to update all its components in one shot. Currently, It is possible only by downloading the setup of Toolbelt from Redgate site and "re-installing" the products.
When I go to Help->Check Updates for particular component, let's say SQL Compare, only this component can be updated. And mostly I have to close All my SQL Server Management Studio (SSMS) session and Visual Studio (VS) Sessions for the
update, which is time-consuming, but I guess makes sense.But after this, I start again all my SSMS and VS sessions and When I…
3 votes -
Autofill fields for "Create new snapshot" using the other database selected
The source for create new snapshot defaults to database. Automatically populate Server, Authentication, Database and New Snapshot name using the Database information on the other side of the compare window.
Customizable name tags for the new snapshot name would be perfect: [SERVER][DATABASE][DATETIME].snp
9 votes -
Install update ribbon obscures the 'to and from' database machine name
With a deadline looming I needed to do a comparison, but I could not see the 'to and from' database machine name until I installed the update. It was hidden underneath the ribbon.
2 votes
- Don't see your idea?