250 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 -
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.
3 votes -
Read from SQL Native Compressed Backups
Similar to the idea from Steve Hall for SQL Data Compare, SQL Compare should also get the ability to read backups compress by SQL Server.
There is a feature for compressed backups, but unfortunately "this compression is not supported" if you try to read from a BAK with the standard compression of MSSQL.
That would be very important to make partial restores and to have an efficient way to deal with the day-to-day tasks, because bih DBs cannot be handled without compression.3 votes -
Add default collation to match source database when you create a new target database in SQL Compare
When I schema compare in order to copy a database, I often want to create a new database as target. Could it be possible to default the collation of the new database to the one of the already selected source? Or at least make it possible to see the collation of the source database right there in the tool? There are hundreds of collations to choose from, and mostly I get it wrong and then I have to await the compare process and go back and delete the new database and do it all over. Seems like an easy fix.…
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
![I7SOdc3[1].png 9 KB](/assets/237430438/I7SOdc3%5B1%5D.png){kind=link}
- Don't see your idea?