What's new in SQL Server Metadata Toolkit Beta 0.28.0.0
Feb 8, 2024
- This release adds SQL 2019 capabilities, and ODBC call handling to the Parser.
- Fixed:
- Please update DependencyAnalyzer for SQL Server 2019
- Error Number: 46010
New in SQL Server Metadata Toolkit Alpha 13 (Jun 6, 2014)
- The installer has been replaced with a corrected installer (25th of October 2012), which places all the files in the correct location. There are no changes to the executables, just where the installer places them.
- This is a Feature Release.
- Includes the following features:
- Print from Dependency Viewer
- Save to JPG and EMF from Dependency Viewer
- Ability to change Layout (Top Down, Left to Right, etc.)
- Ability to move items on the layout
- Ability to parse SQLTask's
- Ability to read Fast Load from Variables destinations
- Add SQL 2012 Capability for SQL Server, SSIS and SSAS. (This hasn't been heavily tested, and the SQL Parser will probably complain about SQL 2012 statements.)
- SQL 2012 SSRS is treated like SQL 2008 R2, but does scan.
- Ability to understand Insert (and lots of other SQL 2008 R2 statements that it didn't understand before...)
New in SQL Server Metadata Toolkit Alpha 12 (Jun 6, 2014)
- This is a minor release, which addresses 3 issues:
- 14631 - Enable single database analysis in Analysis Services
- 14632 - Database Create failing, and scripts not up to date
- 14633 - Add SQL 2005 Reporting Services Analysis
- To use the Analysis Services filtering, ensure you include the Initial Catalog=Database in your connection string. To have all databases on an Analysis Server processed, leave the Initial Catalog parameter off.
New in SQL Server Metadata Toolkit Alpha 11 (Jun 6, 2014)
- This is a major release, including the following features:
- New SQL Parser
- Ability to retrieve dependancies for Tables, Views, Functions and Stored Procedures from Databases
- New UI to generate commands for usage
- Ability to retrieve dependancies from Reporting Services
- Ability to restrict parents and children in the Viewer
New in SQL Server Metadata Toolkit Alpha 10 (Jun 6, 2014)
- This is a minor release to address issue 14281.
- There is a new command line parameter which allows the specifying of folders for detection within SSIS./ssisFolders:
- This can be specified many times to cover separate folders within the Integration Services folder structure.
- The recurse option is active and at this stage can not be disabled.
- All other parameters now have short form options.
New in SQL Server Metadata Toolkit Alpha 9 (Jun 6, 2014)
- This is a minor release to address issues 11596 and 11597.
- The issues were that the previous release introduced a bug in retrieving information from SQL Statements due to the way SSIS stores some metadata.
- It also now handles EXEC statements that don't have any parameters after them.
New in SQL Server Metadata Toolkit Alpha 8 (Jun 6, 2014)
- This is a minor release, which adds the ability to retrieve the SQL Text from a variable for OLEDB sources.
- This is for issue 11032.
New in SQL Server Metadata Toolkit Alpha 7 (Jul 9, 2010)
- The changes in this are to the Parser, and a change to handle WITH CTE's within the Analyzers.
- The Parser now handles CAST better, EXEC, EXECUTE, WITH CTE's, WITH () and OPTION().
- Please note that only queries with FROM clauses will have the source table added as an object into the database. Stored procedures will be treated as basic SQL.
- There are some caveats on the OPTION, as a table hint within Option won't be parsed.
- If someone has a good example of this I will update the parser to handle it...