Releases: nycdotnet/TSqlFlex
0.2.1-beta
- v0.2.1-beta (2016-07-13):
- Fixed scripting of TIME to XML Spreadsheet (no longer crashes)
- Improved scripting of TIME to SQL scripts - can include up to 7 digits of scale.
- Improved scripting of DATETIME2 to SQL scripts - now includes scale number if relevant.
0.2.0-beta
- v0.2.0-beta (2016-09-23):
- Implemented new script as C# feature.
- Many behind-the-scenes code improvements.
- Added escaping for several SQL keywords.
- Updated to work with NUnit 3 and RedGate SIP FW 1.0.1.246.
Beta 1
v0.1.0-beta (2015-05-07): 1 bug fix, 3 enhancements.
* Reverted to use .NET 3.5 to restore compatibility with SSMS 2008.
* Added CSV export feature! T-SQL Flex can now export the results of any set of queries to properly-escaped CSV files that open correctly in Excel or any text editor.
* Added a handful of additional T-SQL keywords.
* Removed "This is alpha software" warning. Beta 1 will likely have only minimal further changes prior to the v1.0 release of T-SQL Flex.
Alpha 11
v0.0.11-alpha (2015-01-23): 3 bug fixes, 2 enhancements.
- Updated to use .NET 4.5 - this version is now required to run T-SQL Flex.
- Improved scripter to continuously increment the "#Result" table number to prevent conflicts in a session.
- Fixed lockup of SSMS when switching between database servers. (#33)
- Fixed missing column header for anonymous columns in Excel export (#29)
- Fix: Added WEIGHT, TARGET, and NONE as T-SQL keywords.
- Implemented improved logging.
Alpha 10
v0.0.10-alpha (2014-09-11): 1 enhancement, 2 bug fixes
- Implemented drag and drop of database objects from object explorer.
- Fix for launching Excel exported files when there is a space in the profile path name.
- Fix for scripting a field name that includes spaces without bracketizing it.
Alpha 9
v0.0.9-alpha (2014-09-11): A significant bug-fix release with major improvements for SSMS 2008 or below.
- Fix for "Invalid class string" exception in SSMS 2008 or lower (via pull request from David Pond - many thanks!)
- Fix for "unable to determine identity of domain" isolated storage initialization bug in SSMS 2008 or lower.
- Fixes for CTRL+A and CTRL+C - "Select all" and "copy" keyboard shortcuts now work as expected with T-SQL Flex.
- Additional exception handling during data scripting - hopefully will allow more graceful recovery from out of memory exceptions, in particular.
- Some clarifications to the installation instructions including mentioning that the user must unblock the DLLs.
- Fixed the T-SQL Flex metadata so that the add-in info appears in the "SSMS Add-ins" dialog.
Alpha 8
Alpha 7
v0.0.7-alpha (2014-09-02)
This is a bug-fix only release.
- Significant bug fixes for internationalization issues surrounding time and number formatting including tests. Cultures where . is used as the time separator and , as a decimal point should work OK now for both Excel and SQL INSERT scripts. Special thanks to Gianluca Sartori (@spaghettidba) for assistance with troubleshooting these issues.
- Bug fixes for incorrect columns and commas appearing in INSERT scripts due to hidden fields.
- Added more line-feeds to the scripted XML Spreadsheet 2003 output.
- Finished refactoring to "format" functions (this is an internal change only).
Alpha 6
v0.0.6-alpha (2014-08-30):
- Significant improvements to exception handling during all phases of querying and scripting
- Significant changes to disk-based buffering. Now uses .NET IsolatedStorage.
- Significant refactoring - moved query processing logic from UI to Core DLL.
- Fixed bug where synthetic columns (select 'a' as [z]) were incorrectly hidden.
- Fixed bug with scripting binary and other byte[] data fields to Excel.
- Updated SIP Framework to 1.0.1.243 (from July 2014).
Alpha 5
This release adds functionality to script your T-SQL Flex result sets to Excel!
Patch notes:
- v0.0.5-alpha (2014-08-22):
- Export to "XML Spreadsheet 2003" functionality added - this is very early alpha for this feature.
- Started significant refactoring effort for data scripting in T-SQL field vs general presentation.
- Started work to use a file stream rather than a string builder for scripting the data. Currently only used with the Excel XML export.