Release Notes¶

MS SQL Connection Recovery - The MS SQL driver now has a new feature that allows the driver to automatically reconnect to the server if the connection is lost. This feature is disabled by default and can be enabled by setting the Connection_Recovery setting to Yes in the mds_global.ini file.

Unicode Support - All drivers now have full Unicode support. This means that you can migrate and use the driver with Unicode columns and in mixed environments as well.

New Password Encryption - The driver now generates a different encrypted value every time mdsencryptpassword is run even if the password you choose is the same. The encryption used is now more secure and is properly salted with a random value. The utility can be found in the bin directory of the driver installation. The utility can be used to encrypt a password that you provide. Additionally the driver can store passwords in the Windows Credential Manager now. A legacy option is available using the “-legacy” flag. For more details see Password Encryption.

Improved Migration Performance - The command line migration utilities now have a new option that allows you to specify the number of threads to use for the migration. This can be specified using the -threads flag. The default is 1 thread. When this option is used the migration will be broken up into chunks handled by multiple processes handled by multiple threads. This can improve performance dramatically. This option is only available for files that are at least v9.

Improved Count Logic - For PostgreSQL the logic used to count the number of rows in a table has been improved. The old logic used a COUNT(*) query which was slow for large tables. The new logic uses a more efficient method that is faster but may be slightly less accurate if many rows were recently added.

Better Batch Find Performance - The drivers now support setting the MAX_ROWS_TO_QUERY to higher values. Before you were able to set a high value but after a certain point you wouldn’t see any increase in performance. Now you’ll see this benefit continue to increase. Optimization in this area is still being adjusted going forward. You should consider programmatically setting the value where it needs to be high as needlessly high values can actually be detrimental to performance.

Improved Find Performance - The PostgreSQL driver has seen many improvements to find performance. Performance for some multi-segment find scenarios has been improved by 20-30%.

Convenience Features Throughout - The GUI Migration tool has many bug fixes and detects things like the CI extension for PostgreSQL and has the DLLs for clients in the correct place now upon installation. It has Unicode detection built in and can work with multiple schemas. It is able to output a batch file with command line options for mass migration that will be faster that using the GUI migration tool. There are other features as well. Many of these features will make the use of this tool less problematic than in previous versions.

PostgreSQL v17.6 Support - v7.0 now supports PostgreSQL v17.6. You’ll need an updated license to use PostgreSQL 17.6. Please contact our sales staff to make sure you have a license that supports PostgreSQL 17.6.

Oracle v23.7 Support - v7.0 now supports Oracle v23.7. You’ll need an updated license to use Oracle 23.7. Please contact our sales staff to make sure you have a license that supports Oracle 23.7.

New Driver Setting - The driver has a new setting ALLOW_EMPTY_DEFAULT_VALUES that can be set to Yes or No to allow or disallow empty default values in the migration tool. This is disabled by default.

Btr2SQL Command Prompt - There is now a shortcut item to open a command prompt with the BIN folder in the path. This makes using the command line tools much easier on your development machine. It’s similar to using the “Developer Command Prompt for VS”.

Improved Support for COBOL - v7.0 includes many advanced features used in COBOL like REDEFINES, OCCURS, and variations on EBCDIC numeric data types and other COBOL specific data types.

PROD-2072 Migration tool does not show the tool version at the About dialog. Fixed.

PROD-2034 Slowdown using Trace_on = debug:// Fixed.

PROD-2045 Re-fetched record to determine record-conflict status 80. Fixed.

PROD-1455 Postgres Driver Migration Tool can’t convert table if you set the target Tablespaces to Table and/or Indexes. Fixed.

PROD-2027 MS SQL Driver Stat 79 when using mds.ini with TrustedConnection and setting user value. Fixed.

PROD-1992 Postgres Driver - Performance issue related to B_GET_PREVIOUS calls. Fixed.

PROD-2026 Oracle Driver MdsMigrateTable.exe tool always reports the warning “Trusted Connection is not supported. User and Password will be required”. Fixed.

PROD-2023 MS SQL Driver migration didn’t map the Btrieve TimeStamp and Time properly as they were set at the mapping data type dialog. Fixed.

PROD-1419 Postgres Driver Btrieve status 12 opening file. Fixed.

PROD-2018 Debug:// output doesn’t seem to work. Fixed.

PROD-2008 Error code 80 when saving. Issue was related to FLOATs. Fixed.

PROD-1708 Performance gap in trace is being reported instead of assigning it to AppTimeGap. Fixed.

PROD-1463 Assign Table Name to XML file in Migration tool. Fixed.

PROD-1462 Create XML from Table is adding MDS_RECNUM to no unique indexes. Fixed.

PROD-1443 Postgres Driver Failed migration to UTF database. Fixed.

PROD-1427 Postgres Driver had various minor migration issues related to the trace and error messages. Fixed.

PROD-1423 Postgres Driver was generating an incorrect find query affecting the performance on large tables. Fixed.

PROD-1421 Postgres Driver Migration Tool Crashes when selecting a PostgreSQL Schema at Login dialog. Fixed.

PROD-1393 Postgres Driver Migration tool should not allow to select a function based index to be a primary key. Fixed.

PROD-2010 Migration tool is mapping UNSIGNED datatype to DECIMAL/NUMERIC as default datatype. Fixed.

PROD-2003 Postgres Driver Browse SQL Table for Postgres gets ODBC error. Fixed.

PROD-2020 Migration tool - Error mapping Btrieve Time to MS SQLServer Time data type. Fixed.

PROD-2021 MS SQL Driver - Creating table script missing column definition when using MS SQLServer Time data type. Fixed.

PROD-1997 Postgres Driver Time and Timestamp support with fraction portion. Fixed.

PROD-2009 Postgres Driver MDSMigrateTable doesn’t obey schema passed. Fixed.

PROD-2002 Splash Screen is shown every time when automatic login is selected. Fixed.

PROD-2011 XML generation creates empty Index 0 for table with Identity field. Fixed.

PROD-1586 Nag screen uses old mertech image. Fixed.

PROD-1996 Generate XML Definitions Crashing GUI Migration. Fixed.

PROD-1671 Postgres Driver Issues with Postgres timestamp fields. Fixed.

PROD-1576 Postgres Driver MdsMigrateFile is not migrating VARIABLE record portion to table. Fixed.

PROD-1580 Error code 80 when saving. Fixed.

PROD-1487 MS SQL Driver Movierental Sample Program return Login error. Fixed.

PROD-1480 XML Generation from GUI and MdsMigrateTable failing because of pvfile & bpchar issue. Fixed.

PROD-1456 Postgres Driver for can’t open tables converted as lowercase. Fixed.

PROD-1444 DDFValidator Crashes during starting. Fixed.

PROD-1395 Fix support for detecting and enabling CITEXT in migration tool.

PROD-1442 Migration report does not show failed migration details. Fixed.

PROD-1446 Postgres Driver Trace Control doesn’t list PostgreSQL driver. Fixed.

PROD-1434 Postgres Driver Infinite Loop related to CI index segments. Fixed.

PROD-1353 B_CREATE does not support the use of driver name along with file name. Fixed.

PROD-1347 Browse SQL Table doesn’t work. Fixed.

PROD-1224 MS SQL Driver B_GET_GE error when a Timestamp column is an empty string. Fixed.

PROD-1200 B_OPEN from COBOL fails. Fixed.

PROD-1192 Failed to open FILE.DDF. Error code: 3. Fixed.

PROD-1196 Download link of Quick Start Guide is broken. Fixed.

PROD-2051 About Dialog does not show the migration tool version. Fixed.

PROD-2050 VARBINARY Default values are set along with CONVERT(VARBINARY, <default value>). Fixed.

PROD-2024 Postgres Driver reports an error when mapping Btrieve Time-C data type to Time PostgreSQL data type. Fixed.

PROD-2043 Postgres Driver ATF issues with TIME/TIMESTAMP datatype. Fixed.

PROD-1401 No “COPY in progress” error during data migration. Fixed.

PROD-1411 Postgres Driver Table migrated to a different schema is still being created as public. Fixed.