588 results found
-
Unable to load a project file after installation
After installation, I was no longer able to load a project file within SSMS. I also was unable to create new projects. My fix was to reinstall SQL Server 2008 R2.
1 vote -
BUG? "Changes to commit" icon, however, there are no changes
We have some databases that get hammered overnight, tables are created, dropped so on (don’t ask, 3rd party databases = fail). Anyways, by the following day the database is back to its original state (schema wise). The databases have a "changes to commit" icon, however, when i right click and select "commit changes to source control..." it never finds anything different and i get "No objects with changes to be committed to source control".
This is repeatable and happens most mornings.
8 votes -
Notification that you are out of date as other users have committed changes
If other users have committed changes, it would be useful to see these so you know you need to get latest. This could be implemented as a different colored blob on objects so you know that they aren't up to date with the copy in source control
38 votes -
Option to ignore GRANT differences
Working on the Company domain XX\ but Production is on RackSpace IAD\ means that every permission for domain users provokes a DIFF. I'd like the option to "ignore GRANT differences" for a target Instance. It should be OFF by default.
32 votes -
Don't require unlink/relink to change folder
I'm using Sourcegear Vault, but I suppose this could also apply to other SCM tools.
I'd like to see an option to change the source control folder for a database without unlinking and re-linking. This would simplify working with code that has multiple branches.
4 votes -
Control-backspace in textboxes
A very tiny request: I like to use control-backspace to quickly delete words when typing in a textbox. This doesn't work in the commit message.
4 votes -
AutoCheck selected version objects in SQL Compare
When I look at my history, I can view all the objects in a specific version but when I click on "update to this version with SQL Compare" it get back ALL my un-synced objects.
If your systems are well synced this isn't a big deal but I have hundreds of objects that still requiring syncing so I have to search for each object and check it before I can commit.
It would be GREAT if the DB objects in a selected version were AutoChecked in SQL Compare.
It would make migrating on systems that are less than perfect much…
1 vote -
Support TFS Proxy Server for Remote Development
Our TFS server is located in a hosting center so that multiple offices can use it simultaneously. We use a TFS Proxy Server locally in each office to cache the data so that it is much faster to work with.
35 votes -
BUG: Undo removes extended database properties
If I do an undo on e.g. a stored procedure. SQL Source Control removes the extended properties from the database. The extended database properties are not checked in but removed on undo. We use these properties to store some metainformation about the database itself and readding them by hand after an undo is not that funny.
1 vote -
DB2, MySQL, and PostgreSQL
Are there any plans to support DB2, MySQL, and PostgreSQL? I could use SQL Source Control and SQL Compare for our DB2 and MySQL databases on Linux. Support for PostgreSQL on Windows servers would be useful as well.
41 votesNo plans as of yet…
-
Create the database from scratch
Instead on relying on the user to create the database and all the file groups, files and getting the collation correct, source control should do this for the user. it could perhaps prompt for a file location to put all the files but if I've gone through the effort of making file groups and sizing my files just right, I want those changes to be kept!
43 votesSQL Compare 8.50 comes with the SSMS Integration Pack, which allows you to get the latest version of the db or a specific version of the db to a new database. This will use all the defaults for your new db.
For more information, see http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/8.50/ssmsip_deploy_new_database.htm&toc=SQL_Compare/help/8.50/toc1280663.htm.
-
Repository manager
if you work with several branches, it becomes kind of hard to keep track of everything, wouldn't it helpful to have a Source Control manager or something which shows all your branches and the databases connected to them.. then you can more easily make upgrade scripts between several branches if needed.
6 votes -
Auto checkout from TFS on modify of sql object. and show the object as checked out in SQL Mgt Studio
Auto checkout from TFS on modify of sql object, and show the object as checked out in SQL Mgt Studio for other users in case of shared configuration.
76 votesSimilar to TFS checkout suggestion, http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/802123-tfs-exclusive-checkout-svn-lock. I guess the difference here is that it is an option to do the checkout automatically.
-
Add % Progress indicator to "Calculating Changes" & "Determining Latest Version"
When dealing with big Databases (100's of tables, views, sp's etc) "Determining Latest Version" and "Calulating Changes" can take ages, you cant navigate away to another database because the Source Tab restarts on the new database. If you cant speed this up, a progress indicator would be helpful when working on multiple databases and multi-tasking.
18 votes -
Don't store logs in user profile!
As my Windows C: partition has quite low free space I regularly inspect what files occupy considerably amount of space. Since I have SQL SourceControl installed, there are hundreds of MBs occupied in addition! The reason is, that SQLSourceControl creates log files and stores them in
C:\Dokumente und Einstellungen<userid>\Lokale Einstellungen\Anwendungsdaten\Red Gate\Logs\SQL Source Control 1
This is bad and SQL Source Control should offer a configuration/option/preferences feature to set the directory for these log files (and if log files should be created at all!).
14 votes -
Have option to Pause polling of database especially if user wants to use Sql Profiler.
If user wants to run sql profiler, and doesn't want all of this background database activity there should be an option in Red Gate to pause the source control polling it is constanly performing on the linked database.
6 votesWe currently don’t have an option to pause polling in the tool, but you can confiugre an XML file. Please contact support@red-gate.com for details. This file would need to be set for each user.
You could also add a “Column Filter” in SQL Profiler’s Trace Properties’ Events Selection where “Application Name” is “Not like” “Red Gate%.” That should filter out the polling in your trace.
I hope this helps!
-
Save my "Get Latest" choices across SSMS sessions
When I see a list of objects that require my attention via the "Get Latest" tab, I make those choices, which can eventuate in "nothing to do" and carry on working. I don't want to have to re-state those choices each time I start SSMS. Please provide a "Save Choices" facility to support this.
4 votes -
Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error
Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error / warning on a view that uses that column.
2 votesSQL Prompt 5 (expected in Dec 2010 or Jan 2011) will have a feature to find invalid objects. You can get information about current early access releases at http://www.red-gate.com/messageboard/viewforum.php?f=127.
-
Detecting dependencies on object changes
Hi.
Does SQL Source Control detects and informs that a change in an object, for example, a column in a table changed from INT to BIT, will cause a break in other parts of the system like a stored procedure where that table is used?
If yes, how do I do that? If not, I would like to suggest this as a feature.
Thanks.
Jose3 votesPlease see SQL Prompt 5 at: http://www.red-gate.com/MessageBoard/viewtopic.php?t=11980
-
keep databases in sync
We are working with several customer databases on a same version of our program. Is their a possibility to keep them in sync based on 1 source control folder?
1 vote
- Don't see your idea?