Added ADO.NET providers to migration console tool

Added

• net452 build for the console runner to enable usage of the latest MySQL ADO.NET provider

Changed

• Added more ADO.NET providers for the console
• The tools are in platform-specific sub-directories again (e.g. tools/net452/x86/Migrate.exe)

This has become necessary to enable a better out-of-the-box experience for the migration tool.

Hotfix for issue #858

Fixed

• #858: Don't even try to set the command timeout for SQL Server CE

Hotfix for issue #856

• #856: Don't fail when an assembly couldn't be loaded
• #848: MySql4ProcessorFactory used the MySql5Generator

Hotfix for broken FM.Console package

Fixed

• FluentMigrator.Console now contains the migration tool in the tools/ directory (fixes #846)

Added

• Obsolete FluentMigrator.Tools package added as upgrade path

.NET Standard 2.0 support, finally!

Breaking changes

• IQuerySchema.DatabaseType now returns SqlServer2016, etc... and not SqlServer any more
• Database specific code was moved into its own assemblies
• IMigrationConventions was renamed to IMigrationRunnerConventions
• IMigrationContext doesn't contain the IMigrationConventions any more
  • Expression conventions are now bundled in the new IConventionSet
• ICanBeConventional was removed during the overhaul of the expression convention system
• Strings are now Unicode by default. Use NonUnicodeString for ANSI strings
• FluentMigrator.Tools was split into the following packages
  • FluentMigrator.Console: The Migrate.exe tool
  • FluentMigrator.MSBuild: The MSBuild Migrate task

Added

• Framework: .NET Standard 2.0 support
• Database:
  • SQL Anywhere 16 support
  • SQL Server 2016 support
  • MySQL:
    • ALTER/DROP DEFAULT value support
  • MySQL 5:
    • New dialect
    • NVARCHAR for AsString
  • SQL Server 2005
    • WITH (ONLINE=ON/OFF) support
    • 64 bit identity support
  • Redshift (Amazon, experimental)
  • Firebird
    • New provider option: Force Quote=true to enforce quotes
  • All supported databases
    • Streamlined table/index schema quoting
• Unique Constraints: Non-Distinct NULL support (SQL Server 2008 and SQL Anywhere 16)
• Types: DateTime2 support
• Dialect: SQLite foreign key support
• Insert/Update/Delete: DbNull support
• Expression:
  • IfDatabase: Predicate support
  • IfDatabase: Method delegation support
  • Index: Creation with non-key columns
  • Conventions: Default schema name support
  • SetExistingRowsTo supports SystemMethods
  • Passing arguments to embedded SQL scripts
• Runner:
  • TaskExecutor: HasMigrationsToApply support
  • Case insensitive arguments support
  • StopOnError flag

Changed

• Project:
  • Moving database specific code from FluentMigrator.Runner to FluentMigrator.Runner.<Database>
  • Extension methods for - e.g. SqlServer - are now in FluentMigrator.Extensions.SqlServer
• Database:
  • MySQL: Now announcing SQL scripts
• Runner:
  • Better error messages
  • ListMigrations: showing (not applied) for unapplied migrations
  • Show (BREAKING) for migrations with breaking changes
  • MSBuild task is available as separate package (with custom .targets file)
  • Use provider default command timeout when no global timeout is set

Deprecated

• Generic:
  • IAnnouncer.Write

Removed

• Generic:
  • Deprecated functions
  • SchemaDump experiment
  • T4 experiment
• Framework:
  • .NET Framework 3.5 support
• Runner:
  • NAnt build task

Fixed

• Runner:
  • Match TagAttribute by inheritance
• Processors (database specific processing of expressions):
  • Using the new SqlBatchParser to parse batches of SQL statements (GO statement support)
• Database:
  • Hana: Fixed syntax for dropping a primary key
  • Oracle: Table schema now added more consistently
• Tests:
  • Mark integration tests as ignored when no active processor could be found

1.6.2

• #710 Explicitly call Cancel on IMigrationScope to rollback transaction contributed by Eivind Gussiås Løkseth (eloekset)
• #691 Update typemap for mySql to reflect the increased length available to Varchars contributed by Robert Pethick (RobPethick)
• #686 Adding AutoReversingMigrationTest to test reverse logic is implemented contributed by Robert Pethick (RobPethick)
• #682 Update SQL Server Ce Generator to use SELECT UNION ALL syntax to support multiple row inserts contributed by Robert Pethick (RobPethick)
• #681 Fixed issue #618 SqlServerCe Typemap contributed by Eivind Gussiås Løkseth (eloekset)
• #679 Invalid syntax error if description contains quote contributed by Andreas Vilinski (vilinski)
• #674 Unquote a quoted object name contributed by Mark Junker (fubar-coder)
• #676 Firebird: Quote names beginning with underscore contributed by Mark Junker (fubar-coder)
• #654 Oracle: Error when using single quote character ( ' ) as argument for WithDescription(string) method contributed by Sergey Baranov (barser)
• #652 IndexOutOfRange Exception when rollingback a firebird migration on a table containing implicitly declared foreign key contributed by amroel
• #433 Allow CurrentUTCDateTime SystemMethods in SQLLite contributed by Bill Belanger (Merwer)

Commits: cac48b707d...f17dca3ba0

1.6.1

• #665 - [T4]Missing quotes on AsCustom contributed by Giuseppe Lippolis (spaccabit)
• #663 - Fixed SqlServerCe typemap contributed by Nuno Santos (nakataaaa)
• #649 - Fix incorrect console argument in DisplayHelp contributed by David Mohundro (drmohundro)
• #648 - Modified DefaultMigrationConventions to allow Tags to be inheritable contributed by Christopher Bright (cbright)
• #647 - Allow for types with no namespaces contributed by Steve White (stevewhite)
• #646 - Update OracleTypeMap.cs contributed by Tim McGee (jarz)
• #645 - Oracle: Improper Currency precision +fix
• #641 - Add DateTimeOffset to Oracle type map contributed by Victor Grigoriu (vgrigoriu)
• #632 - fixed issue #446 (no semicolons after Update/Create statements in Postgres) contributed by Cristian Lupașcu (wolfascu)
• #631 - Fix bug #630 byte arrays aren't serialised correctly in postgresql contributed by Will Price (willprice)
• #630 - byte array throws a syntax error when inserting into postgresql +fix
• #629 - changed MSBuild Migrate task to run in separate app domain contributed by Michael Murillo (zendever)
• #628 - SqlServer Ce requires NULL to be added to alter table script contributed by Tom Marien (tommarien)
• #627 - Issue with running MSBuild Migrate task from within Visual Studio +fix
• #626 - Tags attribute isn't really inheritable (even though it's "tagged" as such)...
• #617 - SqlServerCe: Specifies NVARCHAR(16) as typemap for time +fix
• #616 - SqlServerCe: Alter column to nullable does not work +fix
• #446 - Postgres -of -p command does not generate semicolons after Update/Create statements +fix

Commits: 40a435a60f...cac48b707d

1.6.0

Small breaking change

• When using IVersionTableMetadata, we've added ApplicationContext and integrated IVersionMetadataExtended (ownsschema), either make the necessary adjustments or inherit from DefaultVersionTableMetadata

Fixes

• #623 - Use semantic versioning on nugets
• #622 - Removed version metadata extended contributed by Tom Marien (tommarien)
• #620 - Datetimeoffset feature patch - not quoting the values appropriately contributed by Richard Bennett (dealproc) +fix
• #619 - Corrected SqlServer2000 typemap (closes #571) contributed by Tom Marien (tommarien)
• #613 - #612 Update Oracle TypeMap contributed by Jonny Bekkum (jonnybee) +fix
• #612 - Oracle TypeMap must allow up to 4000 characters in VARCHAR2 / NVARCHAR2 fields
• #611 - add support of foregn key and index generation for postgresql's T4 ge… contributed by Yusuke Ito (itn3000)
• #610 - Sql server exists performance contributed by Giuseppe Lippolis (spaccabit)
• #607 - Consider maintenance without tags and AsString Collation overload contributed by Kat Lim Ruiz (katlimruiz) +Feature
• #606 - Maintenance class without tags is not executed (it should) +Feature
• #597 - Introducing FluentMigrator in an existing production database
• #596 - Fix bugs and mistakes in firebird typemapping contributed by Lukas Wöhrl (woehrl01) +fix
• #595 - improved character case handling in firebird contributed by Lukas Wöhrl (woehrl01)
• #594 - Smallimprovements and typo fix contributed by Lukas Wöhrl (woehrl01)
• #593 - fixed bug in and improved sql server schema dumper contributed by Lukas Wöhrl (woehrl01)
• #586 - Add application context to versiontablemetadata contributed by (istaheev)
• #582 - Allows to specify custom version table meta data contributed by (istaheev)
• #571 - NVARCHAR(MAX) on Sql2000 +fix

Commits: 78a817d78a...40a435a60f

1.5.1

Features:

• #590 - Improvements for PostgreSql provider contributed by Mladen Macanović (stsrki) [Description Fix, Sequential UUID]

Fixes:

• #600 - Migrate.exe --help doesn't work correctly contributed by (NetworKKnighT)

List of all changes

1.5.0

Features:

• #467 - Allow many assemblies to contribute IMigrations in the same migrations run (JulianRooze)
• #529 - Support SAP HANA Database (FabioNascimento)
• #570 - Add options to generate migrations without database connection (andrewhanson)
• #577 - Added ability to set Transaction Behavior and use Tags with MaintenanceAttribute (unrealguard)

Improvements:

• #553 - Postgresql now handles comments (itn3000)
• #573 - Provides an ability to create a column and specify that the timezone information should be stored with the date (dealproc)

Fixes:

• #572 - SetExistingRowsTo: will not longer change column length (mstancombe)
• #585 - Jet: Added Transaction to expression.Operation (albatrossen)
• #576 - Firebird: quote only keywords otherwise quoting should be optional and not the default & various (amroel)
• #568 - Oracle: Fix Escaping of Guid's, for insertdataexpression etc (tommarien)

Various:

• #565 Albacore upgrade to 2.0 (daniellee)

List of all changes