250 results found
-
137 votes
-
Support for Replicated Databases
I would like to push schema changes to a transactionally replicated database. Now, SQL Compare breaks replication when I push schema changes. Please add support for sprepladdcolumn and sorepldropcolumn rather than ALTER TABLE.
117 votes -
Ignore DEFAULT(X) column constraints
Replicated (push) tables do not contain default column constraints on the subscriber which are identified as breaks within SQL Compare 10. Provide the ability to ignore DEFAULT(X) properties on column within the UI.
108 votes -
Add a Rollback Script Save option for both SQL Compare & Data Compare
In order to create a rollback script, we currently need to reverse the direction of deployment, save the rollback script, cancel the deployment, change the direction, then proceed with deployment in the correct direction. It would be great if the same screen on the Deployment Wizard would allow you to save BOTH a change script and a rollback script.
105 votes -
When tables have different number of indexes the compare will show differences when in reality the indexes are the same, just not aligned.
A table on server 1 has 2 indexes. The same table on server 2 has 4 indexes. Depending on the order that the script generates the DDL the compare might show all 4 indexes as different/new where it should show 2 as the same and 2 new.
89 votes -
Add BACPAC to SQL Compare (and SQL Data Compare)
At the moment you can compare Database, Backup, Snapshot and Source Control.
Please add a BACPAC file as well.
A BACPAC is an artifact that encapsulates the database schema as well as the data stored in the database. The BACPAC is a Windows file with a .bacpac extension. Similar to the DACPAC, the BACPAC file format is open – the schema contents of the BACPAC are identical to that of the DACPAC. The data is stored in JSON format.
How to: Import and Export a Database (Windows Azure SQL Database)
http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspxImport a BACPAC File to Create a New User…
88 votes -
dark theme
You should create a dark theme (gray or black) UI for us who are constantly staring at your interface...
77 votes -
Color-coding servers
For safety when moving among servers, I have the desktop backgrounds of my servers color coded as follows:
My workstation - green
Other developers' workstations - blue
Development - yellow
UAT - orange
Production - redIn SQL Server Management Studio, I've colored the status bar for any query window in the corresponding servers the same way.
It would be nice if I could color-code the two halves of the "compare to" window in SQL Compare and SQL Data Compare the same way, based on the server/instance name!
Even better, could it pull the color values from some SQL Server…
76 votes -
Option to select individual dependencies (or affected objects) when migrating changes with the deployment Wizard.
Currently the Deployment Wizard only allows for all dependencies to be specified, or not. If I know a specific dependency to be problematic (will fail the overall deployment if selected) my only options are to not deploy dependencies (not good) or to generate a migration script and step through it a bit at a time or remove references for the dependencies I need to skip, which can be cumbersome when dealing with many changes. It would be nice to be able to choose all dependencies (current option), specify not to deploy dependencies (currently an option), or incrementally check on or…
74 votes -
Add option for older version of HTML Report in SQL Compare 13
The new version of the HTML report is not as useful as side-by-side comparsions. I don't like the new version, and the developers like it even less. Thanks!
60 votes -
Choose source control label as a version of a data source
Today, SQL Compare allows for two options when selecting a version of a source control data source - latest (head), or any other change set. It would be great if there was a third option: to select a version by label. We use labels as a means for controling which code is promoted from development to test to production. Anything ready to promote is labeled as “build ready.” It would be great to use this build ready label when selecting the version from the repository.
57 votes -
Allow comparing objects of all types with different names, not just tables.
It would be nice to be able to use RGSC to compare such objects by re-mapping. A recent change allows doing this, but with tables only. All other objects would be a helpful touch.
This could be useful for several scenarios, including demonstrating a proposed change to a current version. We also sometimes end up with different test versions of objects that differ slightly with less than helpful comments. (b/c all our devs' code is self documenting!)45 votes -
Compare instance level information
Like configuration settings, security info (logins, server roles...), linked servers, jobs, SSIS catalog info for SQL2012 (folders, environments, security, projects, packages...) etc.
42 votes -
38 votes
-
Option to script indexes and triggers into their own sub-folders
Project level option to script indexes and triggers into their own sub-folders. This allow for a more granular check-in and makes text diffs more clear.
37 votes -
Reuse Open SSMS for deployment scripts
When selecting the option to open the deployment script in SSMS Compare opens a new instance of SSMS for each script that you generate.
In place of that would it be possible to open the scripts in an existing SSMS instance that is open already? This would make things a lot easier when generating multiple scripts.
35 votes -
Add a "source option" for nuget package store
It can be very useful to add an option for reading from a nuget package store, in addition to "Direct From Source Control" and "Scripts folder".
The package should be reached unsing the http url. This is useful when reading from a build server outcome, which can upload the packages to the nuget store.33 votes -
Include tables in "use drop and create instead of alter" comparison behavior
Provide additional option to "use drop and create instead of alter" so that tables can be reconstructed blindly
32 votes -
Option to ignore rowguid column generated by Merge Replication
When SQL Server sets up merge replication it creates a rowguid column to maintain integrity between the tables of the publisher and subscriber. Typically this setup doesn't exist in non-prod environments which ends up generating false positives differences.
31 votes -
Allow changing of the tab size
In the "SQL Differences" pane, tabs are expanded to 8 characters.
(Can get very messy depending how other employees have formatted the contents of stored-procs)
Could there be a way to allow this to be customized [e.g. to 3 chars] ?
30 votes
- Don't see your idea?