239 results found
-
Test for database users before creating them
For example, add an "IF" as below:
IF NOT EXISTS (SELECT * FROM sys.database_principals where name = 'xxx\yyyyyy')
CREATE USER [xxx\yyyyyy] FOR LOGIN [xxx\yyyyyy]
GO7 votes -
Filter Improvements
I use SQL Compare very rarely. Most of the time I use it to find the differences between two databases with different structure version. And therefore I need to see in a blink of an eye what dml triggers are missing or outdated or whatever. Currently there is no possibility to filter for table objects like dml triggers.
It would be very nice if there is an option to restrict the view depending on sub elements like Index, Column, Collation, Trigger.
Maybe it would be enough if the seach bar at the top would also search the SQL view of…7 votes -
Merge stored procedure differences line by line
Add the ability to merge differences between two stored procedures into a new file that can be ran on the server on a line by line basis.
I.E. 10 lines are different in a stored procedure between a file in a folder and a file on the server. I only want to promote 5 of those differences up to the SQL server, adding the ability to merge those 5 changes into a new file would be super helpful instead of having to copy the file from the server and hand merge them.
7 votes -
automap link directly to view/edit table mapping
When SQL Compare apply an automapping on column name of a table, there is a little yellow image with "Auto Map" displayed on the table. It would be nice if a menu or double click or else would be availaible to open directly the column mapping of this table. It would be faster to see the mapping applied and correct it if needed.
7 votes -
Option for 'Ignore Users'
Can we have an option that allow us to ignore the database users?
Thanks
7 votes -
Compare based on Selected Schema
I would be ideal if there was the ability to compare just a single Schema in databases. Example, exclude all dbo object and just include all objects in the XX schema. This would speed up the compare, as we would only be comparing objects in the XX schema and ignoring the 10K objects in the dbo schema.
7 votes -
Ability to safely edit the previous server lists
Please see this thread
https://forum.red-gate.com/discussion/comment/162865#Comment_162865
I would suggest that because the proposed solution requires knowledge and access to the Registry this should be a feature to edit the list.
7 votes -
Don't use "Added" and "Removed" in the Comparison Results report
I just want to share the differences between two databases with the developer and will have to explain that added or removed does not mean that anything was actually added or removed yet.
7 votes -
No error should be reported when two databases are identical
While using command line to generate a difference report (in html format), if the two databases are identical, the console output says:
Error: The selected objects are identical or no objects have been selected in the comparison. Use /include:Identical to suppress this error.
If I include the /include:Identical switch, then the error is not reported on the console, but the output html file has all the objects in it.
I don't want the console error as well as don't want the identical objects in the html file. This is what I want:
- Don't want to use the /include:Identical switch
- If…
7 votes -
Ability to define two SQL logins as being the same
We have separate SQL Server service accounts for each environment. For example, saSQL01prod and saSQL01test and saSQL01dev. We want to ensure that the same permissions in PROD exist in TEST. However, now, SQL Compare wants us to create the saSQL01prod account and remove the saSQL01test account to equalize.
What we wish to happen is that it compare the permissions of the saSQL01prod account in our PROD environment to the saSQL01test account in our TEST environment and generate the compare based off that.
For example, saSQL01…
7 votes -
Ability to Compare from a dacpac to a Database and generate sync scripts
I understand that you have the ability to compare DBs to sqlproj but it would be nice to have it compare with a dacpac. That way I can build a project, persist that build number and deploy from that dacpac.
6 votes -
Memory Leak
I use SQL compare periodically as I have many clients who have the same core DB and so during development I use SQL compare iteratively to update schema, table and stored procedure changes through the 30 instances of the databases. I noticed that it progressively gets slower and consumes more RAM. Obviously I can close and restart to get a new allocation and it speeds up again. But I noticed that when starting it was consuming about 180Meg, then after maybe 15 compares the memory allocation was close to 1Gig. So something is definitely being allocated and not freed up.
6 votes -
My projects - compare all projects
Add an additional "Compare all" button to compare all projects in the actual "Look in" folder. Show a simple is equal/different indicator on each project for the results.
Consider using VS-style solution files or kind of meta-scp.
This is somewhat similar to https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/13517250-auto-compare-after-oping-a-project-mass-compare
6 votes -
Comparing TFS Changesets
When comparing a TFS Changeset in SQL Compare it will show all schema changes that are different between the Changeset and the destination, but within a TFS Changeset, there is metadata within the Changeset to indicate which specific database objects are being changed within the Changeset. It would be a huge timesaver to allow SQL Compare to be able to only select the database objects that are actually being impacted by the Changeset by default. The situation I have is this:
Developer 1 - Adds a table to database A and checks in the change to the development database, but…
6 votes -
give more information in header
The report header shows only the database name. Seeing BobsDB -> BobsDB isn't useful. I would rather have something like: DevServerName.BobsDB --> ProdServerName.BobsDB
6 votes -
risk
There are some changes that are riskier than others, not because of the type of change, but because of the object. For example, some changes require rebuilding a table or index. This can be a simple process if there are a few hundred rows, but it's a risky, slow process if there are a few billion.
It would be nice to add a "risk" value to certain tables, so that when I see a list of changes, I can determine if this particular object ought to be separated out as a different deployment.
6 votes -
Single object deployment
When you right click on an object to see the deployment script and other options, include options for running immediately the script to target database. (to make it more interesting,to run the change script to any of the 2 compared databases).
Also, this should be dome on the right and left scripts at the bottom of the page.
Thanks6 votes -
SSMS integration - compare single object
hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...
right-click an object in SSMS and click an option called something like 'compare against other environment'.
it would then bring up a message box where you could browse an object-explorer for the corresponding object.
the use cases I see all the time for this are
- when people have stored procs next to each other called
spSomeProc
spSomeProcv2
spSomeProcnew
spSomeProc.oldetc on the same database.
2 when you…
6 votes -
More in-depth documentation of how SQL Compare works
Hello
It would be great if there is documentation that explains how SQL Compare works. Everything I came across so far explains what it does but I didn't find the actual internals of it. I am particularly interested in how SQL Compare handles the dependencies between various objects. For example, how can it create a view before creating the tables the view is using?
6 votes -
Be more robust in the face of Transport Errors
Data Compare almost always fails because of frequent (but short) network outages. If we could specify a long timeout, that would solve this problem.
6 votes
- Don't see your idea?