Toad World

GA Release v1.5.0.503

Fixes

• TFS build - Build freezed after completion
• Default oracle *.dbproj files - Default target is now "Build" instead of "Build;Deploy"; this allows projects to be built from command line without also being deployed
• Table partitioning - Some changes to table partitions were not being deployed

RC2 1.5.0.501

Fixes

• Bug 426 – Even though the project's "Output Type" deployment property is set to "Script" the project still deploys to database instance

RC1 1.5.0.500

Fixes

• Column properties clause of material view are out of place
• Improved memory management and handling for large DDL files

Beta 1.5.0.498

What's New

• Support for column properties in Materialized Views; i.e. LOB storage clauses, VARRAY storage clauses, XML column clauses...
• New "Drop objects not in source" deployment property. Unchecking this property allows you to deploy just the objects that are in your source project. No drops against the target database are scripted.

Fixes

• Bug – Filtering of advanced queue objects generated by the system: IX_Q_ $ indexes, Q_$ tables, and table with the OPAQUE clause.

Beta 1.5.0.497

Fixes

• Bug 296 – Synonyms are not re-deployed after refactor on table name
• Bug 361 – Where clause field should be only enabled when trigger (debug) events are update and delete
• Bug 370 – Remove schema name from SYS_REFCURSOR declaration in anonymous block
• Bug 423 – Circular reference in synonym closes Visual Studio

Beta 1.5.0.496

Fixes

• Bug 248 – Schema Compare update script re-creates the view and function objects when underlying synonyms are missing
• Bug 354 – Picker is missing method and parameters for wrapped package
• Bug 368 – OracleBuildTask failed after importing the DSP1 and TEX11 schema and performing build
• Bug 382 – Never refresh on demand clause from DBMS_METADATA.GET_DDL throws build errors
• Bug 383 – Hash partitioned table with named partitions and tablespace clause throws build errors
• Bug 396 – MV and MV logs are always imported from database with tablespace and segment attributes
• Bug 411 – Materialized view having refresh on commit and using no index is deployed as refresh on demand and using index
• Bug 420 – Received "<column_name> in <partition_table>" is duplicated build error for composite partitioned table by range - range
• Bug 421 – Table partitioning by system throws build error

Beta 1.5.0.488

Fixes

• Bug 392 – A warning is now presented for MVs without columns
• Bug 393 – Naming collision with MVs on prebuilt table
• Bug 399 – MVLs should be scripted before MVs
• Bug 401 – Script gen threw an exception and crashed VS
• Bug 403 – Freeware build is missing templates for MV and MVL
• Bug 404 – Locals window is missing variable information
• Bug 407 – SEGMENT CREATION clause in wrong place
• Bug 409 – MVL deploy script contains PRIMARY KEY when not specified

Beta 1.5.0.485

Fixes

• Bug 379 – SQL statements captured in the IgnoreOnImport file are missing semicolons for each SQL
• Bug 383 – Hash partitioned table with named partitions and tablespace clause throws build errors
• Bug 384 – Received "Cannot build a model: Table partitioning is not supported" build error on hash partitioned tables
• Bug 385 – Build error is thrown due to column being referenced on materialized view is missing for the MV index
• Bug 386 – Create materialized view statement with subquery is ignored when importing from script
• Bug 387 – Received build errors for materialized views with subquery after import from script
• Bug 388 – Many Oracle tables from the TEX11 schema failed to import from database
• Bug 389 – Materialized view with never refresh is deployed to script missing the NEVER keyword
• Bug 390 – Schema compare resulted in missing MV update log table and SYS_I_SNAP index on the source database project

Beta 1.5.0.482

What's New

• We've added so much new functionality:
  
  • Procedure, function, package, and trigger debugging
  • Materialized Views
  • Experimental support for table partitioning
  • Ad-hoc editor with SQL script runner
  • Intellisense
  • Support for External Tables
  we have decided to change the version number from 1.3 to 1.5
• Import Materialized View, Materialized View Log, and Comment On Materialized View from file

Fixes

• Moved Materialized View Log folder from Table directory to root directory
• Added “/” terminating character and extra line to contents of IgnoredOnImport.sql file
• Fixed Null object reference on Reanalyze when project contains a Materialized View
• Fixed build when Materialized View contains a LOB or VARRAU
• Fixed deployment script generation on table without partition

Beta 1.3.0.478

What's New

• Experimental support of Materialized Views (Caution: Not completely supported, yet)
• Improved filtering of advance queues and their associated objects

Fixes

• X.509 certificate licensing issue
• Improved memory handling during schema import of very large Oracle objects

Beta 1.3.0.476

Fixes

• Bug 367 – Index out of range exception while importing COMMENT statement

Beta 1.3.0.475

Fixes

• Task 365 – Filter out Advance Queue objects: TABLE, INDEX, VIEW
• Bug 364 – Dependency on a SYNONYM that cannot be resolved throws Null Reference Exception
• Bug 357 – Quest.tech.resources file not found
• Bug 353 – Allow user to enter NULL as a debug value

Beta 1.3.0.474

Fixes

• Bug 356 – PL/SQL Debugging: Validation of BOOLEAN user values
• Bug 355 – PL/SQL Debugging: Allow user to specify NULL values
• Bug 352 – Debug Options Page: Null reference exception thrown
• Bug 328 – Visual Studio not responding after canceling build of Oracle 9i deployment

Beta 1.3.0.472

Fixes

• Bug 215 – DDL of table column with ENCRYPT USING 'AES128' also contains 'SHA-1'
• Bug 347 – Issue with code view
• Bug 348 – Received build error string initializer too long on package
• Bug 349 – Received build error "Cannot build a model: Not found" for trigger
• Bug 350 – Column encryption clause throws error when trying to build project
• Bug 351 – Deploy of project failed due to System.NullReferenceException: Object reference is not set to an instance of an object error
• Bug 357 – Quest.tech.resources file not found and license options property page displayed error

Beta 1.3.0.470

Fixes

• Bug 346 - Error deploying with MSBuild.exe from the command line

Beta 1.3.0.465

What's new

• Updated trial license.
• Check and announcement of newer version of the Toad Extension.

Fixes

• Bug 332 - Varray table with tablespace clause is not imported from script
• Bug 345 - Existing Oracle database project failed to build after importing script with table and index

Beta 1.3.0.465

What's new

• Updated trial license.
• Check and announcement of newer version of the Toad Extension.

Fixes

• Bug 332 - Varray table with tablespace clause is not imported from script
• Bug 345 - Existing Oracle database project failed to build after importing script with table and index

Beta 1.3.0.463

What's new

• Ad-hoc Script Editor - now you can write your own queries, and execute them.
• Live Debugging - step through your procs, funcs, packages, and triggers.
• Intellisense - help with Oracle syntax.

Fixes

• Sequences - START WITH clause is now ignored during deployment.
• Triggers - Schema comparisons, and deployments work properly.

Beta 1.3.0.459

What's new

• Fixed issue in which builds incorrectly reported duplicate named column constraints.

Beta 1.3.0.458

• Support domain specific indexes.
• Fixed null reference exception in data generation.
• Recompiling invalid PL/SQL is reported as a warning instead of an error. The deploy is now reported as successful.
• Errors during database deploy now include description of DDL command that caused the error.
• Fix issue in which Schema Compare did correctly handle dirty documents in the the project.

Beta 1.2.1.448

• Added support for tables with external organization.
• Fixed reported bug with deployment of function based indexes.

Beta 1.2.1.447

• Improved PL/SQL Debugging ( View the debugging notes to see how to launch debugging.)

Beta 1.2.1.442

• PL/SQL Debugging ( View the debugging notes to see how to launch debugging.)
• Inspect collections and arrays during a debug session.
• Inspect lcoal variables during a debug session.
• Debug project configuration allows for starting a debug session without deploying the database project.
• The debugger will break on exception.
• improved deployment support for function based indexes
• Support for ORGANIZATION EXTERNAL table storage clause

Beta 1.2.1.440

• PL/SQL Debugging. Packages, procedures, and functions can now be executed in debug mode. View the debugging notes to see how to launch debugging.

Beta 1.2.1.434

• Deployment Scripts-Toad Extension now supports pre-deployment and post-deployment scripts.
• XML Columns Supported-Toad Extension now supports tables with XML data type columns.
• Nested Tables Supported-Toad Extension now supports tables with up to two levels of nested table type columns.
• Synonyms Supported-Toad Extension now supports the use of synonyms.