DbUp

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 )