250 results found
-
CSV should use entirely empty value (no "") for null
Current behaviour: the CSV file represents null as the 8-character string “<NULL>” . e.g. If I have a table with an integer primary key column id, a varchar column a, and a varchar column b, and the table has one newly-inserted row (1, NULL, “asdf”), the CSV file would look like this:
o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
o “In1”,”1”,”<NULL>”,””,”asdf”,””Desired behaviour: allow the CSV file to represent null as a completely empty entry. E.g. the CSV file would look like this:
o “Type”,”idk”,”as”,”at”,”bs”,”b_t”
o “In1”,”1” ,, ””,”asdf”,””Suggested options:
1) Command line switch toggling between…
10 votes -
Save Group By Value in Sql Compare
Save the state of the Group By drop down so that we don't have to change it with each managed project.
3 votes -
Create a snapshot of target database before deployment
I usually create a snapshot of the target database before each deployment so I can compare again later to see the changes or generate a reversal script on selected objects. Please add the option to the Deployment wizard alongside "Back up target before deployment"
3 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 -
Column Filters
In the results grid, give the ability to filter the results instead of having to sort, great example is the schema column, let us filter by schema instead of having to sort and then scroll to find the schema we want to look at.
1 vote -
Add an option to the behavior section to include SORT_IN_TEMPDB = ON on all of the CREATE INDEX statements.
For those of us working with data warehouses, using SORTINTEMPDB is the default behavior we need.
9 votes -
Include new functions, views and stored procedures in "use DROP and CREATE"
Would like to include newly defined views, functions and stored procedures when dropping objects in deployment script. Currently, if you create a new stored procedure, then do the compare, it only does a CREATE in the script even if you have "use DROP and CREATE" selected as an option. I have to manually add the drop commands to the script so that it can truly be executed multiple times if needed.
5 votes -
Make activation work
Downloaded the trial version then my company paid for the toolbelt but when I click on Activate I get a error so cannot activate the software.
Can’t connect securely to this page
This might be because the site uses outdated or unsafe TLS security settings. If this keeps happening, try contacting the website’s owner.So, I'm contacting you...
1 vote -
Allow indexes to be excluded by filtering
I have 2 databases - production, and archive. Archive has all the indexes of production (starting with "IX") but also has some archive only ones (starting with "AIX"). Would be nice if I could add a filter to "exclude indexes starting with 'AIX-'" to my comparison - currently I have to export to a script, and manually delete all the "drop index AIX_..." sections.
1 vote -
Add an option to ignore seed value when scripting sequences.
There is an option to ignore identity seed values but none for sequence seed values.
9 votes -
Sort objects in deployment script
As per:
https://forum.red-gate.com/discussion/85655/feature-request-sort-objects-in-deployment-script
When generating the sql compare deployment script - all objects are scripted in a seemingly random order.
This could be covered by an option to enable/disable it.
And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.
Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.
Currently as it stands, objects get moved…
2 votes -
Ignore unmapped tables
Can you provide an option in the tool to ignore unmapped tables for comparison?
1 vote -
Status Messages Covering Server Names
Currently the status messages in the UI for things like Updates to the application show up as blue ribbons that COVER THE SERVER NAMES. That's annoying. The choice are to be reminded again later or skip the message or whatever. But the location for the status message should not cover the server names. Could you kindly move it someplace else? Thanks.
4 votes -
Add RefreshView as an option
Can you add an option that will add the "RefreshView" statement after Alter statements for views?
Thank you.
3 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 -
No carriage returns when copying TRIGGERS text from SQL View
When copying text from the SQL View panel, in the resulting clipboard text all carriage returns are missing. A trigger of a few lines of text becomes just one single long line.
This only happens for texts in the TRIGGERS part, not in the texts of create table, constraints, permissions or functions. There are no visible differences between these texts when looking at the SQL View panel, all texts look normal so this seems like a bug.
It's quite annoying when you quickly want to fix a small difference, or just want to copy text; you have to step through…
18 votes -
Option to omit schema from filename created with SQL Compare
When the target of the compare is a scripts folder, SQL Compare will create new items with the schema name as part of the file name, such as "person.Contact.sql".
Could this be made optional?
It doesn't affect the filename when altering, only creating.
This behaviour causes us issues because we use Visual Studio database projects where the schema is part of the path, not the filename. For example such as "AdventureWorks\Person\Tables\Contact.sql"1 vote -
Source and Target script folder source should stay with their currently selected path instead of switching to the last used on either side.
This was the behavior in previous versions (at least it was for SQL Compare 10) and not sure when it was changed. But constantly switching folder paths make it error-prone and annoying. As an example, let's say I first chose Folder A/Folder B as Source and then Folder C/Folder D as Target. If I go back to source to pick another folder, now it points me to Folder C/Folder D instead of Folder A/Folder B as I originally selected.
1 vote -
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 -
Post script bit value column auto-update
Add an option that will run post-script to set newly added columns that are of a bit value type and that are scripted with a default value to that value after the addition of a bit column.
1 vote
- Don't see your idea?