Skip to content

Releases: babelfish-for-postgresql/babelfish_compass

Babelfish Compass v2024-04

11 Apr 17:18
Compare
Choose a tag to compare

What's New

  • Added support for Babelfish v.4.1.0 and v.3.5.0.
  • Detect and rewrite often-seen FOR XML PATH workaround for STRING_AGG().
  • Various small enhancements.

md5 Verification

BabelfishCompass_v2024-04.zip (741c4f238f7ca0c72b2df5251e08acc2)

Babelfish Compass v2024-02

16 Feb 21:11
Compare
Choose a tag to compare

What's New

  • Updated support for Babelfish v.4.0.0.

md5 Verification

BabelfishCompass_v2024-02.zip (ea1eb40adffec73a244d1cf0b955d2a3)

Babelfish Compass v.2023-12-a

28 Dec 23:22
eae9b56
Compare
Choose a tag to compare

What's New

  • Added DEFAULT parameters as supported in 3.4.0 (previously omitted).

md5 Verification

BabelfishCompass_v.2023-12-a.zip (41a95b50f068f30dce611112854689ea)

Babelfish Compass v.2023-12

18 Dec 21:47
0560abd
Compare
Choose a tag to compare

What's New

  • Updated support for Babelfish v.3.4.0 (PG15.5).

md5 Verification

BabelfishCompass_v.2023-12.zip (ea505c48d559c4cc7c3346a7de72eea6)

Babelfish Compass v.2023-11

15 Dec 17:59
4978751
Compare
Choose a tag to compare

What's New

  • Updated User Guide with sections about scaling and advanced features.
  • Additional usability features for large-scale cases.
  • Minor report enhancements.

md5 Verification

BabelfishCompass_v.2023-11.zip (a4978103a8fc17df999bd8928ba6c480)

Babelfish Compass v.2023-10

18 Oct 19:55
bdfa948
Compare
Choose a tag to compare

What's New

  • Updated support for Babelfish v.3.3.0.
  • Rewrite of WITH RECOMPILE (only if no other options are present).
  • Rewrite of DROP INDEX table.index
  • When uploading with the '-pgimport' flag, the uploaded details now contain additional information for tracking object dependencies.
  • Minor report enhancements.

md5 Verification

BabelfishCompass_v.2023-10.zip (006fc97e2c0c6231698835ca8f835155)

Babelfish Compass v.2023-08

01 Sep 19:01
8c5f0fa
Compare
Choose a tag to compare

What's New

  • Fixed an issue with non-English locale causing aborting with error "Analysis was performed for a different Babelfish version (v.) than targeted by this run (v.3.2.0)".
  • Fixed a problem when using the -sqlendpoint flag, causing Compass to hang.
  • When using -sqlendpoint, include SQL Server license type and resource info in the Compass report.
  • Support for new 'one-time learning curve' component in user-defined effort estimates.
  • New user-defined defaults for complexity scores and effort estimates, for categories of items.
  • New flag '-csvformat flat' to generate the .csv file in 'flat' format.
  • Small report enhancements.

md5 Verification

BabelfishCompass_v.2023-08.zip (7f29bb5ab8eae360be9dfa6baa4d5214)

Babelfish Compass v.2023-06

11 Jul 16:12
80aa302
Compare
Choose a tag to compare

What's New

  • Updated support for Babelfish v.3.2.0.
  • Expanded scope of -optimistic flag.
  • New feature to generate DDL automatically.
  • Detect/rewrite !< and !> operators.
  • Suppress rewrite for dynamically composed SQL.
  • UPDATE/DELETE TOP are now supported but reclassified as "Review Semantics" due to inherent row order unpredictability.

md5 Verification

BabelfishCompass_v.2023-06.zip (0ea84da3b61a8d6b096c7c1db221742c)

Babelfish Compass v.2023-03-a

22 Mar 19:14
f5d7da8
Compare
Choose a tag to compare

What's New

  • Updated support for Babelfish v.2.4.0 and v.3.1.0.
  • Detect and report dynamically declared cursors.

md5 Verification

BabelfishCompass_v.2023-03-a.zip (96df9566d56975303efeeebc5c37b944)

Babelfish Compass v.2023-03

13 Mar 21:41
7dda182
Compare
Choose a tag to compare

What's New

  • Support for Babelfish v.2.4.0 and v.3.1.0.
  • Detect and report SQL2022 features.
  • Added predefined 'optimistic' user-defined .cfg file and -optimistic option (see user guide).
  • Minor grammar fixes.

md5 Verification

BabelfishCompass_v.2023-03.zip (a39a585b86efa8794becedfcb5e0a510)