DLM Automation

DLM Automation works with your CI server and release management system, so you test, build, and release your database alongside your application code. To find out more please visit our website.

We need your help to shape DLM Automation into a great product that helps database professionals. We’d love to hear about your feature ideas and suggestions, so please enter them below.

If you have any questions or need help with DLM Automation, please visit our support forums.

How can we improve DLM Automation?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Deploy static data in commit order

    Static data should be deployed in commit order rather than at the end of the deployment script.

    It is currently impossible to write a migration script which depends on static data as the static data will not exist at the point the migration script runs. The migration script can't insert the static data it needs as deployment will then fail later when inserting the new static data which now already exists.

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Expose SQL Multiscript functionality via DLM Automation cmdlet

      I need to execute Use-DlmDatabaseRelease against hundreds of databases per server (times a dozen or more servers). None of the Powershell multithreading approaches I've found matches the speed of SQL Multiscript. It would be a huge performance boost to be able to feed a Use-... statement or a generic script block to a Multiscript cmdlet for swift parallel handling.

      0 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Change DLM licencing

        Please re-visit and change your stupid, ill thought, money grabbing licencing on DLM Automation.

        Having licenced SQL CI coupled and individual SQL Source Control licences all with maintenance on advice of Redgate sales we've been merrily using this until now. Needing to buy additional licences for SQL Source Control we are now hit with an eye watering quote to have to upgrade from SQL CI to DLM automation.

        Apart from the fact that the product recommended to us originally has been superseded twice with no contact from Redgate, there has been a sneaky shift to a per user licence fro…

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
        • Add database connection for database testing in VSTS extension

          Currently if you use the VSTS extension you can't ask it to run Tests against a database connection. If you allowed this then it would provide more flexibility.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow online index operations

            Allow online=on option for index creation during deployment process. This is a particular painful problem when deploying to an azure sql database where they have transaction log limits.

            39 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
            • Create target database

              "DLM Automation works with your CI server and release management system, so you test, build, and release your database alongside your application code." Unfortunately, DLM only allows for the release of _updates_ to existing databases -- suppose the target database doesn't yet exist? Deploying a NuGet package ought to allow for the possibility of initializing a new database.

              10 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • Add the option to skip delete operations

                It would be good if you could skip delete operations when deploying database changes automatically. This means if we update our application code and database changes then old versions of the application code can continue to use the old database functionality.

                2 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Support semantic versioning

                  NuGet 3.5 will support semantic versioning and it would be nice if DLM Automation could implement it too.

                  7 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Disable check constraints

                    When importing static data on a sync operation, I'd like the option to disable (and re-enable afterwards) check constraints.

                    At the moment the only option I have is to ignore them which means my CI database is not built correctly

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
                    • Linux Compatility

                      Given that no GUI is required with Release and dotnet core is out, has this option been considered? Most deployment tools are Linux based and Octopus is limited in usefulness, or at least our application has outgrown it.

                      7 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow the Sync cmdlet (or similar) to generate an upgrade script without additional powershell

                        Allow the Sync cmdlet (or similar) to generate an upgrade script without additional powershell

                        15 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
                        • As an build engineer I'd like to be able to override the package version number in the TeamCity plugin

                          We are currently using GitFlow for a small POC and have hit an issue as we are unable to use a NuGet safe version number for our package name without going through some hoops.

                          Adding support for an optional version number field in the SQL CI TeamCity plugin would be a nice addition and allow us to drive this from another variable.

                          5 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →

                            Thanks for the suggestion Matt. I’ve come across similar requirements myself; such as wanting to keep version numbers in synch between app code and db projects in TeamCity.

                          • Improve error handling when database has syntax errors

                            When first starting to use SQL Release, it's likely that the target database may have a few syntax errors in it. For example, it could have a sproc that references a table that doesn't exist. Alternatively, the TempDB that SQL Release is using might not support a feature that the target database uses, or the real SQL Database might not support a feature that the target database is using. In any of these cases, the error returned by New-DatabaseRelease is very unhelpful:

                            new-databaserelease : SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error.
                            SQLCompare.exe produced…

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                              Thanks for the suggestion, we know we can do a lot better at surfacing useful and actionable detail on the cause of the error.

                            • less verbose logging

                              Currently the build log contains the status of each object in the database. In large databases (Mine has 22K objects) this creates a very long log file that is difficult to parse through.

                              2 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →

                                Thanks for the suggestion. Currently the architecture of DLM Automation means that we are pretty much restricted to an ‘all or nothing’ approach to log verbosity.

                              • allow passing filters to SQLCI

                                We have a shared database environment that is usesdby many applications that have different release schedules. We need a way to filter to a specific set of objects (i.e. schema, and/or object name)

                                3 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add invalid objects test

                                  Like the test in SQL Prompt.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SQLCompareOptions switch should support SQL Data Compare options.

                                    The SQLCompareOptions switch supports only commandline options from SQL Compare but not from SQL Data Compare that are used for static data compare.

                                    We need the option "Force binary collation" for detect case-sensitively changes on a case-insensitive collation.

                                    62 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      3 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                      This is non-trivial as we currently use static data through SQL Compare within DLMA, which does not have the same option range as SQL Data Compare.

                                      We do now ignore timestamp columns in static data tables as of DLMA 2.0.8, so timestamp columns should no longer block other static data from deployment – please email Support if this is still not working for you.

                                    • As an deployment engineer I'd like to run environment specific scripts during deployment

                                      Say we have scenarios where we have client machine configuration stored against machine names. When we deploy to DEV environment, these machines are different to TEST and we need a way to reseed the configuration data for the specific environment.

                                      Having first class support for PreDeploy / PostDeploy scripts which could then be named using Environments (A.DEV.sql, A.TEST.sql) would be a nice feature - Especially if coupled with SQL Source Control.

                                      We've worked around this at the moment but would love this OOTB

                                      16 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        2 comments  ·  SQL CI  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ability to exclude static table columns when deploying static data

                                        Currently I have option to include or exclude data compare using -IgnoreStaticData switch (New-DatabaseRelease cmdlet).

                                        But since part of my static data tables columns are environment based (in each environment dev/qa/prod I got different url)
                                        I have to exclude columns.

                                        Via Data Compare commad line I am using /Project switch which contains the exclude columns definitions.
                                        (Another method that exists is IncludeColumns and /ExcludeColumns switches)

                                        I need this options in order to start using SQL Release, otherwise static data deployment will make undesired changes.

                                        14 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Be able to generate script for azure and non azure

                                          I could be great to be able to generate both the script for azure and non azure at the same time.
                                          A scenario where I need it: I have 3 environments: one non azure and 2 azure and I need to deploy on it by using the octopus.

                                          2 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          DLM Automation

                                          Feedback and Knowledge Base