244 results found
-
amazon
Should work on:
how to simply install SQL Compare/SQLToolbelt on AWS EC2 instance (Windows/Linux based)?
3 votes -
Left justify both Object Name columns
We prefix our objects with certain characters, so to right-justify the left Source "Object Name" column names makes it hard to visually read down the list of objects to find something in particular.
3 votes -
Decrypting object performance (batch DBCC PAGE calls)
I frequently need to "generate scripts folder" against large (10k+ objects) databases including encrypted objects (thousands of encrypted stored procs).
A recent run on a (50ms rtt) vpn link took 2+ hours to complete.
It appears that object decryption performance appears to be bottlenecked on
performing 3 round trips to read a single db page, specifically:batch 1: dbcc traceOn(3604)
batch 2: dbcc page(DB, 1, 6573692, 2)
batch 3: dbcc traceOff(3604)
batch 4: dbcc traceOn(3604)
batch 5: dbcc page(DB, 1, 6573694, 2)
batch 6: dbcc traceOff(3604)I think batching page reads (and eliminating many traceon/traceoff commands) would make object decryption…
3 votes -
3 votes
-
Enhance 'Force Column Order' to 'Force Column Numbers'
Sometimes tables can differ in system column metadata (sys.columns) even if they looks completely identical - for example, if I drop a column in a middle of a table. After copying the table to another DB a column id for a half of columns will be different. But some frameworks or applications we use, rely on it, and require reconfiguration / rebuild even on a such a minor change.
It will be great to have a feature 'Force Column Numbers' to preserve column id's for table or view on deploy.3 votes -
Reports created with /ReportAllObjectsWithDifferences should indicate filtered items
I had a panic moment after forgetting that the /rad option was added.
The report made it look like all production users had been removed!Please change the color to a lighter or darker shade and add a "filtered" icon with tooltip that clearly explains that the change was not applied due to filters or exclude/include commandline options.
Kids, don't play tricks on your peers with this option!
3 votes -
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…
3 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 -
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 -
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 -
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 -
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 -
3 votes
Have you tried the options in SQL Compare?
-
Melhorar o uso de memória
Cada vez que é feita uma comparação de database aumenta o uso da memória. Só liberar a memória quando sai e volta pra aplicação.
2 votes -
Sort objects in deployment script
As per:
https://forum.red-gate.com/discussion/85655/feature-request-sort-objects-in-deployment-script
When generating the sql compare deployment script - all objects are scripted in a seemingly random order.
This could be covered by an option to enable/disable it.
And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.
Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.
Currently as it stands, objects get moved…
2 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 -
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 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 -
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 -
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
![I7SOdc3[1].png 9 KB](/assets/237430438/I7SOdc3%5B1%5D.png){kind=link}
- Don't see your idea?