Settings and activity

  1. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    Are you using DLM Automation (previously called SQL CI and SQL Release)?

    If so you can pass information about a schema version to DLM Dashboard when you build a database package. DLM Automation produces a package representing the state of a database, which along with a version number can be passed into DLM Dashboard via a web API. Typically we'd expect this would be during your CI process (thus in a CI server), rather than at release time in Octopus. That means that DLM Dashboard would be able to 'spot' that schema version when deployed to any subsequent environments.

    DLM Automation: http://www.red-gate.com/products/dlm/dlm-automation/

    Documentation: http://documentation.red-gate.com/display/DDB1/Investigating+schema+changes#Investigatingschemachanges-CI_Integration

    Commandlet reference: https://documentation.red-gate.com/display/SR1/Publish-DlmDatabasePackage

    What the API can't currently do is mark an individual deployment as approved. We have a request open for that on https://redgate.uservoice.com/forums/256011-dlm-dashboard/suggestions/7934943-automatically-approve-and-mark-octopus-deploy-chan

  2. 201 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  21 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    Interested to hear more about your workflow with branching. When you're working on branches do you have multiple copies of the database, each one linked to a branch? Or do you unlink/link the same database to multiple branches depending on what you're working on?

  3. 45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    You may be interested in our product SQL Compare. This lets you compare databases, see the differences between them and then synchronise them.

    http://www.red-gate.com/products/sql-development/sql-compare/

    It would be great if you could launch SQL Compare from the dashboard though

  4. 34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    You might find our product SQL Source Control, or ReadyRoll are better suited for what you're trying to do here. They link database to version control systems like git or TFS. You have much finer grain control over what you're committing, so you could commit individual objects, rather than all changes.

    http://www.red-gate.com/products/sql-development/sql-source-control/
    http://www.red-gate.com/products/sql-development/readyroll/

  5. 20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 
  6. 33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    The use case for migrations mentioned here isn't something we ever intended SQL Source Control to be able to do. Our intention is that all deployment functionality exists in SQL Compare. However as a side effect of the old migrations feature was that SQL Source Control could do this. You're right in that the new migrations feature doesn't let you do this.

    If you can drop me a note on jonathan.hickford [at] red-gate.com I'd love to find out a bit more and see if we can help.

  7. 13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →

    When you have given a schema version a name in DLM Dashboard it will spot all other databases that have the same schema, and automatically label them with that name. If any databases change then that should be picked up as drift.

    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    When you have given a schema version a name in DLM Dashboard it will spot all other databases that have the same schema, and automatically label them with that name. If any databases change then that should be picked up as drift.

    Is this not happening in this case? That could be a bug on our side, or perhaps there are differences between each database? The DLM Dashboard ignores differences users/roles/permissions/keys/certs.

  8. 13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →

    The dashboard spots when two databases have the same schema. If you name it on one database then the dashboard should automatically give the name to your second database. If it’s not doing so then you may have uncovered a bug in the tool – please could you email dlmdashboardsupport@red-gate.com and we can work out what’s happening?The dashboard spots when two databases have the same schema. If you name it on one database

    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    The dashboard spots when two databases have the same schema. If you name it on one database then the dashboard should automatically give the name to your second database. If it's not doing so then you may have uncovered a bug in the tool - please could you email dlmdashboardsupport@red-gate.com and we can work out what's happening?

  9. 30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  DLM Dashboard » History  ·  Flag idea as inappropriate…  ·  Admin →

    We’re considering how to make the data we have more available and extensible, so that you can use it elsewhere. Please add any comments you have to this thread to continue the discussion

    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    We're considering how to make the data we have more available and extensible, so that you can use it elsewhere.

    Would a SQL database be your preferred integration method? Or would a REST API be more useful?

  10. 25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  DLM Dashboard » Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    Hi Alan - the alert emails should say at the bottom who was involved in the changes. Or is it that you want to see the names of who made the change next to each object?

    We've not done that in the email (if you have many changes it's pretty cluttered), but if you click through to the dashboard and view the change you'll see the information.

  11. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →

    We’re planning to improve the way you can organize database later this year. The current projects mechanism is limited. Please do leave us any comments with your thoughts on how we can make this better

    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    We want to improve our projects concept - probably later this year.

    The way we intended projects to be used is that you'd put one logical database into each project. In Justin's example D1, D2, D3 would all be in their own projects. That way you can see if the version of D1 that is in Dev is the same as the version of D1 that is in Prod. The name projects is pretty misleading (our bad!)

    However using projects like this doesn't help you group your databases together into groups that make sense within your organization.

  12. 158 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Jonathan Hickford commented  · 

    Thanks Justin,

    How would you imagine this working? For example would you want to be comparing a specific revision (or branch/tag) with your production environment?

    Jonathan Hickford shared this idea  · 
  13. 34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  · 
  14. 21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard » Version Control  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  · 
  15. 179 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  · 
  16. 34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  · 
  17. 30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  · 
  18. 142 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  DLM Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Jonathan Hickford shared this idea  ·