DbUp

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)

This is the first DbUp release for quite a while, there has been quite a few things added and fixed in this release. We also have docs for the first time at http://dbup.readthedocs.org/en/latest/!

If you have any issues with the release please report an issue.

Highlights include:

• EnsureDatabase.For API to make sure a database is created
• SQLite does not pull in EF
• SQLite mono support, soon this will target xamarin and other PCL's - feel free to jump in and help out

Other issues:

• #117 - Sqlite fixes contributed by Jake Ginnivan (JakeGinnivan)
• #116 - Upgrade my sql contributed by Jake Ginnivan (JakeGinnivan)
• #114 - Added EnsureDatabase.For contributed by Rick Culpepper (rickculpepper)
• #111 - More test improvements contributed by Jake Ginnivan (JakeGinnivan)
• #109 - Improve testing contributed by Jake Ginnivan (JakeGinnivan)
• #108 - SQLite net35 support
• #104 - Don't drag in Entity Framework with SQLite
• #101 #102 - Variable substitution doesn't seem to be working contributed by Ben Collins (aggieben)
• #97 - Issue-96-When-error-in-script-occurred-DbUp-method-Perform-Upgrade-do… contributed by (MaksymDrach)
• #95 - Enable loading scripts from multiple assemblies contributed by Trevor Pilley (TrevorPilley)
• #94 - AdHocSqlRunner - doesn't dispose of reader.
• #93 - Sq lite mono contributed by Darrell (dazinator)
• #92 - SqlLite - Mono Support
• #91 - Fix sqllite contributed by Darrell (dazinator)
• #90 - DbUp.SqlLite.dll missing
• #88 #89 - Build error, virtual or abstract members cannot be private contributed by Gordy (gfody)
• #87 - Added some enhancements and fixes contributed by (youngcm2)
• #86 - UpgradeEngine.TryConnect throw null reference exception
• #85 - Making SqlScriptExecutor inherit friendly contributed by Brady Holt (bradyholt)
• #81 - Support for selection of sql file encoding contributed by Diana Ionita (dia0369)
• #75 - Refactor MySql support contributed by Chris Bernholt (namzat)
• #73 - updated MySql.Data from 6.9.3 to 6.9.5 contributed by Oliver Zürcher (olibanjoli)

Also thanks to Ben Collins (aggieben) be initial implementation ideas for EnsureDatabase.For

Commits: 7328317fc8...17b3522b03

• 3.2.0 was missing the MySql package from the release. This release includes it

• #72 - Firebird support added - contributed by@Jeern
• #71 - Exitcode will be set to 1 if the scripts or program fails - contributed by @kbaexpandit
• #64 - added mysql support - contributed by @olibanjoli
• #60 - Update SQL Server Compact package and NuGet dependency to version 4.0 SP1 - contributed by @ErikEJ
• #67 - Filtering Scripts overloads and Filters helper - contributed by @dazinator

• Fixed another issue in new GO Splitter

• Fixed Bug with new GO splitter

• Script Parser correctly handles GO inside comments and strings (#44) - contributed by Darrell
• DbUp.Postgres released - contributed by Liam McLennan and Nuspec by Glenn Morton
• Added ability to specify SQL instance for TemporarySqlDatabase since SQL Express is no longer installed by default, in favor of LocalDb - contributed by Jessie Wadman
• DbUp no longer requires write access to scripts director (#46) - contributed by Adrian Clark
• Fixed exceptions when scripts do not modify data and better logging - contributed by nitzmahone, Paul Mendoza and Cliff Bowman

Some nice fixes, next version will contain Oracle support!

This is a major release with quite a few upgrades

• Added: WithExecutionTimeout() to set the execution timeout of all sql commands
• Added: TransactionSupport! .WithTransaction() and .WithTransactionPerScript() when configuring DbUp
• Added: SqlLite support
• Added: Support for logging script output, SqlServer only currently. Opt in with .LogScriptOutput() when configuring DbUp (#33)
• Added: NullJournal for omnipotent script execution, .JournalTo(new NullJournal()). (useful for Stored Procs, views etc which need to be updated every upgrade)
• Fix: Schema can be incorrectly quoted ([] added incorrectly) (#11)
• Fix: Format datetime using ISO 8601 in SqlTableJournal (#18, #20, #27 )