-
Notifications
You must be signed in to change notification settings - Fork 18
Change Log
Jon Wagner edited this page Jan 28, 2014
·
38 revisions
- Fixed Issue #10 - AutoProc Find ThenBy was missing a comma.
- Added support for Optimistic Concurrency in Autoprocs.
- Fixed autoproc dependency detection when a schema is used.
- Fixed regex hang when parsing certain GRANT statements.
- Fixed adding multiple permissions in a single GRANT statement.
- Fixes for installing SQL schemas and granting permissions on TYPE:: prefixed objects.
- InsightInstaller.exe now returns an exit code of 0 for success and 1 for error.
- Fixed bug with adding nullable columns to an existing table.
- Added SchemaInstaller.CommandTimeout for those times your upgrades take a while.
- Fixed Regex performance issue on 64-bit systems.
- Fixed dropping a column with an inline default.
- Fixed issue #4 - trailing whitespace/comments were flagged as invalid SQL.
- Removed dependency on Insight.Database by using some quick database code.
- Fixed autoproc column size error with unicode strings.
- Fixed permission dependency handling for autoprocs.
- Fixed an issue when repairing a clustered index on SQL Azure.
- Added a command-line installer tool InsightInstaller in the nuget package\tools folder.
- Now throws an InvalidOperationException when you try to AutoProc a table without a primary key.
- Fixed autoprocs for float and real types.
- SchemaInstaller constructor now throws an exception when MARS is enabled on the connection.
- SchemaInstaller will now attempt to repair a missing or corrupt registry if it can handle the dependencies on the objects.
- You can install a schema over an existing database and it will generally handle it.
- If you corrupt your registry, you can install over it and it will generally handle it.
- Added SchemaInstaller.AllowRepair - setting this will tell the SchemaInstaller to not throw an exception when trying to drop a non-existing object and to be more forgiving when repairing a database. Normally, it throws an exception to help detect issues with dependencies.
- Fixed some string comparison issues that caused changes to fail when you change the case of a column or object.
- Removed ConvertingTableEventArgs, since that was no longer being used.
- Switched from System.Transactions.TransactionScope to SQL Server transactions, since TransactionScope doesn't always roll back schema changes properly.
- Fixed adding non-null columns with inline defaults.
- The SchemaInstaller API has changed slightly. You should have no trouble converting.
- SchemaInstaller now takes a SqlConnection as a parameter instead of a connection string. This allows you to manage the lifetime of the connection.
- CreateDatabase and DropDatabase are now static methods on SchemaInstaller.
- RebuildMode has been removed. The dependency engine works better so it shouldn't be needed.
- AutoProc Find now supports skip on SQL Server 2012.
- Added a better SchemaInstaller.ScriptChanges method.
- Compatibility with SQL Azure, so you can deploy to the cloud.
- No dependency on SQL-SMO - SMO didn't play nicely with SQL Azure.
- Better dependency detection - when you modify something, it makes the minimum set of changes to the database.
- Column-level table updates - now columns can be added, removed, or modified without copying the entire data table.
- Exceptions are now thrown when an unexpected dependency issue is detected.
- When trying to drop an object that isn't there.
- When objects are missing after an install is completed.
- Now ships with a dependency on Insight.Database v1.2.9 or later.
- Found some cases where SQL SMO still changes the database connection back to master. (Fixed).
- Installer no longer uses master database unless creating/dropping database.
- Fixed Upsert AutoProc when there are no identity columns.
- Fixed different GO split problem.
- NEW AutoProcs: Upsert, SelectPlural, InsertPlural, UpdatePlural, UpsertPlural, DeletePlural, Find
- Fixed incorrect split on GO in "alGOrithm"
- Added support for AutoProcs.
- Started refactor of code to make it more testable. This will take several versions.
- Added SchemaObjectCollection.Load(Assembly, Predicate)