- or
No existing idea results
- ~ No ideas found ~
245 results found
-
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 -
Exlcude specific items from Deploy script from Comparison Results screen
SQL Compare
Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.This is a SSDT feature that is missing in SQL Compare.
I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.
Using a trigger associated as with a table as an example:
Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger on the source should not be copied to the target, but other schema changes on the table should be copied.
In the comparison results screen - allow an action on the row for the modified table to exclude the trigger from the deploy script.The resulting deployment script would simply exlude the trigger from update.
A more shophisticated choice would be "preserve". This would exfectively keep the target definition (if it exists) - a choice required is a table rebuild is required.
The existing filters panel should not be affected by this (beyond reflecting the resulting filter rule from the exclusion made on the table).
SQL Compare
Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.This is a SSDT feature that is missing in SQL Compare.
I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.
Using a trigger associated as with a table as an example:
Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger…5 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 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 half.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 -
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 -
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 -
Column Filters
In the results grid, give the ability to filter the results instead of having to sort, great example is the schema column, let us filter by schema instead of having to sort and then scroll to find the schema we want to look at.
1 vote -
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 -
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 -
Make activation work
Downloaded the trial version then my company paid for the toolbelt but when I click on Activate I get a error so cannot activate the software.
Can’t connect securely to this page
This might be because the site uses outdated or unsafe TLS security settings. If this keeps happening, try contacting the website’s owner.So, I'm contacting you...
1 vote -
Save Group By Value in Sql Compare
Save the state of the Group By drop down so that we don't have to change it with each managed project.
3 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 start next Redgate component, let's say SQL Data Compare, it might also ask for an update. And I have to repeat the procedure of shutting down my SSMS. and VS-sessions. Having some 10
Redgate components installed (SQL Toolbelt), I have to repeat this process several times per week, which is not that productive.Therefore, I would like to update all components, let's say weekly, so having to stop my SMS and VS-sessions only weekly, which would be totally ok.
Whether this multi-component update tool is launched either from each components Help -> Check Update or as a separate update tool from Windows menu, I think both would work.
PS. This feature is initiated based on my Support-ticket: https://productsupport.red-gate.com/hc/en-us/requests/147081
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
6 votes -
Create a snapshot of target database before deployment
I usually create a snapshot of the target database before each deployment so I can compare again later to see the changes or generate a reversal script on selected objects. Please add the option to the Deployment wizard alongside "Back up target before deployment"
3 votes -
Allow indexes to be excluded by filtering
I have 2 databases - production, and archive. Archive has all the indexes of production (starting with "IX") but also has some archive only ones (starting with "AIX"). Would be nice if I could add a filter to "exclude indexes starting with 'AIX-'" to my comparison - currently I have to export to a script, and manually delete all the "drop index AIX_..." sections.
1 vote -
Be more robust in the face of Transport Errors
Data Compare almost always fails because of frequent (but short) network outages. If we could specify a long timeout, that would solve this problem.
6 votes -
Ignore unmapped tables
Can you provide an option in the tool to ignore unmapped tables for comparison?
1 vote
- Don't see your idea?