250 results found
-
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 -
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 -
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 -
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 -
Bring back the neat and handy ability to popup the differences window.
I used to review the changes on a separate windows on a vertically aligned monitor. This allowed me to fast review changes of most objects without using the scrollbar.
Now, for even a small table with constraints, FKs and permissions there is scrolling needed. I need constantly to resize either that upper panel to see objects or bottom one to see changes. SQL review tasks are taking much longer now.
The Summary view is a nice concept but far from production usability.
1 vote -
SQL Data Compare\SQL Compare between SQL database tables and Azure Synapse Serverless database external tables
It would be great if SQL Data Compare/SQL Compare work with External Tables in Azure Synapse Serverless database.
1 vote -
Allow me to exclude users in DB compares.
I use something like domain\UserDEV for development and domain\UserPRD for production.
I can ignore a users permissions but I don't need a list of users that I know won't exist in different environments.
This confuses business users when I try to show/demonstrate the exported report.
1 vote -
Add support for SQL Server Management Studio 20.
If I open up Tools --> Application Options in SQL Compare, I see SQL Server Management Studio 19, but not 20 which has been out for months now. And I believe it is the same in SQL Data Compare as well.
1 vote -
need ignoreMaterialziedViews option in flyway.toml
need ignoreMaterialziedViews option in flyway.toml
we want to ignore materialziedViews when performing drift checks and also while generating the baseline script itself.
Having an option in flyway.toml will help1 vote -
Suppress Ignored Statement Warning
When using SQL Change Automation command line, it would be helpful to suppress warnings for ignored statements. Since these scripts are checked into source control, these warnings will get long over time with addition of more scripts.
1 vote
- Don't see your idea?