Skip to content

Releases: nycdotnet/TSqlFlex

0.2.1-beta

14 Jul 03:40
Compare
Choose a tag to compare
0.2.1-beta Pre-release
Pre-release
  • 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

24 Sep 03:43
Compare
Choose a tag to compare
0.2.0-beta Pre-release
Pre-release
  • 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

14 May 17:10
Compare
Choose a tag to compare
Beta 1 Pre-release
Pre-release

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

28 Jan 02:36
Compare
Choose a tag to compare
Alpha 11 Pre-release
Pre-release

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

12 Sep 02:19
Compare
Choose a tag to compare
Alpha 10 Pre-release
Pre-release

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

11 Sep 04:31
Compare
Choose a tag to compare
Alpha 9 Pre-release
Pre-release

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

06 Sep 16:40
Compare
Choose a tag to compare
Alpha 8 Pre-release
Pre-release

v0.0.8-alpha (2014-09-06):

  • Added about box with version info and links for feedback, issues, and updates.
  • Added button to open the latest scripted XML spreadsheet in Excel.
  • Fix for some rare cross-thread UI update issues.

tsqlflexscripttoinserts

excelscripting

Alpha 7

03 Sep 01:03
Compare
Choose a tag to compare
Alpha 7 Pre-release
Pre-release

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

31 Aug 03:36
Compare
Choose a tag to compare
Alpha 6 Pre-release
Pre-release

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

23 Aug 03:39
Compare
Choose a tag to compare
Alpha 5 Pre-release
Pre-release

This release adds functionality to script your T-SQL Flex result sets to Excel!

t-sql_flex_v0 0 5-alpha

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.