588 results found

1. scripting changes

   A while ago I had discussed with Redgate about how to allow sql source control to create scripts for releases to deploy db changes.
   This mostly works, except when there are changes that require more logic to properly handle existing data when certain db object changes are made.

   For instance, adding a new column to a table (that has data in it) that is required, but does not have a default.

   The current way of handling this is to create a custom script for that change at the time of check in. The problem with this is that it requires you to check in all the changes you have made up to that point, and it basically now requires your prod db to go through steps of the versions of the db you checked into source control. I get why you did it this way, but one of the things that we like about the diff tool and script changes, is that it takes the end result of what we checked in, and makes a script to make those changes happen. This method of custom scripts, makes your prod db go through these “versions” that you checked in. We check in code all the time, and this would be several versions. On top of that, when I want to check in the one table change, I may not have everything else in the db done yet (other sp’s or views that use this table) so I can’t really check in the db “version” I just want to check in these table changes. Then on top of that, requrements may change, and make it so that I don’t need this field at all, or something else that makes me not want the prod DB to ever go to this “version” that I checked in. We would rather it use the end result of the objects we have checked in, compare to prod, and make a script to move the differences.

   Well, before I did not have a good idea of what to do about this, but now I do. Not 100% on all the details, but here is the idea.
   Instead of allowing a custom script to move a batch of changes, you allow the user to edit a script for a single change. You may even restrict this further to only table changes, and maybe even further to only changes in the population of the temp table that is created (where it normally copies over the data), as that is normally where this issue happens. Anyway, it generates the sql to make the change, then the user will edit the script to put in the correct data, then the app would compare this against the original, and keep track of the differences, as a search and replace sort of thing. Then when the final script is created, apply the search and replace to the new script for that one object change.

   Or if you could just allow a more generic set of search and replace elements that will be stored and executed when the script is generated.

   For example I am adding a new column with no default that is required, so when the script generates the output, I want to replace this:
   INSERT INTO [dbo].[tmprgxxinstalclienttypelku]([instalclienttypeid], [desctext], [actflag], [lastupdatedtm], [lastupdateusername]) SELECT [instalclienttypeid], [desctext], [actflag], [lastupdatedtm], [lastupdateusername] FROM [dbo].[instalclienttype_lku]

   With this:
   DECLARE @codelst VARCHAR(1000)
   SET @codelst = 'CANS, CON, CRPES, DS, ES, IS, IB, LAS, M, R, USA, LAA, CA, IA, RFA, EEA, RJBA, VC, VCC, FS, GBL, OTH, ESFE, SYN'

   INSERT INTO [dbo].[tmprgxxinstalclienttypelku]
   ([instalclienttypeid], [desctext], [actflag], [lastupdatedtm],
   [lastupdateusername], instalclienttypecode)
   SELECT ictl.[instalclienttypeid], ictl.[desctext], ictl.[actflag], ictl.[lastupdatedtm],
   ictl.[lastupdateusername], ISNULL(psf.value, 'NA')
   FROM [dbo].[instalclienttypelku] as ictl
   LEFT JOIN dbo.parsestringfn(@codelst, ',') AS psf
   ON ictl.instalclienttypeid = psf.order_id

   Not sure exactly how doable that is….

   A while ago I had discussed with Redgate about how to allow sql source control to create scripts for releases to deploy db changes.
   This mostly works, except when there are changes that require more logic to properly handle existing data when certain db object changes are made.

   For instance, adding a new column to a table (that has data in it) that is required, but does not have a default.

   The current way of handling this is to create a custom script for that change at the time of check in. The problem with this is that it requires… 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…)
   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

2. BUG: Sql Source control doesn't maintain WITH (IGNORE_DUP_KEY=ON) on table type

   I have a table type with "(IGNOREDUPKEY=ON)" on it. Sql Source control doesn't preserve this and doesn't see this in the SqlServer database schema on the table type

   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…)
   0 comments  ·  Better Support for Shared Db Dev Model  ·  Edit…  ·  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. Support source controlling SSIS (Integration Services)
   75 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

4. Search Results in Grid Mode

   I still have SSMS Tools Pack installed because of one useful feature that I have not seen in Red-Gate's products. Search Results in Grid Mode. Find all occurrences of your search string in the results in datagrid mode.

   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…)
   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

5. Need override for "Get Latest" and "Commit Changes"

   Normally, I can use RedGate's analysis of what SHOULD be retrievable from source control, or what SHOULD be commitable.

   Under certain circumstances, however, I know better than the tool does. For example, I might want to roll back a set of routines and/or tables to what is in revision control.

   Currently, I have to "jump through hoops" to do this. I have to do multiple steps, some of them crazy ones such as using "undo" counterintuitively (for instance, undoing a "drop" to actually get something that is missing).

   ** Can you give us a screen or a button or selector or something so we can just list everything and select things to perform forced "get latest" (and maybe forced commits)? **

   (This should obviously NOT be the normal mode of operation!)

   There would still need to be some kind of warning (red background?) or other safety system to caution the user against doing this accidentally... and you might want to enable this only for power users.

   Normally, I can use RedGate's analysis of what SHOULD be retrievable from source control, or what SHOULD be commitable.

   Under certain circumstances, however, I know better than the tool does. For example, I might want to roll back a set of routines and/or tables to what is in revision control.

   Currently, I have to "jump through hoops" to do this. I have to do multiple steps, some of them crazy ones such as using "undo" counterintuitively (for instance, undoing a "drop" to actually get something that is missing).

   ** Can you give us a screen or a button or selector… 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

6. Clone db from server to other server

   Clone db from server a tomserver b without genarating a bk file
   Direct bk restor without generating file
   This alow to save time and space

   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…)
   5 comments  ·  History/Log  ·  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. Additional Control of what constitutes a commitable change

   Ignore names generated by SQL Server (such as Primary Keys, Defaults etc)

   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

8. Ability To Script Indexes and Foreign keys as seperate object scripts

   It would be nice to be able to script indexes and foreign key constraints as seperate object scripts as the table columns may not change but may have additional indexes.

   47 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…)
   3 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

9. Prevent false commit

   If I make a change to a proc in management studio editor, then execute the alter. That change is not reflected in object explorer until i do a refresh of object explorer. After the commit SQL source control still show a change and this can result in your change reverting if you press commit again. Therefore sql source control should do a refresh of the committed object in object explorer after every commit.

   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  ·  Better Support for Shared Db Dev Model  ·  Edit…  ·  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. Allow migration script to be added even if I don't want to check in all dependant objects

    When I try to create a migration script on a (not yet checked in) object, and that object has a dependency on another object, then SQL Source Control requires that I add the dependent objects to the migration script and the subsequent checkin. SQL Source control is correct that there's a SQL-level dependency between the two objects, but as a developer, I can tell that it's safe to check in one without the other.

    As a workaround, if I checkin the change first without the migration script, SQL Source Control suggests that I also checkin the dependent objects, but doesn't require it. I can then add a migration script to the already-checked-in change.

    I'd like to avoid using this workaround and be able to directly add a migration script and not include dependent objects.

    When I try to create a migration script on a (not yet checked in) object, and that object has a dependency on another object, then SQL Source Control requires that I add the dependent objects to the migration script and the subsequent checkin. SQL Source control is correct that there's a SQL-level dependency between the two objects, but as a developer, I can tell that it's safe to check in one without the other.

    As a workaround, if I checkin the change first without the migration script, SQL Source Control suggests that I also checkin the dependent objects, but doesn't … 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…)
    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

11. It would be great to use Source Control with Postgres
    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…)
    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. Toast notification displays on wrong monitor

    The "toast" / desktop alert popups by the system tray always seem to show on my primary monitor (where my start menu is). However I often have the app running on my secondary monitor and it would make more sense if the popups displayed on the same monitor as the window where the action triggered the popup

    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  ·  Edit…  ·  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

13. I am allowed to commit previous changes that upon refresh would show newer changes. Can there be a check for this on commit?

    I want a check on commit for all the items I intend to check in to make sure that there is not a newer version available. In the case where there is, I want to be presented with a list of those changes for review before anything is committed.

    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…)
    0 comments  ·  Better Support for Shared Db Dev Model  ·  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

14. Support source control integration with SSMS Solutions/Projects

    We have SSMS solutions that contain only our stored procedures, functions, and views. We have these solutions in Subversion repositories and are currently using TortoiseSVN to manage changes. It would be great if this tool (or a similar one) would support Subversion integration with SSMS much like the existing support for Visual Source Safe.

    It could be much like VisualSVN but for Management Studio instead of Visual Studio.

    24 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…)
    9 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. Exclude/Include filter not working as expected, SLOW performance

    we have 13000 objects in our database.
    12800 of them are all in the dbo schema which contains the standard logic for our product.
    The rest 200 are in the customer specific schema.
    We are not interested in source controlling the standard logic, since we get it from our supplier.
    We need to source control our customer specific changes. For that every change is made in another schema.
    We can perfectly filter the objects out for source control with your tool.
    (so they do not appear on the commit screen). However it is very very slow, that's why I suspected the tool not to filter the objects "server-side"

    I started a profler session and my suspicion was confirmed: the tool is getting all objects and then filters the rows "client-side".
    So first getting 13000 objects to not use 12800 of them. It is also using a lot of memory (after 2 hours we get memory exceptions).
    Could you please change this? Now I'm trying to convince the team to use those tools (I used them on smaller projects).
    But with this speed, they won't agree.
    Here the queries I catched when opening commit tab with filter on:

    SELECT so.name AS TableName,
    ss.name AS TableOwner,
    cc.name AS ConstraintName,
    cc.objectid AS Constraintid,
    cc.isnotforreplication AS NotForReplication,
    cc.isnottrusted AS WithNoCheck,
    cc.isdisabled AS Disabled,
    sc.name AS ColumnName,
    cc.parentcolumnid AS colid,
    cc.definition AS Text,
    CONVERT(bit, CASE cc.issystemnamed WHEN 1 THEN 1 ELSE 0 END) As issystemnamed
    FROM sys.checkconstraints cc WITH (NOLOCK)
    INNER JOIN sys.objects so WITH (NOLOCK) ON so.objectid=cc.parentobjectid
    LEFT JOIN sys.schemas ss WITH (NOLOCK) ON ss.schemaid=so.schemaid
    LEFT JOIN sys.columns sc WITH (NOLOCK) ON sc.columnid=cc.parentcolumnid AND sc.objectid=cc.parentobjectid
    ORDER BY so.name, cc.name

    SELECT s.name AS ProcedureName,
    p.name AS ProcedureOwner,
    ss.name AS SchemaName,
    s.objectid AS id,
    CONVERT(bit, ISNULL(sm.isschemabound,0)) AS SchemaBound,
    CONVERT(bit, ISNULL(sm.usesansinulls, 0)) AS AnsiNulls,
    CONVERT(bit, ISNULL(sm.usesquotedidentifier,0)) AS QuotedIdentifier,
    s.type AS ProcedureType,
    am.assemblyclass,
    am.assemblymethod,
    CASE WHEN am.nullonnullinput IS NULL THEN sm.nullonnullinput ELSE am.nullonnullinput END AS nullonnullinput,
    COALESCE(p2.name,p3.name) AS executeas,
    CONVERT(bit, COALESCE(
    CASE WHEN am.executeasprincipalid = -2 THEN 1 ELSE 0 END,
    CASE WHEN sm.executeasprincipalid = -2 THEN 1 ELSE 0 END)) AS executeasowner,
    a.name AS assembly,
    case when sm.definition is null THEN CONVERT(bit, 1) else CONVERT(bit, 0) END AS encrypted

    FROM sys.objects s WITH (NOLOCK)
    LEFT JOIN sys.databaseprincipals p WITH (NOLOCK) ON p.principalid=s.principalid
    LEFT JOIN sys.schemas ss WITH (NOLOCK) ON ss.schemaid=s.schemaid
    LEFT JOIN sys.sqlmodules sm WITH (NOLOCK) ON sm.objectid=s.objectid
    LEFT JOIN sys.assemblymodules am WITH (NOLOCK) ON am.objectid=s.objectid
    LEFT JOIN sys.assemblies a WITH (NOLOCK) ON a.assemblyid=am.assemblyid
    LEFT JOIN sys.databaseprincipals p2 WITH (NOLOCK) ON p2.principalid=am.executeasprincipalid
    LEFT JOIN sys.databaseprincipals p3 WITH (NOLOCK) ON p3.principalid=sm.executeasprincipalid
    WHERE s.type IN (N'P', N'PC') AND
    (CAST(CASE WHEN s.ismsshipped = 1 then 1
    WHEN (SELECT majorid FROM sys.extendedproperties WHERE
    majorid = s.objectid AND minorid = 0 AND class = 1 AND
    name = N'microsoftdatabasetools_support') IS NOT NULL THEN 1
    ELSE 0
    END AS bit)=0)

    we have 13000 objects in our database.
    12800 of them are all in the dbo schema which contains the standard logic for our product.
    The rest 200 are in the customer specific schema.
    We are not interested in source controlling the standard logic, since we get it from our supplier.
    We need to source control our customer specific changes. For that every change is made in another schema.
    We can perfectly filter the objects out for source control with your tool.
    (so they do not appear on the commit screen). However it is very very slow, that's why I suspected… 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

16. sql source control window resizing

    When resizing SSMS, the SQL Source Control window does not resize correctly. Some UI elements appear on top of others. Not a major issue but is likely not working as expected.

    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

17. run stored procedure before/after commit before/after get

    Make a function where you could setup a before/after Commit and before/after Get stored procedure which will be executed automatically.

    In my case I backup the Database diagrams to table with a stored procedure. I would like to run it before every commit. The restore sp could be run after a get

    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…)
    0 comments  ·  Edit…  ·  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

18. Please make your software more tolerant of slow internet connections with long latencies - like satellite connections.

    Please make your software more tolerant of slow internet connections with long latencies - like satellite connections.

    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…)
    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

19. Allow the re-ordering of columns via drag and drop in the commit changes grid
    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  ·  Edit…  ·  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. SQL Source Control Configuring Data Compare Options

    Make it possible for us to configure how SQL Source Control does its data compare. There are some great settings that work within SQL Data Compare 10 that allow a user to configure how data in each table is compared between data sources. Currently the main feature I want is to allow the selection of table columns to actually compare (i.e. one column is an identity field which isn't always the same).

    34 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  ·  Static Data  ·  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