-
Notifications
You must be signed in to change notification settings - Fork 18
Change Log
Jon Wagner edited this page Sep 12, 2012
·
38 revisions
- 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.IgnoreMissingObjects - setting this will tell the SchemaInstaller to not throw an exception when trying to drop a non-existing object. 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)