-
Notifications
You must be signed in to change notification settings - Fork 247
Releasenotes
Mario Pareja edited this page Jul 19, 2013
·
18 revisions
#Release Notes
Downloads are available on Google Code.
- Use git as official repository. (mpareja)
- Upgrade UpperCut to version 1.4.2. (ferventcoder)
- Database Restore: use restore specific timeout value. (icetoast - pull #90)
- Ignore EOL format changes when detecting script changes. (lahma - pull #104)
- Include SQL Print statements in debug log. (ferventcoder - issue #68)
- Include statement being run in log when an error occurs. (ferventcoder - issue #66)
- Added 'runBeforeUp' anytime directory. (cdrexle - pull #51)
- Support resolving version from a text file. (mpareja - pull #50, pull #55)
- Add option to turn off copying scripts into 'itemsRan' directory. (lahma - pull #47)
- WarnOnOneTimeScriptChange will now cause changed one-time scripts to be re-run. (BiggerNoise - pull #35)
- Upgrade NHibernate to version 3.3.2. (drusellers)
- Upgrade FubuCore, HtmlTags and StructureMap. (drusellers)
- SQL Batch Parser: handle training comments, single quotes. (mpareja - pull #108)
- SQL Batch Parser: fix hang. (AndersMalmgren - pull #100)
- Token Replacer: preserve case for unmatched tokens. (mpareja - pull #65)
- SQL scripts no longer truncated to 4000 characters. (charoco, ferventcoder - pull #61)
- Oracle: Fix handling of null values. (rdingwall - pull #59, issue #58)
- Script File Versioner: fix exception. (Michael Kobaly - issue #68 on Google Code)
- Only change DB recovery mode if explicitly told to. (ferventcoder - issue #69 on Google Code)
- Fixed the debug command line switch. (ferventcoder - issue #40)
- Ensure version 1.2.10 of log4net is used when installing NuGet packages. (ferventcoder - issue #41)
- Fix: Improve logging of RH exceptions. (torkelo - pull #60)
- RoundhousE will change the DB recover mode if the
recoverymode
mode option is explicitly set tosimple
orfull
. In the past, RoundhousE would default tofull
but would only ever set the recovery mode while creating/restoring the database. If you depended on RoundhousE to create/restore the database for you and you don't want the database server default to be used, you should specify the recovery mode option.
Google Code & Github have the details.
- FIX: KeyNotFoundException in NHibernateSessionFactoryBuilder. See [issue 59] (http://code.google.com/p/roundhouse/issues/detail?id=59) for details. (r361)
- SQLite Support!. See details https://github.com/chucknorris/roundhouse/issues/21 (r360)
- PostgreSQL Support! Thanks SiimV! See details https://github.com/chucknorris/roundhouse/issues/30 (r359)
- New Configuration Switch! SearchAllSubdirectoriesInsteadOfTraverse - All migrations subfolders are traversed by default and run in order of each folder's scripts. This option runs all items in subfolders at same time. Thanks SiimV! See details https://github.com/chucknorris/roundhouse/issues/31 (r359)
- FIX: Transactions not working with restore. See details https://github.com/chucknorris/roundhouse/issues/26 (r357)
- FIX: Fixed a nasty bug with SQL Server where it tries to hold a connection (interferes with drop/create mode) and gives a transport error. See details https://github.com/chucknorris/roundhouse/issues/12 (r357)
- New Version Resolver! - Script Number Versioning. Thanks Chris (developingchris)! See details https://github.com/chucknorris/roundhouse/pull/25 (r356)
- FIX: Custom create script should split batch statements. See details https://github.com/chucknorris/roundhouse/issues/22 (r353)
- New Migrations Folder! RunAfterCreateDatabaseFolder - Runs only one time and only after a database has been created. This works with a limited set of database types at the moment. Please test if you are planning on using. See details https://github.com/chucknorris/roundhouse/issues/20 (r351)
- Almost everything is now ilmerged internalized. See details https://github.com/chucknorris/roundhouse/issues/8 and https://github.com/chucknorris/roundhouse/issues/15 (r350)
- FIX: Cannot drop databases with snapshots. See details https://github.com/chucknorris/roundhouse/pull/13 (r349)
- Create database custom script can handle file paths. See details https://github.com/chucknorris/roundhouse/pull/17 (r348)
- FIX: SQL Server 2000 needs to create all of its tables. See details https://github.com/chucknorris/roundhouse/issues/18 (r346)
- RH assemblies are now signed. See details https://github.com/chucknorris/roundhouse/issues/14 (r342)
- FIX: Removed the temporary log location. See details https://github.com/chucknorris/roundhouse/issues/7 (r340)
- New Configuration Switch! DisableTokenReplacement - Token replacement should be configurable. See issue 56 for details. (r339)
- FIX: Token replacer should only replace for items it finds. See issue 56 for details. (r339)
- Possible Breaking Change! File encoding will always try to read files as UTF-8, but fall back to ANSI. You can't go wrong if you encode in ANSI. See issue 39 for details. (r337)
- Restores are a bit smarter about moving files to a default location when one has not been specified. See details https://github.com/chucknorris/roundhouse/issues/9 or issue 13 (r336)
- FIX: Do not run token replacement on empty text. See details https://github.com/chucknorris/roundhouse/issues/10 (r330)
- Custom Scripts also run token replacement (r321)
- New Configuration Switches! Two new switches available - CommandTimeout and CommandTimeoutAdmin! (r329)
- FIX: Migrate doesn't try to configure log4net now (causes issues w/libraries that do) (r326)
- New Migrations Folder! Indexes folder now available (r327)
- New Migrations Folder! AlterDatabase folder now available. See details https://github.com/chucknorris/roundhouse/issues/6 (r324)
- FIX: Included sample for Oracle doesn't work. See [issue 55] (http://code.google.com/p/roundhouse/issues/detail?id=55) for details. (r322)
- Custom Restore Options should use token replacement (r321)
- MySQL Support!. Thanks Diyan. See details https://github.com/chucknorris/roundhouse/pull/3 (r320)
If I missed your name in attributions above, please let me know. I apologize in advance. There was a LOT of contributions in this release.
- RH now does token replacement in the sql files using '{{PropertyName}}'. See [issue 33] (http://code.google.com/p/roundhouse/issues/detail?id=33) for details. (r299)
- Always run files that have '.EVERYTIME.' in the name. See [issue 51] (http://code.google.com/p/roundhouse/issues/detail?id=51) for details. (r299)
- RoundhousE ships a DLL for embedding. See [issue 44] (http://code.google.com/p/roundhouse/issues/detail?id=44) for details. It has a semi-fluent interface - see (https://gist.github.com/977990) for details. (r299)
- FIX: Environment Specific Files run other environments when other environments are part of the name (i.e. BOBTEST is run with TEST). See [issue 50] (http://code.google.com/p/roundhouse/issues/detail?id=50) for details. (r299)
- A folder that runs after the other anytime scripts folders have run has been added. See https://github.com/chucknorris/roundhouse/pull/1 for details. (r297)
- Fixing the script modified twice running each time bug. See https://github.com/chucknorris/roundhouse/pull/5 for details. (r296)
- Sample is now a project in the release folder. (r287)
- MSBuild is available again. (r288)
- Fixed a few issues with using the connection string. You should now be able to only supply the connection string and not server/database as well.
- Fixed a collation issue with RoundhousE id columns in its tracking tables. See [issue 46] (http://code.google.com/p/roundhouse/issues/detail?id=46) for details. (r274)
- RestoreFromPath can take a relative path. (r269)
- RH can now upgrade it's internals without user interaction. See [issue 40] (http://code.google.com/p/roundhouse/issues/detail?id=40) for details. (r268)
- MSBuild / NAnt tasks are deprecated and no longer hooked up. Please use the console and call it from your tasks. (r268)
- RH has differencing support with NHibernate Schema Generation/Updates (r267 - branch, r268)
- FluentNhibernate and NHibernate are now being used for the internals (r267 - branch, r268)
- SMO is deprecated and removed (r203 - branch, r268)
- Gems and build upgrades, oh my! (r259)
- SQL2000 to 2005 is now a smooth transition. (r221)
- Fix: SQL2000 - ScriptsRun now correctly references Version for the foreign key. (r220)
- Fix: Connection should be initialized before asking the database if it supports ddl transactions. (r215)
- Fix: Uppercase User names when running with Oracle. (r200)
- RH has differencing support with RedGate. See sample project for details. (r197)
- Fix: Scrips run errors now updates version number and path w/out a dependency on scripts run. Allows for it to finish during transactional runs and still capture errors. (r196)
- Fix: Capture errortastic changes to DDL/DML (up) files in the script run errors table. (r191)
- Added admin connection string to do administrative tasks. (r190)
- RH handles nonsupported DDL transactions. RH will also stop and inform the user when DDL transactions are not supported, so user can choose to continue - see issue 28 for details. (r172 - branch, r185)
- RH logs when errors occur in the RoundhousE.ScriptRunErrors table - see issue 28 for details. (r167 - branch, r185)
- RH supports SQL Server 2000 - see issue 30 for details. (r167 - branch, r185)
- RH supports Oracle - see issue 34 for details. (r157 - branch, r185)
- RH should handle when user names have apostrophes (') in them - see issue 32 for details. (r175)
- Database names should have delimiters to allow for non standard characters - see issue 31 for details. (r174)
- Added autowiring permissions sample. (r169)
- If copying to change output fails, log a warning and move on. (r156)
- Turning off batch splitting where it is not necessary as it does affect performance. (r150)
- Splitting statements on GO has been enhanced to catch end of file GOs - see issue 25 for details. (r149)
- Splitting statements on GO has been enhanced - see issue 25 for details. (r147)
- Splitting statements on GO is now a two-phased approach - see issue 25 for details. (r143)
- Trying out StructureMap (r136)
- More fine-grained splitting by the word GO - see issue 25 for details. (r130)
- Command timeout became more explicit so database decorators can access and manipulate the value now. (r129)
- RH should be able to use ADO.NET instead of SMO for SqlServer - see issue 22 for details. (r125)
- Option not to create a database if none exists - see issue 24 for details. (r123)
- Console should exit with an error code instead of crashing on errors - see issue 23 for details. (r119)
- Restore timeouts can now be specified (with a default timeout of 900 seconds) - see issue 21 for details. (r117)
- Custom database create scripts are now possible - see issue 20 for details. (r116)
- All types of migrations will split sql statements from files that have more than one statement into multiple statements and run each consecutively - see issue 27 for details. (r113)
- Fixed issue with running roundhouse twice during MSBuild - see issue 16 for details. (r112)
- Reports version during run - see issue 9 for details. (r108)
- Logs what type of script it is looking for and where it is looking for them - see issue 14 for details. (r107)
- Removed double error reporting on exception. (r107)
- Adding getting started documentation
- Added a custom restore option to add additional arguments (like MOVE) to a restore - see issue 12 for details. (r104)
- Fixed a connection string initialization issue (r103)
- File Sorting - Fixed a sorting issue with file names to do explicit sorting. (r101)
- RH has an icon of the logo (r99)
- OleDB Support - RH can now be run for advanced database connections with a connection string. (r96)
- OleDB may not support creating/restoring/deleting databases.
- Microsoft Access is supported through OleDB.
- Other databases will need to have scripts written for their type before they would be supported.
- Environment awareness - RH determines an environment file first that it has ".ENV." in the file name and then if it is the proper environment file based on whether the file also contains the specific environment name. For example LOCAL.0001_DoSomething.ENV.sql will run in the LOCAL environment but no where else.
- Runs permissions files every time regardless of changes.
- Added synonyms for database types - see issue 10 for details. (r85)
- Removed some of the logging - no more event logging for limited permissions running (r83)
- The command line version (rh.exe) is merged into a single assembly with all dependencies (except Microsoft.SQL dlls) internalized. No configuration file necessary either. (r77, r82)
- Log from console runner is now copied into the change_drop folder. (r81)
- Recovery mode is now explicit. Default is full. Otherwise pass in /simple - see issue 8 for details. (r78)
- Excluded the drop database from transactions (not that you would call /drop with /t). (r76)
- Fixed an issue with holding connections - see issue 7 for details. (r74)
- Added the ability to run with transactions