252 results found
-
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 -
unicode
Please support Unicode. The current version can not display my descriptions of fields with Unicode.
3 votes -
Make script file an editable text file so we review, edit or programmatically generate the file.
Make script file an editable plain text file so we review, edit or programmatically generate the file.
Once the script file is used, there is no good way to retrieve what were included in that file, especially if the included objects have been removed.
It will help us keep track of changes across multiple scripts (SCP) over time.
Make it an option to compress it in case it is a large deployment.
3 votes -
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 -
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 -
Remote Git repository as the source of a comparison
Allow SQL Compare to use a remote Git repository as the source of a comparison.
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
![I7SOdc3[1].png 9 KB](/assets/237430438/I7SOdc3%5B1%5D.png){kind=link}
- Don't see your idea?