588 results found

1. Rename of objects containing [ not working

   I inadvertently put [] into lots of my column names and this broke RedGate. Google found something that might help explain:

   I eventually fixed it by dropping the tables, which caused RedGate to run a create table statement rather than sp_rename.

   https://connect.microsoft.com/SQLServer/feedback/details/509970/object-id-does-not-handle-object-names-with-square-brackets?wa=wsignin1.0

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   under review  ·  AdminRedgate Administrator (Admin, Redgate) responded

   Hello,

   What do you mean by “this broke RedGate.” How exactly did it break? Did you get any error messages?

   Could you email Support@Red-Gate.com the table script that had the [] in the column names and what you changed it to? This will help us to reproduce the problem.

   Thank you!

2. Bug: commit changes showing no changes

   I've just had a stored procedure that I haven't modified come up as having changes to commit. The Previous and Next buttons are disabled as though there are no differences and I can't see any differences. Yet it repeatedly comes up as an object with changes. Huh?

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. fails on more than 200 objects

   I have about 800 objects. I can only add 100 to 200 objects at one time. If I try to add too many it fails.

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminRedgate Administrator (Admin, Redgate) responded

   This sounds like a problem we’ve seen before. Do you have Microsoft Security Essentials installed? If so, this could cause a problem when committing a large number of objects, which is usually the case when first committing an existing database to source control. Your workaround of doing a smaller partial commit seems to fit this expected behaviour.

   To get around this, please configure Security Essentials to exclude LOCALAPPDATA\Red Gate\SQL Source Control 0\ from live protection.

4. Bug: drop database and then recreate causes conflicts

   I have a database managed in SVN. On my development machine I deleted it and then recreated it with the same name. RedGate maintained the link to SVN despite the drop (ok, doesn't bother me) but it then marked every object in the database as being in conflict

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminRedgate Administrator (Admin, Redgate) responded

   This is a known issue. I’m glad you’re ok that the link to SVN is maintained. The problem is the underlying working folder is out of date.

   WORKAROUND:
   Option 1)
   On the setup tab, unlink the db from source control. If you still want to manage the db in SVN, then relink.

   Option 2)
   Use the Commit or Get Latest tabs to decide if you want to keep the version in your db and commit it or take the version that is in source control. After making a decision using the radio buttons in the differences pane at the bottom of these tabs, you must then click the Commit and/or Get Latest buttons to actually perform the action.

   HINT: You can select multiple rows by selecting 1 row and then hitting Ctrl-A or select the top row and then hold the shift key down and select the last row with your mouse. The decision to Keep Mine or Take Theirs will then apply to all the hightlighted rows.

   I hope this helps!

   This is a known issue. I’m glad you’re ok that the link to SVN is maintained. The problem is the underlying working folder is out of date.

   WORKAROUND:
   Option 1)
   On the setup tab, unlink the db from source control. If you still want to manage the db in SVN, then relink.

   Option 2)
   Use the Commit or Get Latest tabs to decide if you want to keep the version in your db and commit it or take the version that is in source control. After making a decision using the radio buttons in the differences pane at the bottom of these tabs, you must then click the Commit and/or Get Latest buttons to actually perform the action.

   HINT: You can select multiple rows by selecting 1 row and then hitting Ctrl-A or select the top row and then hold the shift key down and select the… more

5. No whitespace in file/directory names

   I want an option for all scripts and directories to have no whitespace in their file names. For example "Database Triggers" would be "DatabaseTriggers". This makes working manually with the scripts from the command line much easier.

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Foreign Keys scripted in different order each time table is edited

   I've found that frequently when I change something about a table (add a column for example), then when I do a diff of that table from SQL Source Control before checking in, the diff shows that the order of the Foreign Keys has changed. For example, it might list FK1, the FK2, and then FK3 on the left side of the diff, and FK2, FK3, and then FK1 on the right side of the diff. The definitions of the foreign keys have not changed, just the order in which they're scripted. So, this is not a critical issue, but it makes it seem that more has changed than actually has. Perhaps SQL Source Control could sort them or something so that they were always in the same order?

   I've found that frequently when I change something about a table (add a column for example), then when I do a diff of that table from SQL Source Control before checking in, the diff shows that the order of the Foreign Keys has changed. For example, it might list FK1, the FK2, and then FK3 on the left side of the diff, and FK2, FK3, and then FK1 on the right side of the diff. The definitions of the foreign keys have not changed, just the order in which they're scripted. So, this is… more

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. SVN Lock mode by default : Impossible to commit

   We use SVN with the config ". = svn:needs-lock=*" to automatically lock files on all our repositories (parameter in the config file of SVN on the computer of the developer).
   So a source file can be modified by only one developer at a time.
   It looks it’s a problem with SQL Source Control because the files in the local directory of the working databases are in read only.
   When I commit a change, I have the message “Do not have permissions to modify the file C:\Documents and settings...\Stored Procedures\dbo.PS_select.sql”.
   The commit is stopped.
   Of course, we would like to stay in lock mode with Subversion...

   We use SVN with the config ". = svn:needs-lock=*" to automatically lock files on all our repositories (parameter in the config file of SVN on the computer of the developer).
   So a source file can be modified by only one developer at a time.
   It looks it’s a problem with SQL Source Control because the files in the local directory of the working databases are in read only.
   When I commit a change, I have the message “Do not have permissions to modify the file C:\Documents and settings...\Stored Procedures\dbo.PS_select.sql”.
   The commit is stopped.
   Of course, we would like to… more

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminRedgate Administrator (Admin, Redgate) responded

   We currently do not support lock or exclusive checkouts (lock-modify-unlock model). We are supporting a copy-modify-merge model.

   In order to use SQL Source Control, you’ll need to use this model for now until we implement locking/exclusive checkouts in a future release.

   To do this, undo the change to the Subversion configuration file, remove the needs-lock property from any file in the repository, manually svn update the WorkingBases directory, unlink and then relink the db in SSMS.

   Depending on your OS, related files can be found in:
   C:\Documents and Settings\\Local Settings\Application Data\Red Gate\Logs\SQL Source Control 0
   or
   C:\Users\\AppData\Local\Red Gate\Logs\SQL Source Control 0

   1) Right click on WorkingBases\\Stored Procedures\dbo.PS_select.sql
   and select Properties
   *You can find the which corresponds to your db by looking in the LinkedDatabases.xml file.
   2) Select the “Subversion” tab at the top
   3) Click the “Properties…” button near the bottom
   4) Is there a svn:needs-lock property? If so, remove it.
   5) Click OK to close the SVN properties window
   6) Click OK to close the file properties window
   7) Right click again and commit the change to Subversion (this is just committing the change that a lock is not needed on that file)

   Now, you should be able to commit the file from SQL Source Control with out getting this permission error. Please let us know if you still have any problems.

   We currently do not support lock or exclusive checkouts (lock-modify-unlock model). We are supporting a copy-modify-merge model.

   In order to use SQL Source Control, you’ll need to use this model for now until we implement locking/exclusive checkouts in a future release.

   To do this, undo the change to the Subversion configuration file, remove the needs-lock property from any file in the repository, manually svn update the WorkingBases directory, unlink and then relink the db in SSMS.

   Depending on your OS, related files can be found in:
   C:\Documents and Settings\\Local Settings\Application Data\Red Gate\Logs\SQL Source Control 0
   or
   C:\Users\\AppData\Local\Red Gate\Logs\SQL Source Control 0

   1) Right click on WorkingBases\\Stored Procedures\dbo.PS_select.sql
   and select Properties
   *You can find the which corresponds to your db by looking in the LinkedDatabases.xml file.
   2) Select the “Subversion” tab at the top
   3) Click the “Properties…” button near the bottom
   4) Is there a svn:needs-lock property?… more

8. TFS integration should allow you to select which workspace to use

   TFS integrations really needs you to specify which workspace you are working with. This does wrong right from the start - when I try to link a database to TFS, it asks for the source URI and data folder, but it will only accept data folders already checked in, not that I have created in my workspace.

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   4 comments  ·  Initial Setup  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Ability to generate changes to file locally so we can manually commit with other changes

   I would like it to update the files but not commit as I generally like to commit a set of related changes together.
   i.e. chaning the database schema and an on screen form to display new columns, they should appear as one commit. Currently I have to do two seperate commits

   12 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Open object's script file from Source Control

    When I link a database to source control (TFS), and then open an object from the object explorer I would have expected the file script in source control to open in the management studio window. Instead it simply scripts the object from the database server. I don't think this is really sql source control, it seems more like a polished deployment engine.

    When a database is linked to a TFS source location, it should open the TFS file no matter what you do in the object explorer.

    9 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Bug? Function type detection seems unreliable

    I'm having problems retrieving a recursive table-valued function from SVN so I tried to do it manually in stages which didn't work because SQL Source Control kept attempting to drop the function and then recreate it.

    The steps I followed were:
    1. Refresh the get latest tab and copy the function from the differences window.
    2. Paste that SQL script into SSMS
    3. Remove the part of the function that does the recursion (the second half of a UNION so the return type is still the same)
    4. Execute the script to create the object
    5. Get latest from SQL Version Control
    6. Get the following message: "The function [dbo].[fnunititemcosttab] has changed its type. It must be dropped and recreated."
    7. The get latest operation then fails as it is trying to create a function that refers to itself but doesn't exist.

    After step 6 I can take the script from step 1, change the CREATE to an ALTER and execute the script in SSMS and it works so it was not necessary for SQL Source Control to drop and recreate the function.

    I'm having problems retrieving a recursive table-valued function from SVN so I tried to do it manually in stages which didn't work because SQL Source Control kept attempting to drop the function and then recreate it.

    The steps I followed were:
    1. Refresh the get latest tab and copy the function from the differences window.
    2. Paste that SQL script into SSMS
    3. Remove the part of the function that does the recursion (the second half of a UNION so the return type is still the same)
    4. Execute the script to create the object
    5. Get latest from SQL… more

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Select first difference automatically

    On the Commit Changes tab, please make it show the first difference in the compare pane.

    This is particularly helpful where object permissions are changed often, as it becomes a pain to review a list of otherwise unchanged objects that just have new GRANTs on them. An alternative would be to show permissions as a separate entry to the object.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminRedgate Administrator (Admin, Redgate) responded

    Did you know? The “Next” button at the top of the diff pane will jump to the next difference in the script. This may help you jump right to where the first change is for now.

13. Make the SVN URL case insensitive

    It would be easier if the SVN URL that I entered was case insensitive.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminRedgate Administrator (Admin, Redgate) responded

    In a future version, we hope to have the ability to browse a repository so that it doesn’t have to be manually entered. This topic is listed at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/539431-browse-to-a-svn-repository-instead-of-manually-typ.

14. Square brackets

    Please add an option to script the database objects with square brackets around the object names. The Microsoft Management Studio Scripts include Brackets around the object names when they are scripted. So, if an objects is scripted from SSMS then run against the database it show up as being different in Source Control because the brackets were included in the SSMS script. Of course, you can manually remove the brackets before running the script but this will be cumbersome. I know that using the file that has been checked into SVN is another work around but we all know that developers often script the databas objects from SSMS then make their modifications. Unfortunately, SSMS does not offer an option to exclude these brackets.

    Please add an option to script the database objects with square brackets around the object names. The Microsoft Management Studio Scripts include Brackets around the object names when they are scripted. So, if an objects is scripted from SSMS then run against the database it show up as being different in Source Control because the brackets were included in the SSMS script. Of course, you can manually remove the brackets before running the script but this will be cumbersome. I know that using the file that has been checked into SVN is another work around but we all know that… more

    8 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Support source controlling Reporting Services (SSRS)
    12 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Indication of current server / database in source control pane would be useful

    When you select a database in the object explorer tree, then click on the link to existing repository in the red gate source control pane, the highlighted database isn't very obviously highlighted (dependin on your colour scheme) because the object explorer no longer has focus.

    In addition, with multiple databases, it may not be obvious which server the selected database is on.

    With the link to subversion repository dialog open, it is difficult to check which database is selected - a problem if you have to link a number of databases on a number of servers, and have lost track which one you are up to. Adding the server name to the red-gate pane (along with the DB Name) would avoid this issue.

    Similarly, once linked, the DB name is shown in the red-gate pane, but not the server name - so again it is near enough to impossible to see which db (on which server) you're operating with if you have multiple DBs with the same name on different servers.

    When you select a database in the object explorer tree, then click on the link to existing repository in the red gate source control pane, the highlighted database isn't very obviously highlighted (dependin on your colour scheme) because the object explorer no longer has focus.

    In addition, with multiple databases, it may not be obvious which server the selected database is on.

    With the link to subversion repository dialog open, it is difficult to check which database is selected - a problem if you have to link a number of databases on a number of servers, and have lost track… more

    27 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    7 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Error during applying changes to live DB

    The error should consist more detailed data. Like from which procedure, function or table such error was thrown. I assume my error has nothing to do with SQL Source Control, it's my DB ;)

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    under review  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Are you still having this issue?

18. Support SSMSE (SQL Server Management Studio Express)

    I can't install because I am forced to cancel the installation. It refuses to install because it says SSMS is required... while I have SSMSE installed.

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminRedgate Administrator (Admin, Redgate) responded

    We currently support SSMS 2005,2008 , and 2008 R2 connecting to SQL Server 2005, 2008, or 2008 R2 databases. (We currently do NOT support any SSMS Express editions.)

19. Get to an object's properties from the "Commit Changes" tab

    It’d be cool if from the “Commit Changes” tab you could get to the objects properties or at least get it selected in the Object Explorer, maybe from a double / right click?

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Link to TortoiseSVN Repo Browser

    Can we have a link to TortoiseSVN so we can review the repository from SSMS please?

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close