DbUp

What's Changed

• Re-added NoOpUpgradeLog by @droyad in https://github.com/DbUp/DbUp/pull/800

Full Changelog: https://github.com/DbUp/DbUp/compare/6.0.0-beta.108...6.0.0-beta.146

What's Changed

• Docs Grammer: DBA's => DBAs by @arialdomartini in https://github.com/DbUp/DbUp/pull/768
• Handle null in addition to DBNull values when reading from IDataReader by @dterziev in https://github.com/DbUp/DbUp/pull/778
• Expose GetCurrentCommandTextFromBuffer by @epenet in https://github.com/DbUp/DbUp/pull/790

New Contributors

• @arialdomartini made their first contribution in https://github.com/DbUp/DbUp/pull/768
• @dterziev made their first contribution in https://github.com/DbUp/DbUp/pull/778
• @epenet made their first contribution in https://github.com/DbUp/DbUp/pull/790

Full Changelog: https://github.com/DbUp/DbUp/compare/5.0.76...5.0.87

What's Changed

• Connection manager transaction command timeout support by @aiyyo in https://github.com/DbUp/DbUp/pull/591

New Contributors

• @aiyyo made their first contribution in https://github.com/DbUp/DbUp/pull/591

Full Changelog: https://github.com/DbUp/DbUp/compare/6.0.0-beta.44...6.0.0-beta.73

Breaking Changes

• Drop support for netstandard1.3 by @droyad in https://github.com/DbUp/DbUp/pull/774
• Only support netstandard2.0 by @droyad in https://github.com/DbUp/DbUp/pull/784
• Update dependencies by @droyad in https://github.com/DbUp/DbUp/pull/787
• Replace LibLog with Microsoft's logging abstractions by @droyad in https://github.com/DbUp/DbUp/pull/788
• Script executor wont journal runalways scripts by @DamianMac in https://github.com/DbUp/DbUp/pull/791

Other Changes

• DBA's => DBAs by @arialdomartini in https://github.com/DbUp/DbUp/pull/768

New Contributors

• @arialdomartini made their first contribution in https://github.com/DbUp/DbUp/pull/768

Full Changelog: https://github.com/DbUp/DbUp/compare/5.0.76...6.0.0-beta.44

What's Changed

• Bump xunit from 2.5.0 to 2.5.3 by @dependabot in https://github.com/DbUp/DbUp/pull/741
• Split Workflows by @mjauernig in https://github.com/DbUp/DbUp/pull/726
• #710 Add note about DbUpX into readme by @mjauernig in https://github.com/DbUp/DbUp/pull/736
• Closes #678 by @mjauernig in https://github.com/DbUp/DbUp/pull/738
• Fix casing of WithPreprocessor extension method by @ihorwill in https://github.com/DbUp/DbUp/pull/740
• Moved github action step Test Report into separate workflow by @mjauernig in https://github.com/DbUp/DbUp/pull/753

New Contributors

• @dependabot made their first contribution in https://github.com/DbUp/DbUp/pull/741
• @ihorwill made their first contribution in https://github.com/DbUp/DbUp/pull/740

Full Changelog: https://github.com/DbUp/DbUp/compare/5.0.37...5.0.76

What's Changed

• Fix projectUrl for in nuspec by @skovsende in https://github.com/DbUp/DbUp/pull/676
• Cleanup samples csprojs by @sungam3r in https://github.com/DbUp/DbUp/pull/670
• Change readme by @sungam3r in https://github.com/DbUp/DbUp/pull/669
• Update preprocessors.md by @frecks in https://github.com/DbUp/DbUp/pull/572
• Update MySql.Data to 8.0.33 by @bomehlsen in https://github.com/DbUp/DbUp/pull/693
• Fix for issue/bug #691 (making firebird integration work again) by @Jeern in https://github.com/DbUp/DbUp/pull/692
• Dbup tests by @mjauernig in https://github.com/DbUp/DbUp/pull/695
• Ignore some local files by @sungam3r in https://github.com/DbUp/DbUp/pull/668
• Add Readme into packages + csprojs cleanup by @sungam3r in https://github.com/DbUp/DbUp/pull/671
• Upgrade Microsoft.Data.SqlClient from 5.0.1 to 5.1.1 by @sungam3r in https://github.com/DbUp/DbUp/pull/697
• Update README by @mjauernig in https://github.com/DbUp/DbUp/pull/704
• Cleanup gitignore by @sungam3r in https://github.com/DbUp/DbUp/pull/706
• Bump packages for tests/samples by @sungam3r in https://github.com/DbUp/DbUp/pull/707
• Fix InvalidCastException on DB existence check (CockroachDb) by @webcoyote in https://github.com/DbUp/DbUp/pull/644
• fix OracleScriptExecutor exception logs by @Orkad in https://github.com/DbUp/DbUp/pull/542
• Pass script options to embeddedScriptProvider by @fire-birdie in https://github.com/DbUp/DbUp/pull/528
• Make DoesTableExist virtual by @ithielnor in https://github.com/DbUp/DbUp/pull/608
• Split CI Workflow in two different Workflows. One for CI and one for release by @mjauernig in https://github.com/DbUp/DbUp/pull/694
• Bump Oracle.ManagedDataAccess.Core to 2.19.200 by @sungam3r in https://github.com/DbUp/DbUp/pull/711
• Add badges for issues into README by @sungam3r in https://github.com/DbUp/DbUp/pull/712
• Updated Readme with explanation of delimiters in firebird scripts by @Jeern in https://github.com/DbUp/DbUp/pull/716
• Firebird Package updated 6.0.0 -> 9.1.1 by @Jeern in https://github.com/DbUp/DbUp/pull/715
• Add support for positional parameters and disabling SQL Rewriting when using PostgreSQL by @PressXtoChris in https://github.com/DbUp/DbUp/pull/629
• chore (Project): Whitespace and empty line tidy . Roslynator RCS1037 by @jafin in https://github.com/DbUp/DbUp/pull/584
• style (spelling): Fix spelling. Add word ignore list (reSpeller) by @jafin in https://github.com/DbUp/DbUp/pull/719
• refactor(tests): Replace Assent with Verify. Less configuration with paths by @jafin in https://github.com/DbUp/DbUp/pull/721
• Add SQLite journal extension by @SteveDesmond-ca in https://github.com/DbUp/DbUp/pull/592

New Contributors

• @skovsende made their first contribution in https://github.com/DbUp/DbUp/pull/676
• @frecks made their first contribution in https://github.com/DbUp/DbUp/pull/572
• @bomehlsen made their first contribution in https://github.com/DbUp/DbUp/pull/693
• @mjauernig made their first contribution in https://github.com/DbUp/DbUp/pull/695
• @webcoyote made their first contribution in https://github.com/DbUp/DbUp/pull/644
• @Orkad made their first contribution in https://github.com/DbUp/DbUp/pull/542
• @fire-birdie made their first contribution in https://github.com/DbUp/DbUp/pull/528
• @ithielnor made their first contribution in https://github.com/DbUp/DbUp/pull/608
• @PressXtoChris made their first contribution in https://github.com/DbUp/DbUp/pull/629
• @SteveDesmond-ca made their first contribution in https://github.com/DbUp/DbUp/pull/592

Full Changelog: https://github.com/DbUp/DbUp/compare/5.0.10...5.0.37

DbUp mySQL (dbup-mysql)

Fixes / Changes:

• Update to support MySQL Data ^8 (PR #664)
  • This involved conditional dependency tracking for net standard 1.3 as MySQL has dropped that support for the ^8 series.

All Packages

Breaking Changes:

• Remove Unsupported Target Frameworks (PR #655)
  • Removed .NET Framework 3.5 (net35) and .NET Framework 4.5 (net45)
  • Added .NET Framework 4.6.2 (net462)

Fixes / Changes:

• NuGet packages were improved with Source Link and deterministic builds (PR #624)

DbUp SQL Server (dbup-sqlserver)

Breaking Changes:

• Microsoft.Data.SqlClient used for .NET 6 targets (target framework net6.0) instead of System.Data.SqlClient (PR #652)

Fixes / Changes:

• Patches SqlClient security vulnerability (PR #654)

New features

• RunAlways
• Run order groups
• HTML Report generation

• #209 - Fixing issue with the dependency version in the NuSpec contributed by Jake Ginnivan (JakeGinnivan) - Fixes #205
• #202 - Changed default encoding for EmbeddedScriptProvider from ANSI to UTF8 contributed by Lachlan B (clockwisemusic)
• #200 - Update index.md add note about EnsureDatabase contributed by Luis Palacios (LRPalacios)
• #195 - Fix for #188 Table '' doesn't exist contributed by (simoncuce)
• #194 - FileSystemProvider / New option to include scripts from subdirectories contributed by Phil (jesuissur)
• #191 - Correcting a typo in the variable-substitution.md contributed by Kyle (KyleWiering)
• #185 - Provide overloads to specify MySql schema to use in extensions contributed by Matt Keen (mgkeen)

Commits: 25cead27c9...62f9c4fbba

v4 will contains a few minor breaking changes in the API of DbUp. The main change is that SqlServer support has been taken out of core. This means you should install DbUp-SqlServer to get going with Microsoft Sql Server.

DbUp no longer throws exceptions internally when checking for the schema versions table as well as a few other fixes.

• #182 - Added brackets to SqlServerCommandReader's parsing functionality contributed by (mturner47)
• #178 - Exposed a new overload to take command timeout contributed by (ammaraltahan)
• #172 - CarriageReturn removal +fix
• #171 - Case sensitive INFORMATION_SCHEMA table in collations other than Latin contributed by Juliano Solanho (omnibs)
• #170 - SqlTableJournal could not find SchemaVersion table if the database collation is not set to Latin* +fix
• #163 - Not removing Carriage returns when they are followed by End of Line contributed by (esterad)
• #142 - Version 3.3.0 doesn't create SchemaVersions table +fix

Another small bugfix release. Nice work all involved.

• #162 - Remove reliance on exceptions to check if table exists (fixes #142) contributed by Juliano Solanho (omnibs)
• #161 - Added EnsureDatabase.For.PostgresqlDatabase contributed by Gert Jansen van Rensburg (gertjvr)
• #160 - Fix for PR #157, new check can return null contributed by Juliano Solanho (omnibs)
• #147 - Azure EnsureDatabase doesn't work +fix
• #142 - Version 3.3.0 doesn't create SchemaVersions table +fix
• #96 - When error in script occurred DbUp method Perform Upgrade don't provide in exception the name of failed script. +enhancement

A bug fix release to get things moving again :)

• #157 - Fixed Ensure database with sql azure contributed by Chris Young (youngcm2)
• #153 - Fix typo trasactions to transactions contributed by David Kassa (davidkassa)
• #150 - Alter Journal Table Creation To Uniquely Name Primary Key contributed by Adrian Clark (AdrianJSClark)
• #149 - Be explicit about date formatting contributed by Adrian Clark (AdrianJSClark)
• #146 - Naming of Journal Primary Key Constraint - Prevents more than one Migrator
• #145 - Fixed broken PowerShell example contributed by (rintje)
• #144 - the package install is not rendered well on the docs page contributed by Matt Kocaj (cottsak)
• #143 - Docs/convention check contributed by Chui Tey (teyc)
• #141 - Do not substitute variables in comments contributed by (Kemyke)
• #140 - Variable in comment
• #139 - Exception in the method SqlScriptExecutor.Log #138 contributed by (WiRuc) fixes #138 - Exception in the method SqlScriptExecutor.Log
• #127 - Update variable-substitution.md contributed by RickC (ternaryalchemy)
• #126 - Update preprocessors.md contributed by RickC (ternaryalchemy)
• #125 - Sqlcmd script processing contributed by RickC (ternaryalchemy)