Settings and activity

  1. 10 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  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Ji supported this idea  · 
  2. 7 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 →
    Ji shared this idea  · 
  3. 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
    Ji commented  · 

    My experience has been that DLM only "spots" that the schema is the same when the database names are identical. Thus they must be on different instances. This is despite the Redgate demo assertions that the matching databases may have different names on the same instance.

  4. 8 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  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
  5. 10 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 →
    An error occurred while saving the comment
    Ji commented  · 

    This has been raised in more issues. I believe there are considerations mentioned by Redgate to expand on this in due course

    Ji supported this idea  · 
  6. 633 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    30 comments  ·  SQL Source Control » Static Data  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Kendra responded

    Hi everyone. I have merged some User Voice items on this topic of “filtered” static data, as there was significant overlap. I want to share our current guidance on handling scenarios where you need to version a subset of the columns and/or rows in the table.

    With SQL Source control, the best option at this point is to use a post-deployment script for this purpose.

    SQL Source Control introduced pre- and post- scripts in v6.3.

    A post-deployment script gives you a good amount of flexibility over exactly which rows or columns of data you want to include in your project. Example post-deployment scripts for static data are here: https://documentation.red-gate.com/soc7/common-tasks/working-with-pre-post-deployment-scripts/static-data

    If you make heavy use of Static Data, we have stronger support for this in SQL Change Automation.

    SQL Change Automation:

    • Supports column filtered static data tables in the SCA plugin in SSMS
    • Supports multiple post-deployment scripts, in case there is…
    Ji supported this idea  · 
  7. 35 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 →
    Ji supported this idea  · 
  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…)
    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
    Ji commented  · 

    This whole business needs thorough spelling out. I have never seen it working despite having databases on same or different server instances with what amounts to "same" schema. Is it because the db name may be different?

  9. 6 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 » Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ji commented  · 

    I notice that in the current release that there is a help link detailing how to set the notification time window by editing the UserSettings.config file.
    However one would have thought that the moderator of this site would have answered this.
    Whilst this is a good improvement, there are still many issues unanswered regarding user feedback around email notifications. For example there seems to be no facility to set individual recipient/s on a per server and or individual database

    Ji shared this idea  · 
  10. 35 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 →
    Ji supported this idea  · 
  11. 13 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 » Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    Ji supported this idea  · 
  12. 23 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 » Email Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    Ji supported this idea  · 
  13. 7 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 →
    Ji supported this idea  · 
  14. 3 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  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Ji supported this idea  · 
  15. 8 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  ·  SQL Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    Ji supported this idea  ·