587 results found
-
Source control slow down
SQL Source control is slowing down my entire SSMS. This wasn't always the case, but now trying to get a context menu to show up on a table can take up to 30 seconds. Please fix!
29 votes -
Fix Extended Properties difference highlighting
I use extended properties on all of my columns and tables. When I check in a table initially, these transfer fine.
If I edit the table and add a new column somewhere in the middle (i.e., anything other than the last ordinal position) and give that column an extended property, SQL Source Control correctly identifies the new column. However, down in the bottom pane when it compares the database version with the source control version, it incorrectly flags each and every extended property in an ordinal position after my new column as having changed.
Can this be modified so that…
6 votes -
When generating a migration script there should be options to indicate if an object exists then, take the appropriate action (create/alter)
Basically when you compare then you want the script to generate by checking if the database object exists then perform the appropriate action. So, if you are updating a stored procedure then there should be two blocks of statements where the first block is to check if the stored procedure exists and if not exists then create the stored procedure else alter the stored procedure. This should be applied to other database objects such as tables, columns, views, functions, stored procedures, user defined table types, etc.
1 vote -
Embed Coments
You should consider adding tokens like the following:
--%version --%
--%modifications --%When you check out the latest version of a SQL Script, Source contral would replace a token in the script with the version history from the repository.
When the script is checked it additions made in the modifications token are grabbed and included in the comments box for check-in.In addition the modification comments could be formatted a little better either by discreet fields or by a masked format.
Make the message concise and informative. I use the following format:[bug/issue number] [Area of Focus] [Action completed]
Ticket:…
4 votes -
make multiple git commits without a refresh in between (until after push)
When committing multiple changes with GIT it takes several extra minutes, because it has to recheck for changes between each commit.
I have a large database and sometimes 10 or more commits to make in a row.
It would speed up a lot if it did not have to refresh in between each commit.
39 votes -
10 votes
-
Manage setting ChangeLog Database through UI for SQL Server
The SQL Source Control uses the default trace in SQL Server, however this is stored in the tempdb which can be cleared after a restart.
RedGate suggest using a change log database as shown in the link here: https://documentation.red-gate.com/display/SOC3/Logging+changes+to+shared+databases
However, this requires you to manually edit the Engine Options xml file in the user profile, this should be configurable in the UI making setup a lot easier. If you have 10 or more developers it requires that those developers maintain their own Engine Options xml file.
It would be great if this is configurable through the UI on Setup when…
2 votes -
1 vote
-
I would like to see a command line interface added to the SQL Source Control. Having this to be able to automate saving change into TFS
Have asked for this from support several years ago when the Source Control first was offered. Surprised still no command line interface. The ability to automate saving db changes automatically into TFS or GIT would be widely accepted by the DBA community. I would purchase it tomorrow if was made available.
9 votes -
Support Database Projects Referenced as Same Database in SSDT
Currently, when comparing an SSDT project using SQL Compare, it only loads the base project. If the project references another project as the same database (the standard workaround to the circular reference problem), the objects in the referenced project will not be compared. This can lead to changes being missed and deployments failing.
It would be nice if SQL Compare could follow the reference back and include the objects from the referenced database in the compare as well.
14 votes -
Allow a pre and post scrip to run on SQL Data Compare
Sometimes I need to write scripts to run before and after a SQL Data Compare.
13 votes -
git commit and push together
Add the option to push to a remote at the same time as a commit (maybe a checkbox next to the commit button - similar to sourcetree).
This would be easier than having to navigate back to the "commit changes" screen and push using the error prompt.
92 votes -
git - mechanism for adding/commiting external files
I have a single repository for a project that contains both database files and c# code. Currently, git support only allows me to commit database files, leaving the c sharp code out of step and potentially in an inconstant state.
It would be great if sql source control had the option to stage and commit other changes in the repository (or allow me to generate files but not commit changes - similar to working directory mode).
9 votes -
The ability to call source control features in a batch command respective with a command line tool
We are looking for the ability to commit a set of databases periodically (e.g. nightly) into SVN. So we have a fall back if someone forgot to commit and loose changes on important databases.
2 votes -
Copy history comments in SSMS
When I am updating my database objects, I'd like to include the version history in my script. I can't copy the version comments into my header block. Perhaps a SQL Prompt like a snippet that pastes the comments into the text editor would work.
1 vote -
Make the ALL checkbox under "Get Latest" work so I can de-select everything
Make the ALL checkbox under "Get Latest" work so I can de-select everything. It seems to only work when selecting all items.
1 vote -
Allow sorting Commit Changes by multiple columns (e.g. Type then Name)
I would like the option of sorting by more than one column at a time in Commit Changes. I typically want to sort first by Type and then by Object name.
4 votes -
Screen Reader Access
Can you make the tools more accessible through screen reader?
The Tools are not readily accessible through Screen Readers and thus are very difficult to use by partial sighted people who rely on screen readers. I am one of them.4 votes -
Button to script changes, but not commit them
This is similar to "Allow commits to occur with other code changes," except that if I link to a scripts folder, I have to do that all the time, and I can't ever just commit. I'd like to have the option to commit if what I'm doing is purely in the db (a sp change, for instance), or to just script to the folder if there are application changes also required (like adding a table column)
2 votes -
Ungroup Source Control Commenting
Is it possible for the comments window to hold a comment per object rather than as a group? That way I can quickly individually comment multiple objects and check them all in in one go.
6 votes
- Don't see your idea?