254 results found
-
Allow migration of Indexes ONLY
I have multiple databases which have the same columns (mostly) but sometimes differing defaults.
They also have different indexes.
I'd like to choose to ONLY sync indexes across.
Obviously the system would need to be intelligent enough to sync only those that have the columns they use/include in both source and destination.
1 vote -
Always trust server certificate via option
Version 15 adds checkboxes for Encryption and to Trust a server certificate, but if you don't maintain proper certificates you now always need to check the Trust server certificate box on both servers for new comparisons. It would be great if there was an option to default the behavior of these checkboxes to fit your environment.
10 votes -
user defined type
I recently had to use SQL Compare to create a rather large add new and update deployment script.
I was pleased that it picked up User Defined Types in addition to the normal tables and stored procedures.
But it did not pick up the permissions for the User Defined Types, and that was a failure point when executing the stored procedures.
This was my first time working with User Defined Types before, and I thought it odd they needed permissions at all. I did not apply any in the development environment, and they worked there.
But the error was clearly…1 vote -
Trigger Comparison/Ordering
I have TableOne in DatabaseA and DatabaseB. DatabaseA.TableOne has Trigger1,Trigger2 and Trigger3. DatabaseB.TableOne has Trigger2 and Trigger3. After all table columns are analyzed, DatabaseA.Trigger1 is compared to DatabaseB.Trigger2 and naturally they show as different. I'd like to see Trigger1 "compared" to blank, then both Trigger2s compared, ... Try to match up on trigger name and if there isn't a match, show blank
2 votes -
Constraint and Index Names
Currently, there is an option to ignore constraint and index names. Please separate out indexes from constraint names.
4 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 -
Add next to table object names the record count in the table
When comparing tables I saw that for two tables auto-map has mapped some columns. Since I know the tables are not compatible I had to check that the target does not have any rows in the table. Please add some indicator on the object list so that I can know easily if there are any rows in the table
1 vote -
beyond
Allow an object / script comparison to be opened in an external Diff viewer, such as Beyond Compare. Provide configuration settings to configure external diff viewer EXE, similar to what source comparison tools do.
1 vote -
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 -
constraint
Make 'Ignore Constraints' ignore default constraint values.
6 votes -
allow partial name search in database name
When selecting a database name, please allow filtering the list by typing partial strings from the middle of the name of the database name. for example, if my database name is "Database_1335" I could search for it by typing 1335
6 votes -
excel
Include attributes to be changed in an object to an excel report in sql compare. include not only the object name to be changed but the actual change to fields
within the object or the script change to be made for programability items users roles and permission. e.g. Database.schema.objectinsource.change(details of change column to be altered in a table its original value its new value its datatype and length its nullability and any default constraints.1 vote -
Allow filters to be case INsensitive
Allow filters to be case INsensitive
When I add a filter e.g. schema name begins with "ABC" then objects with schema Abcdef will not be shown even though i have opted for case insensitive matching
this means that I have to make several OR filters to cover all combinations of upper or lower case letters1 vote -
Commented-out blocks of code should show as changed
When an entire block of code is commented out with the /* */ characters, SQL Compare only shows only the lines with these characters as changed. It does not show the unchanged block of code between them as changed, even though the impact of commenting out this code can indeed be a significant change.
I suggest that unchanged lines of code enclosed by /* */ around it should still show as a substantive change. When we recently deployed an SP update with a large block of code that was commented out during testing, it slipped in because the scrolling view…
1 vote -
Honor configured entities when running SQL Compare and SQL Data Compare from the Command Line.
Previously, when running SQL Compare and SQL Data Compare from the command line using a .scp file and .sdc file, the tool would account for the entities to be included as described in the .scp and .sdc file. At some point this behavior changed and now the command line generates a script that contains ALL differences between source database and target database. This broke our automated builds that were making use of the command line. I am requesting that this be looked at again, and that these tools would take into account the entities described in the .scp and .sdc…
6 votes -
ned.bush@ky.gov
Have pop-up screens (My Projects, Compare Progress, Save Script, etc.) open up on the same display as the main program when program is running on a computer with multiple displays.
I've noticed that if I'm running SQL Compare or SQL Data Compare and move it to my secondary display, it still tries to open up pop-up dialogs on the primary display. This can be annoying, especially if it has been a little while since I used the program and I forget it does this and can't spot why program seems to have stopped responding to mouse clicks. Also, when the…
1 vote -
1 vote
-
Allow option to not script logins when generating script and also add check for existing users to avoid errors
I was trying to create a copy of the development DB schema into local server. I got errors and warnings. The error I got was in the section of code that created the login and then attempted to create a user (myself). I didn't sent this error as it contained some confidential info. There also needs to be a way to remove things like login names from the generated email.
1 vote -
Correct order when renaming column and adding column with the old name
After explicitly fixing column mapping, I encountered an error when renaming an existing column and then adding a new column using the old name (different casing).
SQL Compare had scripted the column add before the rename.
SQL Compare needs to be able to detect the conflict and script the rename before the column add.1 vote -
select what to compare
On the same screen as specifying the databases to compare, I'd like to specify what objects (tables, procs, functions, ...) should be compared and have the choices saved with the project. Often, I'm looking to see whether I made an update to an object in DB2 that I made in DB1 and I don't need/want to wait for all objects to be compared. Sort of using the object filter ahead of time.
5 votes
![I7SOdc3[1].png 9 KB](/assets/237430438/I7SOdc3%5B1%5D.png){kind=link}
- Don't see your idea?