Excel - fixed a problem when the database is set as source
v23.03.1669
March 27, 2023
- Conversion - fixed a problem with target schema creation
- Comparison - fixed a hang during comparison in some cases
- MySql - removed scale from the float and double data types when creating tables
- MySql - fixed a problem with defaults being quoted two times
- Redshift - fixed the argument out of range problem
v23.02.1668
February 27, 2023
- Project options - added an option to disable the special (slower and safer) processing of self-referencing tables
- Database browser - improved stability, fixed displaying time zone information
- Error and Warning view - fixed some vertical scrollbar problems
- Default values - changed so manually mapped default values are set as is and not always escaped, which lead to problems
- Default values - fixed made mapping source case independent, and fixed some minor errors
- Access - fixed mapping of varbinary columns with 0 precision
- CockroachDb - fixed metadata read
- CockroachDb - fixed identity reset error and index primary key parallel execution problem
- DB2 LUW - optimized and speed up the measuring tables step
- dBase/Foxit - added an unique index when autoincrement columns recognized
- MySQL - fixed a problem with column default values breaking the CREATE TABLE script
- Oracle - fixed reading time zone information from timestamp with time zone columns
- Oracle - fixed importing DateTime data when LOB columns are present in the table
- SIARD - fixed data type mapping for FLOAT columns to be xs:double in the table *.xsd files
- SIARD - fixed writing timestamp values when source contains time zone information
- Sybase ASE - added charset support
- SQL Server - added support for reading of SET NULL foreign key action
- SQL Server - fixed a problem where IDENTITY columns could break the run
- SQL Server - fixed create table script where DEFAULT values would not have escaped single quote
v22.11.1667
November 2, 2022
- Conversion - fixed a table duplication problem with some databases because of casings
- Conversion - do not force NOT NULL on target primary key, instead change the PK to a unique index
- Replication - fixed a problem with some databases when the identity column was not selected
- Options - fixed table name prefix
- Options - removed the Ultimate version options
- Options - moved the “Fetch metadata for selected tables” from Ultimate to Professional version
- Options - fixed missing columns on some databases when table creation mode is ‘Expect existing’
- Browse target - fixed duplication of objects
- Advantage - fixed some problems in metadata processing and made more robust
- DB2 LUW - fixed a deadlock when creating multiple indexes on the same table
- DB2 LUW - fixed an error in the CREATE table script with IDENTITY columns
- SQLite - added source support for fetching indexes
v22.08.1666
August 29, 2022
- Conversion - default schema will now be created if missing
- Comparison - removed the skip equal records option and set it as a standard behavior
- Mapping - data type mapping now supports ranges and any size in source size declaration (e.g. ‘decimal(16..18,4..6)=bigint; varchar(*)=nvarchar(max)’)
- Postgres - added support for SSL certificate and key files (pem files)
- Postgres - improved comparison detection in Postgres versions 12+
- Postgres - added reserved column names
- Progress - added support for all index types
- SQLite - fixed handling of data types marked as unsigned
v22.07.1665
July 27, 2022
- Conversion - fix column comments slipping into collation
- CSV, JSON - exposed data handling option in the target connection screen
- PostgreSQL - fixed a comparison problem with case sensitivity
- PostgreSQL - changed so invalid or null dates are converted to the smallest date and not to the infinity date in some cases
- Progress - upgraded the index detection
- SqlAzure - added authentication modes
v22.07.1664
July 11, 2022
- Replication - added progress and stats while synchronizing data
- Update - download file size is not displayed if unknown
- Logs - fixed a problem where only the first missing table in the expect existing mode was reported
- Firebird, InterBase - fixed reading indexes that are associated with foreign key columns
- MySQL - don’t use bulk insert if the table has LOB types, as it is not stable enough
- Pervasive - updated drivers
- PostgreSQL - fixed handling of CITEXT data type for data bulk loading
- PostgreSQL - handled reading of ‘NaN’ decimal values (will always be read as NULL)
- SQL Server - fixed SET IDENTITY_INSERT OFF not being called in the case of an error while loading data
- SQLite - fixed reading of big numbers
v21.12.1661
December 20, 2021
- Removed the need for metadata read on every run
- Console - respect project options supplied by command-line parameter
- Console - use TLS when sending emails
- Overview - added a "Show invalid tables" filter
- Project options - added a ‘Fetch only selected tables’ option (for databases that only have a few of selected tables)
- Project options - Email support - added a "Send test email" button
- Conversion - fixed some name deduplication problems
- Conversion - delta now skips tables that don't have number types as key columns
- Conversion - fixed a bug when converting between databases with different quotation character
- Conversion - enable remapping of Unicode text types
- Access - fixed connections using Workgroup Information File (System database) *.mdw
- Excel - optimized workflow for big performance gain, especially for large files and files with multiple sheets per file
- Firebird, InterBase - fixed a problem with fetching index metadata
- Firebird, InterBase - fixed reading of unique indexes metadata
- PostgreSQL, Cockroach, RedShift - fixed an error with geo types reporting as not supported
- PostgreSQL, Cockroach, RedShift - when source, fixed the reading of column default values
- SIARD - conform deleteAction and updateAction elements of the foreignKey element definition to the XSL schema when RESTRICT action is used
- SIARD - added support for SQL Server's SQL_VARIANT data type
- SQL Server - added support for primary XML indexes (introduced in version 12 (2014))
- SQL Server - added support for precision in DATETIME2 data type
- SQL Server - really fixed problems with meta queries when "Include views" is enabled
- Sybase (SAP) ASE - fixed reading data from TEXT columns - prevents truncating when data is longer than 32 kB
- Oracle - added warnings when big numbers cannot be represented in .NET decimal range
v21.11.1660
November 19, 2021
- Conversion - in some databases, when the bulk loader fails, it reported all records processed, changed it to report no records processed
- Replication - fixed a problem with some columns always selected in specific cases
- Oracle - bulk loader now reports exact record count
- SQL Server - fixed problems with meta queries when "Include views" is enabled
v21.11.1659
November 17, 2021
Activation - fixed an error preventing manual activation
Replication - fixed a problem with column selection not being saved
Firebird - added support for server version 4 (ODS 13)
Firebird - fixed embedded server not working as expected
MySQL - added support for foreign key actions
v21.10.1658
October 25, 2021
- Conversion - fix index and foreign key options not respected in some database
- DB2 iSeries - support primary and unique constraints
- SQLite - added datetime data type support
- Sybase Advantage - fixed reading of unsupported column types breaking the metadata read
v21.08.1657
August 31, 2021
- Fixed a starting screen problem when onboarding option was turned on
v21.08.1656
August 30, 2021
- Trial - Fixed a problem with FKs not being created in some cases
- Trial - Fixed a problem columns being watermarked multiple times
- Console - Fixed problems when the engine type was overridden
- Log - SQL error log will now log all statements that fail, error log will just have the error message
- Azure SQL - Fixed a driver problem that prevented connections
v21.08.1655
August 19, 2021
- DB2 iSeries - Implemented fast metadata fetch
- SQL Server - reverted to old driver to prolong support for CLR types
v21.08.1654
August 12, 2021
- Massively increased performance when inserting records one at a time. Some databases have no fast insert capability and this will make data load to those targets up to 20x faster.
- Azure SQL - added authentication selection with full support for Azure Active Directory
- Sybase Advantage - removed file locking when connecting to a local database in Client mode
- MySQL - improved compatibility with the new driver, avoiding transaction error sometimes occurring with bulkcopy
v21.08.1653
August 4, 2021
- MySQL - automatically using bulk copy mode when local_infile server variable is set to ON, for significant speedup and reduced memory use
- Custom SQL scripts can now be run on each connection instead of once to allow for connection session initialization
- SIARD - table row level of BLOB message digest (MD5, SHA-1 or SHA-256) should always be represented as hexadecimal string and not base64 string. This fix affects only reading of the SIARD files. Reading and verifying table level SHA-1 and SHA-256 digests stored as hexadecimal string will now work correctly.
v21.04.1644
April 19, 2021
Fixed a MySQL query when when tables need to be escaped
v21.04.1643
April 15, 2021
- Handle additional types when source column value is null, but the target column is not null
- Custom scripts - fixed a problem with the before script
- Expect existing - ignore casing if no matching column is found in some databases
- MySQL - optimize metadata read scripts
- Oracle
- fixed VARCHAR(N CHAR)
- fixed a null insert problem when a value was an empty string in specific cases
- increased the identifier limit to 128 on versions 12.2 and up
- Ask for the trial user's name to improve communication
v21.04.1642
April 8, 2021
- Oracle - fixed an error while converting to an empty database in some server versions
- Conversion - fixed index and foreign key creation
- Replication Logs
- added Diff log
- fixed some Replication Summary log data (added, table count)
v21.03.1641
March 30, 2021
fix table schema mappig
v21.03.1640
March 30, 2021
- Fixed some custom mapping problems
v21.03.1639
March 29, 2021
- Replication - handled Timestamp with timezone to DateTime replication
- Connection - fixed so that the Project option timeout will not affect the connection timeout
- Scheduler - now recognizes tasks of all application types as valid
- Firebird - fixed the C library error
- Oracle - fixed some queries for specific server versions
- Installer
- fixed application remaining in the programs list on uninstall
- fixed remaining empty folders on uninstall
- fixed missing files after application upgrade in specific cases
v21.03.1637
March 18, 2021
- Comparison - fixed review to correctly show tables in case some of the tables had errors
- Replication - fixed review to correctly show tables in case some of the tables had errors
- Connnection - clarified that SSH connections using Public Key Authentication needs a private key file
- Connnection - Connections report more meaningful error messages
MySQL
- fixed crash when index has a functional key part
Oracle - fixed some database queries for older versions
PostgreSQL
- fixed a replication index and primary key problem
- fixed replication and comparison of TIMESTAMP and SQL Server DATETIME2 columns
Siard - fixed project wizard review workers bug
v21.03.1636
March 4, 2021
- Project wizard - optimized metadata read
- Open project - optimized metadata read
- Project options - optimized metadata read
- Connection - show all error messages when not able to connect
- Task scheduler - fixed a bug with the task selection
- Azure SQL - added include views as tables
- Derby - fixed reading of blob data types
- H2 - fixed a memory leak
- ODBC - fixed slow connecting to database
- MySQL - fixed column comments warning
- MySQL - fixed reading of primary key columns metadata
- MySQL - support for reading columns with GEOMETRY and GEOGRAPHY data types
- SIARD - fixed creating foreign keys
- SIARD - fixed row counts for tables
- SIARD - fixed nullability for columns
v21.02.1635
February 11, 2021
- Log - handle locked files (creates a new file with a datetime as a suffix)
- Access - fixed some data errors with NULL and empty strings and money
- Access - added reading of foreign key action (on update/delete)
- Excel - when target, rows now spill into new files instead of throwing an error
- MySQL - char and nchar columns over 255 precision now map to TEXT columns
- MySQL - removed created not needed temporary indexes
- PostgreSQL - FIX OVERRIDING SYSTEM VALUE error on insert on older versions
- PostgreSQL - added reading of foreign key actions (on update/delete)
- Redshift - various fixes and improvements
- SqlServer - fix decimal overflow error when more than 28 digits present (truncate)
v21.01.1634
January 18, 2021
- Optimize on demand metadata get and project validation
v21.01.1633
January 13, 2021
- Project wizard - optimized workflow
- Project run - fixed disconnect error
- Project options - added table and column mapping (* is a wildcard, equals, starts*, *ends, *contains*, ordered by input (new line), first case insensitive match wins, eg, starts*=changedName)
- Conversion - new warning when index creation is skipped because there is an index with the same column sequence
- Conversion - create will respect deselected Incrementing option from Project options
- Conversion - won't try to disable identity insert when the identity is a sequence
- Conversion - won't try to disable identity insert when there is no source and identity (but there is a target)
- MS Access - fix when defaults leading with equality symbol "="
- Removed official support for FileMaker and QuickBooks
v20.12.1632
December 14, 2020
- Fix settings page not going back
v20.12.1631
December 9, 2020
- Conversion - optimized so project wizard does not get target metadata (if needed data is fetched on project options change)
- Conversion - where we can replace the null character with an empty string
- Conversion - added a delta copy option (only copy rows with larger PK than current target MAX)
- Comparison - optimized when only looking for inserts (and key is integral)
- Comparison - added Project option to ignore null characters (enabled by default)
- Comparison - fixed XML comparison (sometimes reported false difference)
- MySQL - fixed reading table comments when more than 10 tables are selected for conversion
- Removed rounding of the total records processed value in the logs
v19.10.1556
October 8, 2019
- Fixed the topological sorting algorithm when "Expect tables to exist" option is used
v19.10.1555
October 7, 2019
- Changed the table list section - it now resizes with the screen
- Analyzing dependencies from the target database metadata when "Expect tables to exist" option is used
- Fixed a rare table mapping dialog issue happening with a new project only
v19.10.1554
October 5, 2019
- Upgraded Postgres database adapter
v19.10.1553
October 4, 2019
- Fixed Postgres database dropdown
v19.10.1551
October 2, 2019
- Changed Firebird default character set to UTF8 (it was None before)
v19.10.1550
October 2, 2019
- Using identity instead of sequences for Postgres 10+
- Spatial data is converted as TEXT to Postgres when PostGIS is not installed to avoid breaking the conversion
v19.10.1549
October 1, 2019
- Added support for DB2 z/OS
- Removed SQL script database engine as that part is better served with our other products
- Fixed SSH tunnelling for remote connection to locked-in environments
- Vector application icon is now used to benefit HiDPI screens
- Updated UI components
- Improved scheduled task error messages
- Improved support for maximum-precision Oracle NUMBER datatype
- Calling commit on every 10k records instead 100k for Oracle target
v19.05.1544
May 24, 2019
- Updated visual components library
v19.05.1543
May 22, 2019
- Fixed Oracle connection broken in the last build
- Fixed broken icons
v19.05.1542
May 21, 2019
- Fixed error messages of the scheduled tasks
v19.05.1541
May 21, 2019
- Updated icons throughout the application
v19.05.1540
May 14, 2019
- Updated SQL Server Compact database driver to v4.0 (old v3.5 databases can be in-place upgraded)
v19.04.1539
April 17, 2019
- Removed VERSION from the list of Firebird reserved words
v19.04.1538
April 16, 2019
- Optimized SSH tunnels by no tearing the tunnels down on each re-connect
- Fixed SSH tunnels connections where the remote machine is connecting to the database on a 3rd machine
v19.03.1537
March 25, 2019
- Added Oracle provider selection (Oracle managed and Devart). It's possible in the future we'll use just one again, but with Oracle's complexity we now want to offer choice to our customers.
- Fixed SIARD backslash path separator in LOB data
- Fixed specification of initial sequence values
v19.02.1536
February 28, 2019
- Adjusted hardware fingerprinting on non-English Windows versions to avoid occasional deactivation via scheduled tasks
v19.02.1535
February 27, 2019
- Added character set selection to Sybase Advantage direct mode
v19.02.1534
February 20, 2019
- Improved table column DEFAULT value translations
v19.02.1533
February 19, 2019
- Added support for huge Sybase Advantage tables
v19.02.1532
February 19, 2019
- Added support for mixed Sybase Advantage databases (DBF/ADT)
v19.02.1531
February 18, 2019
- Improved auto-detection of nullable columns in primary keys and adjustment of both target table definitions and data copying for these cases
v19.02.1530
February 18, 2019
- Added JSON log to the scheduled task
- Reverted to Postgres sequences and removed IDENTITY for PG10+ to fix a starting value bug - will reintroduce IDENTITY later
v19.02.1529
February 12, 2019
- Fixed name escaping of Firebird dialect 1 databases
v19.02.1528
February 12, 2019
- Fixed the error handling certain Postgres domains
v19.01.1527
January 25, 2019
- Improved handling of unicode characters in table and field names (Japanese etc.)
v19.01.1526
January 25, 2019
- Added HSQLDB identity support
v19.01.1525
January 24, 2019
- When decimal datatype is used in source database with identity attribute, Postgres target will now propagate datatype change to int/bigint for such columns, as well as affected foreign key columns
v19.01.1524
January 23, 2019
- Upgraded Derby to v10.14.2.0
v19.01.1523
January 22, 2019
- Added primary key detection for Progress OpenEdge database
- Fixed SIARD restore of Oracle binary FLOAT precision
v18.12.1517
December 12, 2018
- Added support for Interbase and Firebird user roles
- Fixed MySQL/MariaDB SSL connections
v18.12.1516
December 9, 2018
- Fixed FLOAT and REAL datatype creation for SQLCE target
- Fixed handling of maximum database size parameter for SQLCE target
v18.12.1515
December 6, 2018
- From now on, removing umlauts from table and column names when creating database in Firebird target
v18.12.1514
December 5, 2018
- Changed application icon
- Updated UI components and database providers
- Optimized handling of interface element lists
v18.11.1513
November 30, 2018
- Fixed Unicode text regression with new MySQL database provider
v18.11.1512
November 28, 2018
- Fixed handling of Postgres INTERVAL data type
v18.11.1511
November 20, 2018
- Fixed metadata reading of Pervasive decimal number definitions
v18.11.1510
November 16, 2018
- Improved Oracle bulk loader to issue a commit on every 100k records instead of once at the end
v18.11.1509
November 16, 2018
- Extended Sybase Advantage to support both client/server connections and our own direct binary file reading
v18.11.1508
November 16, 2018
- Various fixes for Teradata target
v18.11.1507
November 14, 2018
- Updated SQL Server reserved words list
v18.11.1506
November 13, 2018
- Fixed parsing of Teradata TIMESTAMP precision
v18.11.1505
November 13, 2018
- Redesigned wizard screens to make the buttons stand out more
v18.11.1504
November 12, 2018
- Reworded project wizard final screen to make it clear there are additional customizations available
v18.11.1503
November 12, 2018
- Fixed parsing of default values for MySQL 3.x
v18.11.1502
November 9, 2018
- Fixed reading of certain Teradata datatypes
v18.11.1501
November 8, 2018
- Fixed QuickBooks metadata reading
v18.11.1500
November 7, 2018
- Fixed parsing of MySQL 3.23 metadata
v18.11.1499
November 7, 2018
- Clarified wording on offline activation screen
v18.10.1498
October 29, 2018
- Fixed handling of very old Postgres servers
v18.10.1497
October 25, 2018
- Fixed handling of DB2 bigint type
v18.10.1496
October 23, 2018
- Added reading of referential actions from Sybase SQL Anywhere
v18.10.1495
October 22, 2018
- Fixed index type parsing in Sybase SQL Anywhere
- Improved analysis of default values in Sybase SQL Anywhere
v18.10.1494
October 19, 2018
- Improved handling of BOOLEAN types in SIARD
v18.10.1493
October 19, 2018
- Added Teradata support
- Fixed reading meta-data for MySQL
v18.10.1492
October 16, 2018
- Fixed handling of certain NexusDB table column default values
v18.10.1491
October 16, 2018
- Changed MySQL database provider to provide compatibility with all MySQL Servers versions (3.23 and later)
v18.10.1490
October 12, 2018
- Sybase Advantage database support rewritten to use Advantage Server
- Fixed NexusDB list of reserved words
- Removed exclusive lock on log files during the conversion time, so they can be inspected while conversion is still running
v18.10.1489
October 5, 2018
- Fixed handling of NexusDB Extended datatype
v18.10.1488
October 1, 2018
- Added schema mapping override console parameter
v18.09.1487
September 28, 2018
- Upgraded NexusDB database provider
v18.09.1486
September 24, 2018
- Fixed H2 target date encoding
v18.09.1485
September 20, 2018
- Fixed SIARD 2.1 compatibility issues
- Temporarily downgraded Postgres database provider as some users reported problems with the new one
v18.09.1484
September 19, 2018
- Added support for ENUM types in Postgres
v18.09.1483
September 14, 2018
- Fixed compatibility issues with certain Postgres server versions
v18.09.1482
September 14, 2018
- Added support for Advantage indexes
v18.09.1481
September 14, 2018
- Fixed automatic creation of target Postgres database when name is given in mixed-case
v18.09.1480
September 6, 2018
- Updated supporting libraries
- Align SIARD 2.1 support to the specification for storing string data containing single or multiple consecutive space characters
v18.09.1478
September 3, 2018
- Added support for SQLite autoincrement columns (integer primary key)
v18.08.1477
August 21, 2018
- Fixed handling of certain Access driver expections
v18.08.1476
August 20, 2018
- Added support for Amazon RedShift
v18.08.1475
August 16, 2018
- Added support for SIARD 2.1
- Added int datatype to SQLite target instead of forcing bigint for all integral types
v18.08.1474
August 7, 2018
- Improved auto-detection of Paradox and Interbase databases
v18.08.1473
August 7, 2018
- Added missing IKVM dlls
- Fixed HSQLDB reserved word handling
v18.08.1472
August 6, 2018
- Fixed Informix boolean datatype detection
- Fixed reading of MySQL data types from SQL script files
v18.08.1471
August 1, 2018
- Updated support for Java databases (Derby, H2, HSQLDB)
v18.08.1470
August 1, 2018
- Fixed certain edge cases in Paradox BCD data reading
v18.07.1469
July 23, 2018
- Fixed reading of Paradox BCD and graphic fields
v18.07.1468
July 18, 2018
- Applied target casing for index column names to fix index creation issues in certain project configurations
v18.07.1467
July 5, 2018
- Improved support for Postgres timestamp with timezone type
v18.07.1466
July 2, 2018
- Improved support for Ingres blank date configuration setting, again
v18.06.1465
June 29, 2018
- Fixed Oracle index reading for cases when index owner is different than table owner
- Changed Oracle index naming, removed schema prefix from the name
v18.06.1464
June 28, 2018
- Fixed handling of Firebird triggers with empty definition
v18.06.1463
June 20, 2018
- Added support for Ingres blank date configuration setting
v18.06.1462
June 19, 2018
- Fixed PostgreSQL bytea loading in single-record insert mode
v18.06.1461
June 18, 2018
- Updated Progress reserved words
v18.06.1460
June 13, 2018
- Improved Excel compatibility with certain combination of Microsoft Windows and .NET Framework
v18.06.1459
June 12, 2018
- Improved Firebird compatibility with certain combination of Microsoft Windows and .NET Framework
- Fixed Access target bulk load
v18.06.1458
June 11, 2018
- Fixed SIARD application descriptor
v18.06.1457
June 8, 2018
- Added a warning when we force a column to be NOT NULL due to the fact it's a part of primary key
v18.06.1456
June 6, 2018
- Added more required files to the installer
v18.06.1455
June 5, 2018
- Fixed Interbase connector having a missing DLL
v18.06.1454
June 5, 2018
- Added support for MySQL 8.0 target database creation
- Added support for Pervasive bit datatype
- Fixed Oracle cascade constraints
- Fixed Progress reserved words detection
v18.05.1453
May 16, 2018
- Added support for MySQL/MariaDB OVER keyword
v18.05.1452
May 15, 2018
- Upped .NET Framework requirement to version 4.6.1 or later (Microsoft's limitation due to the fact we are migrating most of our projects to be cross-platform for upcoming cloud solutions)
- Updated MySQL connector for compatibility with new MySQL 8.0 default authentication mode
v18.04.1451
April 27, 2018
- Fixed ODBC connection string validation
v18.04.1450
April 27, 2018
- Added handling of Firebird triggers with empty definition
v18.04.1449
April 23, 2018
- Improved display of source database's data types in SIARD archive
v18.04.1448
April 20, 2018
- Improved compatibility with old versions of Gupta SQLBase
v18.04.1447
April 17, 2018
- Improved offline activation process
v18.04.1446
April 16, 2018
- Changed internal column delimiter for Vertica target's bulk copy from pipe character to zero-byte character.
v18.04.1445
April 16, 2018
- Improved error handling of invalid console parameters
v18.04.1444
April 16, 2018
- Included build number in SIARD target producerApplication field
v18.04.1443
April 11, 2018
- Improved compatibility loading of old Full Convert 5 project files
v18.04.1442
April 11, 2018
- Turned on compression for SIARD output by default
v18.04.1441
April 11, 2018
- Fixed Vertica bulk loading of long binary and text data
- Added reporting of rejected records for Vertica bulk loader
- Added recognition of invalid connection parameters and warning the user before connection attempt
v18.01.1400
January 26, 2018
- Fixed SIARD XSD validation
v18.01.1398
January 26, 2018
- Simplified GUI for SIARD External LOB folder parameter
v18.01.1397
January 24, 2018
- Added support for relative log paths
v18.01.1396
January 19, 2018
- Optimized internal memory usage for databases with many thousands of tables
- Streamlined UI for table selection in the project wizard
v18.01.1395
January 18, 2018
- Allow reopening existing SIARD database as target, use read-only mode as this is an archival format
v18.01.1394
January 18, 2018
- Create SIARD target database only when the file does not contain any tables
v18.01.1393
January 16, 2018
- Added support for geography, geometry and hierarchyid datatypes for SIARD target
- Improved conversion review screen when fatal error happened
v18.01.1392
January 15, 2018
- Added automatic handling of multiple worksheets in Excel files
v18.01.1391
January 15, 2018
- Added warnings for notifications during conversion that aren't critical
v18.01.1390
January 9, 2018
v17.12.1388
December 19, 2017
v17.12.1387
December 18, 2017
v17.12.1386
December 11, 2017
v17.12.1385
December 11, 2017
v17.12.1384
December 8, 2017
v17.12.1383
December 8, 2017
v17.12.1382
December 5, 2017
v17.11.1379
November 29, 2017
v17.11.1378
November 27, 2017
v17.11.1377
November 24, 2017
v17.11.1376
November 22, 2017
v17.11.1375
November 22, 2017
v17.11.1374
November 20, 2017
v17.11.1373
November 20, 2017
v17.11.1371
November 20, 2017
v17.11.1370
November 17, 2017
v17.11.1369
November 17, 2017
v17.11.1368
November 15, 2017
v17.11.1367
November 14, 2017
v17.11.1365
November 14, 2017
v17.11.1364
November 14, 2017
v17.11.1363
November 13, 2017
v17.11.1362
November 13, 2017
v17.11.1361
November 10, 2017
v17.11.1359
November 10, 2017
v17.11.1358
November 10, 2017
v17.11.1357
November 10, 2017
v17.11.1356
November 10, 2017
v17.11.1355
November 10, 2017
v17.11.1354
November 9, 2017
v17.11.1353
November 7, 2017
v17.11.1352
November 7, 2017
v17.11.1351
November 7, 2017
v17.11.1350
November 3, 2017
v17.11.1349
November 2, 2017
- Added embedded Firebird servers to be able to open all Firebird files even when user has no Firebird server installed.
v17.10.1348
October 31, 2017
v17.10.1347
October 31, 2017
v17.10.1346
October 30, 2017
v17.10.1345
October 24, 2017
v17.10.1344
October 23, 2017
v17.10.1343
October 20, 2017
v17.10.1342
October 19, 2017
v17.10.1341
October 19, 2017
v17.10.1340
October 19, 2017
v17.10.1339
October 18, 2017
v17.10.1338
October 18, 2017
v17.10.1337
October 18, 2017
v17.10.1336
October 17, 2017
v17.10.1335
October 17, 2017
v17.10.1334
October 12, 2017
v17.10.1333
October 12, 2017
v17.10.1332
October 11, 2017
v17.10.1331
October 11, 2017
v17.10.1330
October 11, 2017
v17.10.1329
October 10, 2017
v17.10.1328
October 9, 2017
v17.10.1327
October 5, 2017
- New versioning scheme. Taken from Ubuntu Linux: Year.Month.Build. It makes much more sense with our continuous , almost daily, deployment of features.
- Oracle views can now be read as tables
- We can now read SQL script files and directly migrate them to target databases. Table selection, column mapping etc. are fully supported.
Full Convert 7.9 released
December 29, 2016
- New installer
- Faster metadata reading for certain databases
- Faster Oracle bulk data loading
- List of scheduled tasks now updates in real-time
- Added LocalDB support
- Added support for different character sets for Pervasive
- Added support for new MySQL JSON datatype
- Added support for new Firebird bool datatype
- Improved Sybase Advantage file reader
- Fixed scheduled tasks permissions issues for certain environments
- Fixed logging of SQL errors
v7.9.1082
January 19, 2017
v7.9.1081
January 19, 2017
v7.9.1076
January 19, 2017
v7.9.1075
January 13, 2017
v7.9.1074
January 11, 2017
v7.9.1073
January 11, 2017
v7.9.1072
December 30, 2016
v7.9.1071
December 30, 2016
Full Convert 7.8 released
September 21, 2016
- Added full support for SQL Express LocalDB
v7.8.1020
September 26, 2016
v7.8.1019
September 26, 2016
v7.8.1018
September 23, 2016
v7.8.1017
September 22, 2016
v7.8.1016
September 22, 2016
v7.8.1014
September 21, 2016
v7.8.1013
September 21, 2016
Full Convert 7.7 released
August 26, 2016
- Add support for overriding connection parameters in console
- Using default system proxy when communicating with Spectral Core licensing server
- Improved tracing to preserve data across application runs
v7.7.1012
September 20, 2016
v7.7.1011
September 16, 2016
v7.7.1010
September 15, 2016
v7.7.1009
September 15, 2016
v7.7.1004
September 15, 2016
v7.7.1004
September 15, 2016
v7.7.1003
September 15, 2016
v7.7.1002
September 9, 2016
v7.7.1001
September 9, 2016
Full Convert 7.6 released
July 11, 2016
- Massive speedup handling huge databases with hundreds of thousands of tables
- Support Gupta SQLBase for both reading and writing
- Support Ingres for both reading and writing
- Implemented native Sybase Advantage reader, no drivers needed
- Project-wide nullability enforcing
- Timestamp-named logs now respect specified folder
- We are now skipping disabled and untrusted foreign keys
- Fixed SQL Compact
- Add support for bigint data in CSV instead of promoting immediately to double datatype
- Respect SQL Server compatibility setting
- Added tracing information customer can send to developers when asked
Full Convert 7.5 released
April 26, 2016
- Allow specification of list of tables to convert via console arguments
- Improve spatial data conversion
- Fixed running of custom SQL scripts before and after conversion
Full Convert 7.4 released
April 7, 2016
- Optimized database structure reading to greatly reduce time needed for project loading and common operations
- SSL connections
- SSH tunnel for secure connections to remote servers
- Optimized options applying - table remapping only when options that affect mapping are changed
Full Convert 7.3 released
March 8, 2016
- Added custom WHERE clause
- Added troubleshooting option to never disconnect (some ODBC drivers crash on disconnect)
Full Convert 7.20 released
September 5, 2017
- Added support for FileMaker source database
Full Convert 7.2 released
February 16, 2016
- Improved and clarified progress screen
- Added option to display data loading progress in circular chart
- Bugfixes
v7.20.1324
October 3, 2017
v7.20.1323
October 2, 2017
v7.20.1322
October 2, 2017
v7.20.1321
October 2, 2017
v7.20.1320
September 30, 2017
v7.20.1319
September 26, 2017
v7.20.1318
September 26, 2017
v7.20.1317
September 26, 2017
v7.20.1316
September 25, 2017
v7.20.1315
September 25, 2017
v7.20.1314
September 22, 2017
v7.20.1311
September 21, 2017
v7.20.1310
September 21, 2017
v7.20.1309
September 21, 2017
v7.20.1308
September 21, 2017
v7.20.1307
September 18, 2017
v7.20.1306
September 18, 2017
v7.20.1305
September 18, 2017
v7.20.1304
September 15, 2017
v7.20.1303
September 15, 2017
v7.20.1302
September 13, 2017
v7.20.1301
September 13, 2017
v7.20.1300
September 12, 2017
v7.20.1299
September 8, 2017
v7.20.1298
September 8, 2017
v7.20.1296
September 7, 2017
v7.20.1293
September 6, 2017
v7.20.1292
September 5, 2017
Full Convert 7.19 released
September 4, 2017
- Bug fixes
v7.19.1290
September 5, 2017
v7.19.1289
September 5, 2017
v7.19.1288
September 5, 2017
v7.19.1287
September 5, 2017
v7.19.1286
September 5, 2017
v7.19.1285
September 5, 2017
v7.19.1284
September 5, 2017
v7.19.1283
September 5, 2017
v7.19.1278
August 29, 2017
v7.19.1277
August 29, 2017
v7.19.1276
August 29, 2017
v7.19.1275
August 28, 2017
v7.19.1274
August 28, 2017
Full Convert 7.18 released
July 31, 2017
- Rewritten and simplified schema mapping
v7.18.1270
August 21, 2017
v7.18.1269
August 21, 2017
v7.18.1268
August 21, 2017
v7.18.1267
August 18, 2017
v7.18.1266
August 18, 2017
v7.18.1265
August 16, 2017
v7.18.1264
August 11, 2017
v7.18.1263
August 2, 2017
v7.18.1262
August 2, 2017
v7.18.1261
August 2, 2017
v7.18.1260
August 2, 2017
v7.18.1259
July 31, 2017
v7.18.1258
July 31, 2017
Full Convert 7.17 released
July 21, 2017
- Intuit QuickBooks supported for reading via its QODBC driver
v7.17.1256
July 30, 2017
v7.17.1255
July 30, 2017
v7.17.1254
July 28, 2017
v7.17.1253
July 28, 2017
v7.17.1252
July 28, 2017
v7.17.1251
July 28, 2017
v7.17.1250
July 28, 2017
v7.17.1249
July 28, 2017
v7.17.1248
July 27, 2017
v7.17.1247
July 27, 2017
v7.17.1246
July 27, 2017
v7.17.1245
July 27, 2017
v7.17.1244
July 27, 2017
v7.17.1243
July 27, 2017
v7.17.1242
July 27, 2017
v7.17.1241
July 27, 2017
v7.17.1240
July 27, 2017
v7.17.1239
July 25, 2017
v7.17.1238
July 25, 2017
v7.17.1237
July 21, 2017
v7.17.1236
July 21, 2017
Full Convert 7.16 released
July 14, 2017
- Added full support for Vertica as source and target database
- Added Sybase SQL Anywhere and Sybase IQ view reading as if they are tables
v7.16.1235
July 19, 2017
v7.16.1234
July 19, 2017
v7.16.1233
July 14, 2017
v7.16.1232
July 14, 2017
v7.16.1230
July 14, 2017
v7.16.1229
July 14, 2017
Full Convert 7.15 released
July 11, 2017
- JSON log with rich information added
- Added Sybase ASE view reading as if they are tables
- Improved handling of complex custom Oracle SQL scripts
- Improved handling of unexpected application crashes
v7.15.1227
July 13, 2017
v7.15.1226
July 12, 2017
v7.15.1225
July 11, 2017
Full Convert 7.14 released
June 12, 2017
- Added character set specification for CSV files
- Improved PostgreSQL sequence creation - all valid datatypes can now be incrementing
v7.14.1224
June 22, 2017
v7.14.1223
June 22, 2017
v7.14.1222
June 21, 2017
v7.14.1221
June 20, 2017
v7.14.1220
June 20, 2017
v7.14.1219
June 20, 2017
v7.14.1218
June 17, 2017
v7.14.1217
June 16, 2017
v7.14.1216
June 15, 2017
v7.14.1218
June 12, 2017
v7.14.1217
June 12, 2017
Full Convert 7.13 released
May 3, 2017
- added dBase 3 target format
- improved installer to not require uninstall of prior version when there is a new build in current minor release
- no longer registering Interbase provider due to incompatibility with some systems and using private registration instead
- allowing long table names with DBF target even in old formats
- improved UI consistency in table listing across the application
v7.13.1216
June 7, 2017
v7.13.1215
June 5, 2017
v7.13.1214
June 5, 2017
v7.13.1213
June 5, 2017
v7.13.1212
June 2, 2017
v7.13.1211
June 1, 2017
v7.13.1210
June 1, 2017
v7.13.1209
May 28, 2017
v7.13.1208
May 27, 2017
v7.13.1207
May 26, 2017
v7.13.1206
May 26, 2017
v7.13.1205
May 26, 2017
v7.13.1204
May 24, 2017
v7.13.1203
May 23, 2017
v7.13.1202
May 23, 2017
v7.13.1201
May 23, 2017
v7.13.1200
May 19, 2017
v7.13.1199
May 18, 2017
v7.13.1198
May 17, 2017
v7.13.1196
May 14, 2017
v7.13.1195
May 12, 2017
v7.13.1195
May 12, 2017
v7.13.1194
May 12, 2017
v7.13.1193
May 8, 2017
v7.13.1192
May 5, 2017
v7.13.1191
May 3, 2017
Full Convert 7.12 released
March 10, 2017
- added GUID support for HSQLDB database
- expanded CSV datatype detection such that numbers with leading zero and decimals with trailing zero (but not .0 exactly) are detected as text
- added support for SQLCE databases up to 4GB in size
- automatically reopen PostgreSQL connection in case when remote server closes it to avoid multiplying of reported errors
- automatically format time values in generated Excel documents
- improved handling of invalid log filenames
v7.12.1190
May 3, 2017
v7.12.1189
May 3, 2017
v7.12.1188
May 3, 2017
v7.12.1187
May 2, 2017
v7.12.1186
May 2, 2017
v7.12.1185
May 1, 2017
v7.12.1184
April 27, 2017
v7.12.1183
April 26, 2017
v7.12.1182
April 26, 2017
v7.12.1181
April 25, 2017
v7.12.1180
April 24, 2017
v7.12.1179
April 24, 2017
v7.12.1179
April 13, 2017
v7.12.1178
April 13, 2017
v7.12.1177
April 13, 2017
v7.12.1176
April 11, 2017
v7.12.1175
April 10, 2017
v7.12.1174
April 10, 2017
v7.12.1173
April 7, 2017
v7.12.1172
April 6, 2017
v7.12.1172
April 6, 2017
v7.12.1172
April 6, 2017
v7.12.1170
April 5, 2017
v7.12.1168
April 4, 2017
v7.12.1167
April 4, 2017
v7.12.1166
April 3, 2017
v7.12.1165
April 3, 2017
v7.12.1164
March 30, 2017
v7.12.1163
March 29, 2017
v7.12.1162
March 28, 2017
v7.12.1161
March 27, 2017
v7.12.1160
March 26, 2017
v7.12.1159
March 24, 2017
v7.12.1158
March 22, 2017
v7.12.1157
March 22, 2017
v7.12.1155
March 21, 2017
v7.12.1154
March 21, 2017
v7.12.1153
March 21, 2017
v7.12.1152
March 21, 2017
v7.12.1151
March 21, 2017
v7.12.1151
March 21, 2017
v7.12.1151
March 21, 2017
v7.12.1150
March 21, 2017
v7.12.1149
March 20, 2017
v7.12.1148
March 20, 2017
v7.12.1147
March 19, 2017
v7.12.1146
March 19, 2017
v7.12.1145
March 17, 2017
v7.12.1144
March 17, 2017
v7.12.1143
March 17, 2017
v7.12.1142
March 15, 2017
v7.12.1141
March 10, 2017
Full Convert 7.11 released
March 2, 2017
- completely rewritten Excel support, several orders of magnitude speedup!
- added character set override option for DBF files
v7.11.1140
March 9, 2017
v7.11.1139
March 9, 2017
v7.11.1138
March 9, 2017
v7.11.1137
March 9, 2017
v7.11.1136
March 9, 2017
v7.11.1135
March 9, 2017
v7.11.1134
March 9, 2017
v7.11.1133
March 8, 2017
v7.11.1132
March 8, 2017
v7.11.1131
March 7, 2017
v7.11.1130
March 7, 2017
v7.11.1129
March 7, 2017
v7.11.1128
March 6, 2017
v7.11.1127
March 6, 2017
v7.11.1126
March 6, 2017
v7.11.1125
March 6, 2017
v7.11.1124
March 3, 2017
v7.11.1123
March 3, 2017
v7.11.1122
March 2, 2017
v7.11.1121
March 2, 2017
v7.11.1119
March 2, 2017
Full Convert 7.10 released
January 23, 2017
- Added ability to read views for MySQL, Interbase and Firebird source databases
Full Convert 7.1 released
February 11, 2016
- All known bugs from the launch fixed
- Default values mapping
- Edit project connections anytime
- Allow loading project with invalid database connections and edit them post-load
v7.10.1118
March 1, 2017
v7.10.1117
March 1, 2017
v7.10.1116
March 1, 2017
v7.10.1115
March 1, 2017
v7.10.1114
February 28, 2017
v7.10.1113
February 28, 2017
v7.10.1112
February 28, 2017
v7.10.1111
February 21, 2017
v7.10.1110
February 18, 2017
v7.10.1108
February 18, 2017
v7.10.1107
February 17, 2017
v7.10.1106
February 17, 2017
v7.10.1105
February 17, 2017
v7.10.1104
February 16, 2017
v7.10.1103
February 15, 2017
v7.10.1102
February 15, 2017
v7.10.1101
February 13, 2017
v7.10.1101
February 13, 2017
v7.10.1100
February 9, 2017
v7.10.1099
February 8, 2017
v7.10.1097
February 3, 2017
v7.10.1096
February 2, 2017
v7.10.1094
February 2, 2017
v7.10.1092
January 30, 2017
v7.10.1089
January 27, 2017
v7.10.1088
January 27, 2017
v7.10.1087
January 27, 2017
v7.10.1086
January 27, 2017
v7.10.1084
January 23, 2017
Full Convert 7.0 released
January 22, 2016
Complete rewrite in a new technology!
All application areas have been greatly improved.
Significant performance boost.
Added support for following databases:
- IBM DB2
- Derby
- H2
- HSQLDB
- NexusDB
- Pervasive PSQL
- Progress OpenEdge
- Sybase Adaptive Server Enterprise
- Sybase SQL Anywhere
- VistaDB
Full Convert 6.9 released
October 8, 2014
Added support for PostgreSQL OID datatype
Full Convert 6.8 released
October 1, 2014
Fixed a nasty SQLCE bug where opening a database could cause it to be truncated
Improvements in SQLite default values handling
Bugfixes
Full Convert 6.7 released
July 18, 2014
Added ODBC dialect
Bugfixes
Full Convert 6.6 released
May 28, 2014
Improved trial activation process
Added number of tables to be converted (and skipped) to the project wizard to avoid confusion when table name filter is used
Bugfixes
Full Convert 6.5 released
May 5, 2014
Respecting Firebird and Interbase maximum identifier length of 31 characters, making sure target identifiers are never duplicated
Updated database components
Bugfixes
Full Convert 6.4 released
February 28, 2014
Much improved speed of reading Oracle metadata for large databases
Table filter in project wizard
Selective drop of foreign keys before dropping target table
Added indexes and constraints (both can be individually deselected) to table customization dialog
Added information of eventual fatal error to error list
Indexes and constraints are created separately instead in batch per table
Progress dialog lists information about each index and constraints as they are created
Full Convert 6.3 released
February 10, 2014
Separate log for SQL that caused errors
Bugfixes
Full Convert 6.2 released
October 28, 2013
Separate console application with much improved capabilities
Bugfixes
Full Convert 6.11 released
November 20, 2014
Computed columns are now skipped when copying into existing tables
Full Convert 6.10 released
October 23, 2014
Added support for PostgreSQL TSVECTOR datatype
Full Convert 6.1 released
September 5, 2013
Added VisualFoxPro table selection from DBC file
Slightly changed conversion summary screen
Project customization status visible on ribbon
All customer issues reported after v6.0 launch fixed
Full Convert 6.0 released
August 22, 2013
Largest update we have ever made!
Completely redesigned and modernized user interface
Instant help when connecting to databases
Support for any XML structure and intelligent creation of optimal target tables to represent original hierarchical structure
Full support for SQLite
dBase (DBF) is now supported as a target database
Encrypted Paradox tables are decrypted on the fly during conversion without even asking for a password
Much faster writing of BLOB data to SQL Server using BULK INSERT
Improved Excel engine
Overall improved performance and responsiveness
Improved conversion summary
Improved technical support - errors are automatically reported to developers and support tickets can be opened from the application
In-app upgrade
Bulk folder definition for each target database server computer separately
Full Convert 5.9 released
November 11, 2010
Added checks if source and target database are the same. This is not allowed so that our users don't accidentally drop tables in source database, too.
Added fast chunking support to PostgreSQL source
Changed GUID conversion to MySQL to have { and } enclosing characters removed
We now automaticaly use Oracle UNISTR function when inserting Oracle data (not used in LOAD mode) when Unicode data is selected. This allows for automatic Unicode character insertion into databases with non-Unicode character set.
In trial version we won't try to show nag window when quiet mode is used (in scheduled run)
Fixed conversion of Oracle LONG values to SQL Server varbinary(max) - used with SQL2005+
Fixed conversion of SQL Server defaults containing Unicode strings
Fixed an error when resolving dependencies from tables not included in the conversion
Full Convert 5.8 released
September 23, 2010
Added support for Excel cells containing very large text blocks
Added support for creating new Access 2007-2010 databases
Added a progress dialog when refreshing target database, as with large databases it takes some time
Fixed datetime default value translation for Interbase/Firebird target
Fixed showing of created XLSX documents for target databases
Fixed showing of created XML documents for target databases when table is not expanded in database tree
Fixed automatic expansion of \r and \n characters into \r\n for SQL Server target
Full Convert 5.7 released
August 18, 2010
Fixed reading of Oracle materialized views
Fixed creation of foreign keys in Oracle in cases when source table didn't have needed indexes in place
Fixed rare crashes when closing the application
Full Convert 5.6 released
July 22, 2010
Added encryption support to SQL Server connection
Added non-standard port support to SQL Server connection
Added per-project setting for text file header and footer line skip count
Improved compatibility with Firebird 1.x
Improved task scheduler error reporting. Unsupported option combinations are now clearly explained.
Modified GUID translation to Oracle - instead of VARCHAR(38) it is now translated to RAW(16)
Fixed bug with Paradox graphic fields
Fixed saving of text connection parameters in project
Full Convert 5.5 released
June 1, 2010
Added support for XML schema. This allows easy conversion of standard XML datasets.
Added support for XML target! You can now easily export from any database to XML datasets.
Added 'No data' option to Customize Table dialog.
Improved handling of duplicate object names. We now rename target objects before conversion when duplicates are detected to avoid errors. Of course, you can still set proper names yourself in Customize Table dialog.
Improved schema handling - added option to recreate all schemas, use schemas as table prefixes, or ignore schema information (default)
Turned out that Oracle doesn't allow ROWID column name, even if it is enclosed with double quotes. Forced rename of such identifiers to ROWID_ from now on for Oracle target.
Fixed detection of certain Oracle indexes
Fixed extra empty row showing up for Excel source documents with header row
Fixed dynamic chunk creating in cases where primary key consists of very large integral numbers (>=16 digits)
Full Convert 5.4 released
May 17, 2010
Improved ODBC support, removed dependency on ODBC 3.0 compliant drivers
Improved support for PostgreSQL 7.x
Added ability to use multi-character delimiters for text files
Removed trimming of table field names when they have dot in a name
Fixed parsing of dBase 3 memo fields
Full Convert 5.3 released
April 16, 2010
Enforced index and constraints auto-renaming for Oracle and Postgres target regardless of the Options, as too many users were unaware of the option and got errors for duplicate names
Improved support for PostgreSQL
Improved support for old Oracle versions (8i)
Improved handling of duplicate fields in DBF tables
Improved speed of parsing invalid dates in DBF tables
Added hard limit to 10 records in SQL Server target extended inserts (SQL Server blocks hard on high batch, unlike MySQL which is very, very fast there)
Full Convert 5.24 released
April 23, 2013
Fixed scheduler on Windows server machines
Added option to disable use of UNISTR function when inserting data to Oracle
Full Convert 5.23 released
February 22, 2013
Fixed ODBC table structure parsing
Full Convert 5.21 released
November 20, 2012
PostgreSQL identifiers are now forced to lower case because PostgreSQL does not adhere to SQL standards. This allows customers not to use quotes to reference tables later.
Full Convert 5.20 released
October 18, 2012
Numerous bugfixes
Full Convert 5.2 released
January 13, 2010
Added automatic creation of a target database for Postgres engine
Added support for MySQL servers with ANSI_QUOTES configuration turned on
Extended NVARCHAR maximum length in MySQL to 65535 characters
Improved representation of connection errors to end user. We now show more user-friendly dialog with a direct link to appropriate online documentation page.
Improved conversion speed for all users who use Table Settings. We now turn the fast bulk mode off only if user actually declared SQL expressions to calculate new data on the fly.
Improved chunking code to use unique indexes when table doesn't have primary key.
Added transfer mode display to the progress dialog. You can now see if bulk mode is used, if table is chunked or not, etc.
Added support for old Postgres databases (<7.4), which use old frontend protocol for communication
Automatically removing 8-byte image header from Paradox graphic fields
Improved parsing of dBase/FoxPro CDX index files (CDX)
Improved recognition of ODBC datatypes
Changed default connection mode for Oracle to "Direct TCP/IP" from current "Oracle client"
Fixed and improved Access table properties changing. Renaming Access tables is now instant.
Fixed project customization column case bug where Unchanged case cleared column case
Fixed handling of PostgreSQL schemas
Fixed conversion of certain datatypes to PostgreSQL
Fixed parsing of SQL Server Compact table names which caused them to fail converting.
Fixed Paradox long memos handling, where memos were truncated to 20.000 characters
Fixed dBase DBT memos reading
Fixed translation of MySQL bit default values to SQL Server
Fixed memory leaks which become an issue with databases containing over 30k tables
Fixed datatype and default values advanced mappings handling
Full Convert 5.19 released
April 30, 2012
Completely rewritten ODBC support
Support for ODBC as source and for target! This means you can convert basically any popular database into any other.
Bug fixes
Full Convert 5.18 released
November 24, 2011
Added basic usage tracking to trial version to learn where are the problem areas for first-time users
Added auto-create of Interbase/Firebird database if it doesn't exist
Fixed reading of MySQL multiple column indexes
Fixed Interbase/Firebird minimum timestamp value
Fixed delimited text and XML target filename when source is Excel document with multiple sheets
Fixed execution of complex custom SQL script for SQL CE
Fixed conversion of identifier to valid identifier when it is numeric and contains dots
Full Convert 5.17 released
October 4, 2011
SQL Server UID field is now converted to MySQL binary(16) instead of to VARCHAR(38)
Fixed various bugs
Full Convert 5.16 released
August 15, 2011
Changed delimited text parsing behavior. When 'quotes enclosing' is set to 'strings values', we preserve character data type instead of casting it to numbers when we can.
Fixed various bugs
Full Convert 5.15 released
June 16, 2011
Replaced crappy XlsReadWriteII Excel components with much more reliable NativeExcel components
Auto-detect empty Excel cells and using only used section of the sheet
Fixed bug in 'Interpred dates in years 0000-0099 as 1900-1999' option handling
Full Convert 5.14 released
June 13, 2011
Fixed nasty bug in table customization where certain settings from last table were remembered and applied to all tables
Full Convert 5.13 released
May 19, 2011
Updated our native database components
Added warning when obsolete table customization is detected
Fixed bug in reordering tables causing errors when using Recreate Data mode
Fixed bug which cause Oracle Fast Loader not to be used when table was customized
Full Convert 5.12 released
May 5, 2011
Optimized internal data structures for significantly faster handling of databases with many tables
Added notification if BULK INSERT is disabled for SQL Server target
Fixed Postgres 8.0 metadata reading
Full Convert 5.11 released
March 29, 2011
Improved handling of invalid date values for NOT NULL target columns. We will now use minimum allowed value for a specific datatype used
Full Convert now migrates comments for tables and columns if target database supports that feature
Oracle RAW(x) datatype is now converted to BINARY(x) SQL Server datatype when possible
Fixed bulk insert handling of SQL Server target binary data
Full Convert 5.10 released
January 10, 2011
Added handling of complex default values (function calls and expressions) to MySQL target. As MySQL doesn't support that, we now create before insert trigger and set those values there.
Paradox reader no longer attempts to place a write lock on the files
Changed DBF file NULL value parsing - empty numeric values will now be read as NUL
Fixed PostgreSQL target blob data writing
Fixed Excel target data truncation when source database is read in chunks
Fixed XML target data truncation when source database is read in chunks
Fixed CSV target header row multiplication on each target chunk when header row writing is turned on
Fixed new file generated on each run - small temporary file was not deleted properly
Fixed datatype and defaults mapping reloading - you needed to exit the application for new mappings to be recognized. No more.
Fixed trial version bug causing 'can't find field' error for certain table fields
Fixed NULL default values for Oracle DATE fields
Fixed parsing of Oracle constraints when table is in non-default schema
Fixed crash when MySQL target user doesn't have SHOW DATABASES privilege
Full Convert 5.1 released
September 1, 2009
Much improved ODBC support
Added defaults mapping so you can now override your complex default values with proper native target counterparts. Options have been updated so we made a new Mappings section.
Added quick help for connecting in the Project Settings
Fixed SQL Server IDENTITY_INSERT bug introduced in v5.0
Fixed handling of Null value in Paradox TIMESTAMP fields
Many bug-fixes throughout the application
Full Convert 5.0 released
July 13, 2009
Conversion engine rewritten so that .NET framework is no longer required. This considerably reduces installation size and memory consumption, improves conversion speed and user interface responsiveness.
Handling of huge databases is taken to the next level using advanced algorithm for partial data loading. Now memory consumption is low and constant, so you can convert hundreds of GB without touching any options. Converting of huge databases is now very fast as database server isn't burdened with calculating chunk positions so you typically won't even notice that tables are read in chunks during conversion.
Added handling of user erroneously opening a database file using Open Project button. Full Convert will now recognize the file type and start a new conversion wizard with the opened file as a source.
Added support for Excel 2007 files as a target. For each project, choose whether you want Excel97 or Excel2007 output.
Excel doesn't have to be installed as we use native Excel read/write components for maximum speed and reliability.
Table Settings dialog now notifies that filter is not available for non-relational source databases
Improved handling of TEXT target database. Full Convert now uses very little memory (and a constant amount) as output text is streamed directly to file and we take advantage of our advanced partial data loading algorithm.
When you open data in grid, it will now by default be best-fitted for optimal display if table has up to 5.000 records. This behavior can be changed in the Options dialog.
SQL Server Compact Edition database maximum size increased to 4GB
Added a fast SQL Server detection. It will only detect local SQL Server instances to avoid lag, and Server field will be filled right away with the first instance detected.
By default, from now on MySQL target uses database default for table engine (i.e. Full Convert will not specify it). It's still overridable in Options.
Added NDBCLUSTER table engine for MySQL target
If you specify MySQL database which doesn't exist as a target, Full Convert will ask if you wish it to create it for you automatically.
Added support for SQL_VARIANT SQL Server data type. When you convert it to other database engines, we copy it as a BLOB.
Added option to generate sqlplus compatible output for Oracle target
Added support for multiple double-quotes in CSV text files. For example: "This is ""quoted"" inside a string by specifying each quote twice" now parses properly.
Added option to reconnect to both source and target database on each conversion and reread the metadata if you want to make sure you have the latest info.
Improved progress dialog. You can now instantly cancel long-running Oracle direct-load transfers. Also, visual clue added when slow parameterized mode is used due to BLOB data in table.
Added 'Test Filter' button in Table Settings. Use it to see how many records your custom source table filter selects.
Modified Postgres database table parsing so that only the tables in the current schema are visible
All Interbase/Firebird user-defined BLOB types are now handled. User-defined types are handled as SUB_TYPE 0.
Fixed rare case when MySQL BTREE index caused parser error while analyzing table
Fixed handling of MySQL YEAR data type
Fixed handling of Postgres BOOLEAN data type
Fixed reading of Postgres unique/primary key attributes
Fixed case when constraint names were lowercased unintentionally
Fixed handling of DBF logical data type ('Y' values were incorrectly tagged as False)
Removed differences in default data type mapping in Table Settings compared to default on-the-fly mapping
Full Convert 4.6 released
February 9, 2009
Significantly improved conversion speed for Firebird target, around 300% increase
Added support for SQL Server Compact Edition, both as a source and as a target
Added support for SQL Server 2008 new DATE, TIME and DATETIME2 types
Added support for SQL Server 2008 new multi-line SQL insert command
Added printing support
Added new command-line override. When you specify -override tables_to_process=*, Full Convert will process all tables from the source
Added support for character fields larger than 255 characters in DBF engine
Added support for SQL Server XML datatype
Increased timeout for command execution in most targets to get rid of timeouts for long index creation
Improved performance of connecting to SQL Server and listing its tables
Improved handling of very large custom user SQL scripts so that scripts sized hundreds of MB use a minimum of RAM
Set default write batch records to 200 as this proved optimal for most target databases.
We no more convert dates on each SQL insert to Oracle target. We rather change the session NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT variables.
Auto-creating Access database will now use your default database folder instead of Desktop, if you have specified the folder in the options dialog.
Fixed calculating numeric size from DBF source. DBF defines size excluding decimals, while modern databases define it including decimals. These causes occasional numeric overflows during conversion.
Fixed trial version issue with SQL Server target where trial watermark can cause string truncation error
Fixed handling of tables with percent-sign in the name
Fixed handling of table and column names starting with a number for Interbase/Firebird target
Fixed case for Oracle target where parameters were not used to insert CLOB data
Fixed case for MySQL target where key column names were trimmed to 64 characters alltogether, instead of per-column
Fixed conversion from MySQL to MySQL where table engine was enforced with empty string
Fixed handing of datetime values where a very small values were incorrectly interpreted as NULL values
Full Convert 4.5 released
January 14, 2009
Significantly improved conversion when large BLOB data is used by replacing some string routines with highly optimized code from Ralf Junker, The Delphi Inspiration (http://www.yunqa.de/delphi/)
Improved handling of invalid source data containing NULL values in NOT NULL fields
Paradox strings are no more right-trimmed by Full Convert
Fixed connection lost error on long index creation in MySQL
Full Convert 4.4 released
December 19, 2008
Read large table in chunks is now supported in Firebird source (but not Interbase)
Added Force columns in primary key NOT NULL option for SQL Server target. This is default behavior, as SQL Server requires all PK columns to be NOT NULL. If your data contains NULL values in columns which are part of PK, you can disable this option to have all data converted.
Added automatic handling of certain invalid DBF data when encountered
Implemented memory optimizations when unpacking large (hundred MB in size) SQL scripts from file for automated execution before or after conversion
Improved datetime detection in Excel document cells
Fixed reading of large SQL Server tables in chunks when primary key was nonclustered.
Fixed reading of formatted paradox memos for certain versions of Paradox tables
Fixed conversion of SQL Server timestamp to Oracle
Fixed case when large Paradox memos could corrupt memory buffer
Interbase/Firebird client library setting was ignored (gds32.dll/fbclient.dll). Fixed.
Full Convert 4.3 released
October 20, 2008
Added multi-select in table selection
Multiple-sheet Excel documents are now handled automatically. Each sheet represents a separate table. Empty sheets are ignored.
Line break characters inside CSV text documents are now handled correctly in the case when the new line character occurs inside of the quoted string value.
You can now open saved project even if an error occurs loading a saved project (for example, when database doesn't exist anymore or server IP changed). Project Settings are opened automatically so you can correct invalid information.
Simplified automatic character set conversion. It is now enabled by default and doesn't need a target character set to function, as we support Unicode data.
Added custom character set definiton to MySQL options. This is useful, for example, for utf8 data.
Added WITH NOCHECK option for primary key creation of SQL Server target
Fixed execution of custom long Oracle scripts in Run Before/After Conversion
Fixed case where Interbase/Firebird text blob fields were converted as garbage
Fixed connecting to SQL Server 2000 and older in SQL Server mode authentication
Full Convert 4.2 released
October 3, 2008
Full Convert will no more empty target column definitions in Table Settings when you choose Recreate/Append Data mode. This way you can create project even if you plan to deploy target database structure later.
Fixed handling of Oracle parameters where old parameters were not cleared correctly
Fixed detection of local/remote server for SQL Server when named instance is specified
Fixed writing of Excel files
Fixed case when Full Convert ignored 'Create tables' option in the new Customize dialog
Fixed a last-minute change causing mixed authentication to fail on SQL Server 2005
Fixed a case where same-named tables in different target SQL Server schemas caused internal duplicate index error in Full Convert
Full Convert 4.1 released
September 25, 2008
Added support for executing SQL scripts on the source database before and after conversion
Added support to consecutively run several files inside of the ZIP archive as external scripts. You can even specify file masks!
Project customization expanded and moved to separate dialogue
Completely rewritten Excel support. It is now faster, much more reliable and doesn't even require Excel to be installed.
We have temporarily disabled MySQL LOAD DATA feature due to bugs in the MySQL implementation regarding Unicode data. As MySQL inserts are very fast anyway, this is not really a burning issue.
Auto-refreshing scheduled tasks can now be disabled in the Scheduler
dbo Schema in SQL Server source is no more explicitly defined in target to avoid cluttering table names with unnecessary prefixes. Other schemas are copied.
Conversion will now drop related foreign keys prior to dropping a table in SQL Server target
Fixed handling of text data type for SQL Server 2000
Fixed handling of varchar(max), nvarchar(max) and varbinary(max) data types in global override of data types in Options
Fixed list colors on WindowsXP
Fixed automatic recognition of delimited text files in Project Settings
Fixed Unicode writing to Oracle target
Clicking Copy/Append/No Data options in project customization page was forcing immediate convert
Full Convert 4.0 released
August 11, 2008
Totally new user interface! We used ribbon known from Office 2007 to simplify your workflow and improve the experience.
Editions are now discontinued. Users were often confused which Edition they need and demand for lite version of the product was far less than for the Enterprise version.
Added Unicode support! Full Convert can now handle all those umlauts, Chinese, Japanese, Hebrew and Arabic letters with ease!
Added Excel as a conversion target - you can write a whole bunch of Excel documents (one for each table) or stuff all tables as sheets in a single Excel document
Added ability to run custom user SQL scripts before and after each conversion. You can also specify external files (even ZIP files) to be read, unpacked and executed.
Added in-place edit feature into the data grid. No more need to go to other tools to modify your converted data.
Added datatype mapping on a global level as well and set-up rules used for all conversions.
Added improved error reporting. You can now send a bug report from any error message to seek for help - this is great for managing database setup
Added tips into error messages. For the common problems Full Convert will suggest actions to resolve the issue.
Added display of progress when Full Convert is called via command-line and immediate close switch is not specified
Added automatic 'Skip activation' action when trial can't reach our server due to firewall/proxy setup
Added schema specification in SQL Server
Added automatic creation of index for MySQL target Table Settings when user creates auto_increment column
Added direct link to customize the project
Added satisfaction survey to the trial version so we can easily be notified of the problems and new features requests.
Added notification window when the conversion is finished
Improved scheduler
Improved progress dialog can now be dragged and is no longer visible on top of other windows
Fixed handling of empty varchar(max) SQL Server datatype
Fixed handling of double datatype for DBF source tables
Fixed reading of disabled options intended for Enterprise in Editions
Fixed occasional handling of Oracle clob as blob data
Fixed case when Oracle sequence was not created for empty source table
Fixed creation of indexes in Access target
Fixed 'Unknown datatype' error in Oracle target
Fixed Interbase/Firebird WHERE clause handling in Table Settings
Fixed conversion of Oracle LONG RAW datatype to SQL Server 2000 target
Full Convert 3.3 released
January 29, 2008
Added support for Oracle 11g
MySQL target will now automatically convert decimal identity fields to int/bigint, depending on the size
Fixed occasional incomplete metadata retrieval
Fixed handling of NULL values in fields where target database doesn't support NULLs in specific scenarios
Fixed handling of MySQL mediumtext datatype
Full Convert 3.2 released
November 28, 2007
Added an option to require user global datatype matching for users who want absolute control over conversion
MySQL target now creates only required indexes as a part of create table statement and the rest later
Added warning when BULK mode and Table Settings are used so you can know when a table can't use BULK mode
Added handling of case when MySQL returns incomplete create table statement to us
Fixed global datatype conversion casing sensitivity
Fixed handling of 64-bit integer values for Interbase/Firebird target
Full Convert 3.1 released
November 16, 2007
Fixed handling of MySQL unsigned datatypes
Fixed Paradox tables reading
Fixed reopening of Access password protected databases
Fixed the WHERE condition in Table Settings which was ignored in v3.0
Fixed table name transforming in Session Wizard's Customize section
Full Convert 3.0 released
October 20, 2007
Massive data transfer speedup!
Added support for MySQL LOAD DATA bulk mode
Added support for PostgreSQL COPY bulk mode
Improved process of conversion from SQL2005 to SQL2000 or earlier
Added warnings to the conversion log
Empty tables are now immediately skipped when copying data
Added handling of duplicate DBF indexes
Added autorename of duplicate DBF fields
Added visual clue icon to clear when the table is being open, when Full Convert processes data, and when the target database processes the data
Added global datatype conversion override for each target
Added preview of delimited text file in Session Wizard for easy selection of delimiter
Improved scheduler - tasks can now be repeated (even every minute if needed) for a specific time duration - and force stopped if they run too long
Bulk mode temporary files written asynchronously for best performance. We used a very nice class written by Dmitry Streblechenko (dmitrys@asu.edu) in 1997.
You can now specify client and server for for the bulk mode temporary files for each target, and override it per session
Trial does not expire anymore, to help those who need more time evaluating
DBF files are no more locked for writing during conversion
Fixed progress bar display (last write batch didn't update the progress bar)
Fixed Firebird default value parsing
Full Convert suite 2.9 released
August 17, 2006
Added per-session options. You can now choose to convert schema only, append data, skip indexes etc. without setting this up for all tables separately at the Table Setting dialog. Enterprise only.
Reading tables in chunks is now off by default in Enterprise. This maximizes speed, and users who convert huge databases can always turn this on to avoid big memory load.
Added ability to apply prefix to indexes and constraints, not only to tables. This is handy when loading several copies of the database into the same target database.
Added support for BCD datatype in Paradox
Added auto-refresh every 3 seconds in the Scheduler task list
Improved support for LONG datatype in Oracle
Fixed parsing of tables in MySQL. Views were treated as tables, now they are ignored.
Fixed Paradox reader, in rare cases table reading was ended prematurely
Fixed a situation where SQL Server target in certain rare circumstances mixed blob text/binary attribute
Fixed reading of NUMERIC datatype from DBF source. It was converted into DOUBLE, and now is marked as DECIMAL of correct precision as scale.
Fixed reading of CURRENCY datatype from the Access source. It was converted into DECIMAL, and now is marked as MONEY.
Fixed exception when "override_file" command line parameter was invalidly specified in Enterprise
Fixed non-initialized NULL values when using Oracle fast loader
Fixed hiding of the Welcome Dialog - the option in question was ignored
Full Convert suite 2.8 released
July 14, 2006
Relaxed conditions to be able to take advantage of Oracle fast loader. Now (N)CHARs and (N)VARCHARs can be used as well.
Oracle target now (again) uses internal fast loader as default. You can enable standard inserts in Options dialog.
Fixed Interbase/Firebird huge tables reading by chunks in Enterprise
Fixed Oracle option to change (N)CLOBs to (N)VARCHARs
Full Convert suite 2.7 released
July 4, 2006
Extended trial records limit to 50 and set this mode to default
Fixed parsing of Full Convert 1.x DBF session files
Fixed Table Settings in 'recreating data' mode - original table name was used for truncating, ignoring eventual user-specified name
Full Convert suite 2.6 released
June 25, 2006
ODBC support fully rewritten. It is now much faster and very reliable.
Changed Table Settings behavior - global name changing options are applied even when user has defined table settings - to allow easy global uppercasing or similar situation
Added character set translation in Enterprise to Paradox reader in addition to DBF
Added parsing of FoxPro DBC file to allow for long field names
In Enterprise version, added ability to override session connection parameters using command line switches or using external file
Mapped minus character in table names to underscore character for Oracle target
License info now displays whether it is single user, site, or worldwide license
MySQL table engine is now by default preserved when converting to MySQL (as a backup for example)
Added default username to use when specifying MySQL connections - default is "root"
Added ability to overwrite index names during schema parsing. This is useful when you have indexes with same names, target databases mostly do not support that.
Added support for Oracle ROWID datatype
Added trimming of trailing spaces in the DBF source strings
Full Convert now adds size to index column when target database is MySQL and column in question is BLOB. This can happen when source VARCHAR results with target TEXT datatype for example. Size is customizable in Options dialog.
Oracle target now uses standard inserts with append hint as default. You can enable internal fast loader in Options dialog.
Oracle and Interbase/Firebird target schemas are by default now created as case-insensitive. This overrides name transforms settings in Options, unless it is set to case-sensitive, in which case global options are applied.
Saving log files now prompts whether to overwrite if the file already exists
Fixed occasional failure to override blanks in not-null fields when Oracle direct loader is used
Fixed incorrectly calculated memo length in dBase7 reader
Fixed occasional invalid trimming of column names in Oracle constraints
Fixed occasional invalid display of accented character in built-in data grid
Fixed invalid interpretation of Integer columns as autoinc in DBF reader
Full Convert suite 2.5 released
May 22, 2006
Added support for dBase7 format
Added ability to deselect incorrectly defined fields in Table Settings
Direct loader for Oracle now also handles blanks in not-null fields
In Enterprise version, reading of large tables in chunks always fetched 50.000 records at a time. It now uses a value defined in Options.
In Enterprise version, added APPEND hint to Oracle loading modes definition
DBF tables with more than 255 columns are now supported
Fixed occasional incorrect interpretation of SQL Server column nullability property
Full Convert suite 2.4 released
April 25, 2006
Advanced table settings added to Session wizard in Enterprise version. Ability to override default conversion parameters on table and column level.
Direct Oracle fast loader is now turned on by default. It enables tenfold speedup compared to traditional SQL inserts, but is not used for tables containing blobs.
Added support for FoxPro and dBase over OLEDB, for customers who want to connect this way. This has to be turned on in Options.
MySQL target is now able to dynamically reorder colums and add index if needed for auto_increment columns to work. Also, only the first auto_increment column will keep this property, all the others will have this property reset because of MySQL's limitation of one autoinc column per table.
Added ability to specify default database folder in Options dialog
Added check for online updates (latest version)
DBF reader now recognizes field nullability, hidden fields and autoinc fields. This has to be enabled in Options.
DBF reader now parses CDX files to support translation of indexes
Session saving is now enabled in trial
Added fix for Oracle's inability to insert empty string in not null field. Oracle inserts NULL instead, so Full Convert now inserts a single space in such cases.
Fixed reset of Options on cancelling of Options dialog
Fixed handling of MySQL indexes' column length
Fixed handling of MySQL fulltext indexes
Fixed bug in trial where 5 records test mode was sometimes ignored and test mode was forced to 5 columns mode
Full Convert suite 2.3 released
March 22, 2006
Added creation of unique constraints to Interbase/Firebird tables where needed for foreign key recreation
Added creation of unique constraints to Oracle tables where needed for foreign key recreation
Added support for Oracle timestamp data type
Fixed handling of Interbase/Firebird tables containing quotes in their name
Fixed handling of Interbase/Firebird BLOB sub types
Fixed parsing of MySQL tables containing spaces in their name
Fixed reading of Oracle float type precision
Full Convert suite 2.2 released
March 14, 2006
Direct Oracle fast loader (huge speed gains) is now available in Enterprise version
Enhanced ODBC connection. Username, password and compatibility mode are added.
Fixed Memo fields handling of DBF VFP3 tables
Fixed datetime fields erroneous handling of DBF tables introduced in our direct DBF reader
Fixed connect error on attempt to open password protected Access database
Full Convert suite 2.19 released
September 26, 2007
Added ability to directly type in the name of PostgreSQL and SQL Server databases in the Session Wizard
Fixed Interbase/Firebird blob sub_type handling
Fixed PostgreSQL login bug
Fixed PostgreSQL blob writing bug
Fixed Access password handling
Full Convert suite 2.18 released
August 31, 2007
Fixed MySQL tinyint interpretation as bool
Fixed Lotus1-2-3 handling
Fixed Interbase/Firebird index creation
Fixed reading tables in chunks
Full Convert suite 2.17 released
August 14, 2007
Added ability to directly type in the name of MySQL database in the Session Wizard, for users who can't connect with a blank database to get a list of available ones
Fixed missing PostgreSQL access DLLs. We have added missing DLLs to our release
Fixed 'Data copying for existing tables' error for new projects
Full Convert suite 2.16 released
July 7, 2007
Added support for PostgreSQL as both source and target (Enterprise required for the target)
Added filter in Table Settings. You can now specify the "WHERE clause" to filter out the source data for any table. This is only supported for relational source databases.
Speed up of MySQL connection time by not using slow information_schema to read metadata
Added advanced options to the Session Wizard (Enterprise only): Select tables with different size, Data copying for existing tables, Clear All Table Settings
Added an option to auto-save error log
Changed trial mode. No more records/column limitation, now we simply stamp the data with ***TRIALMODE*** every few records
Improved compatibility with SQL Server 6.5
TEXT datatype is now by default converted to VARCHAR(MAX) if SQL2005 is used as a target
BLOBs are now by default converted to VARCHAR(MAX) if size is larger than 8000 characters and SQL2005 is used as a target
Added support for 'USING BTREE' clause in MySQL index definition
Full Convert won't automatically rename identifiers which are reserved words in target database anymore. There is an option to turn this behavior on.
Scientific number notation is not used anymore for SQL Server target because SQL2005 no longer supports it in BULK INSERT by default
Oracle sequence and trigger names are now trimmed to 30 characters
Fixed connection issue when SQL Server is running on a different port than default
Fixed the problem where Access and SQL Server data only preserved 4 digits behind decimal point
Fixed occasional errors with BULK INSERT of BLOB and DATETIME data on SQL Server target
Fixed the handling of case when Interbase doesn't fill-in certain metadata values
Fixed parsing of Access indexes
Full Convert suite 2.15 released
April 23, 2007
Added support for Oracle sequences and corresponding triggers to Enterprise
Added support for Interbase/Firebird DEFAULT values
Added support for different type of quoting in delimited text files
Added compatible mode for connection to SQL Server 6.5 and earlier
Oracle parser will now skip over SDO_GEOMETRY fields
Enforced Oracle date format to a fixed format to avoid problems with varying configurations
Removed single quote as a string delimiter in delimited text parser. Now only double quotes delimit strings, which helps to parse files where strings are not enclosed with quotes, yet contain single quotes.
Fixed escaping of double quote in a MySQL target. It isn't quoted anymore.
Fixed issues with defaults and SQL Server VARCHAR(MAX) columns
Fixed Session Wizard appearance on large-fonts displays
Fixed certain cases where Oracle target could miss a constraint
Full Convert suite 2.14 released
March 12, 2007
Added support for BINARY, VARBINARY types in MySQL
Added support for VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) in SQL Server
Added Text as target engine to Enterprise for easy conversion of source database to delimited text
Added auto-translation of character set to Enterprise (from dBase, FoxPro and Paradox sources)
Added graceful fallback to DML in Oracle target when Direct mode is used
Added ability to resize Session Wizard, handy when you have large table names
Added graceful bypass of handling of mysql.proc in case that user doesn't have proper SELECT privileges for MySQL connections
Added detection of installed OLEDB providers. SQL Server connection now automatically uses SQLNCLI instead of SQLOLEDB if available.
Added detection of maximum allowed packet size for MySQL target, so Full Convert will take advantage of increased packet size if available
Added selection of protocol for Interbase/Firebird connection
The dialog is shown to user to use 'Read large tables in chunks' when OutOfMemory exception is encountered
Removed legacy database connections (dBase and FoxPro over OLEDB) as they are superseded by a direct reader 'dBase and FoxPro (DBF)'
Removed MySQLscript engine from the source engine list as it ended there by mistake
SQL Server statistics are no more being interpreted as indexes for a table
Fixed the Table Settings - when Append Data was selected, the option was not remembered
Full Convert suite 2.13 released
February 16, 2007
Added support for Access 2007
Added quick-select of local SQLExpress
Added "quiet" command-line switch which hides the application window
Added ability to override Interbase/Firebird library from default GDS32.DLL
Improved Interbase/Firebird structure reading. Option to read full Interbase/Firebird schema at once has been removed.
Fixed TXT import where character "\r" was left at the end of the last field in line
Fixed DBF memo reading in certain versions of DBF
Full Convert suite 2.12 released
November 24, 2006
Added optional parsing of SQL Server views as if they were tables. Enterprise only.
Added default SYSDBA/masterkey username/password for the Interbase/Firebird connection
Added recognition whether Interbase or Firebird is used and graceful override of functionality unsupported in Interbase. For example, read large table in chunks in supported in Firebird, but not in Interbase.
Added workaround for Interbase/Firebird bug where server does not support direct reference of columns named as reserved words.
Added option to skip primary key creation for Oracle target
Changed code signing to Verisign instead of Thawte in preparation for "Certified for Windows Vista" logo program when Windows Vista is released
Fixed unsupported CLOB syntax in Oracle versions less than 10
Full Convert suite 2.11 released
October 10, 2006
Rewritten delimited text file handling. It is now not cached anymore, resulting in great memory consumption saving. Full Convert now handles text files of hundreds of GB of size easily.
Added option to skip prefix and suffix lines in the delimited text file. This allows to bypass header comment and summary info, for example.
Added reports of the source and target tables with their record counts (Enterprise only)
Greatly speeded up Oracle and SQL Server standard SQL inserts. You can tweak Options (Insert data in batches) and vary number of records inserted per batch to maximize throughput on your machine.
Added auto select in Session Wizard. Enterprise only.
Added recognition of all reserved words in target databases. If a table or column name is a reserved word, an underscore character will be appended in the generated target name.
Added optional parsing of Oracle views as if they were tables. Enterprise only.
Fixed data throughput calculation not to include opening of the table, only data copying
Removed dependency of the generated DATETIME SQL string on the system regional settings
Fixed handling of tables with quotes in the name in the Table Settings
Fixed built-in optional conversion of LONG to VARCHAR/CLOB in Oracle 8
Fixed occasional trimming of last character in the last DBF table field
Fixed detection of deleted DBF records
Fixed Oracle fast loader inability to find table when preserve table and column case is selected in Options
Full Convert suite 2.10 released
September 1, 2006
Added support for Views in ODBC. Enterprise only.
Force close of the application during conversion is now properly handled and this event is logged in the error log
Fixed interpretation of Oracle DATE datatype as DATETIME in the other database engines
Full Convert suite 2.1 released
February 9, 2006
Added character set conversion in Enterprise version (experimental, available only for DBF source for now)
Further speedup of SQL Server bulk insert mode
Speedup of dropping tables in SQL Server and Access targets
Multiple identity columns in source are now detected and modified so that only first one stays identity (for targets that do not support multiple identity columns per table)
Fixed case changing behavior in table and column name modifier to support characters with accents
Integer types in Oracle target are now converted to NUMBER type (not FLOAT anymore). NUMBER has precision set according to size of Integer type.
*.fcs (Full Convert session) files are now associated with Full Convert on install
Fixed case where invalid date in DBF record caused entire record to be rejected
Fixed Access relationship parsing error where differently named local and related columns were swapped
Fixed behavior when scheduled to run as System account
Fixed handling of Oracle CLOB columns
Fixed display of Oracle database in tree list to be user@service, not user@server
Now using quotes in Oracle target only where needed
Full Convert suite 2.0 released
January 16, 2006
Total user interface redesign
Overall conversion speed improvements
Added welcome dialog to speed up common tasks
Added built-in scheduler to enable fully automatic conversions
Improvement of Paradox source handling (increased speed, startup time of table data reading reduced to zero, minimal and constant memory consumption even for huge tables)
Merged Paradox and FoxPro engine to minimize confusion of users as both engines use DBF files
Added interception of NULL values in Interbase/Firebird primary key columns, as primary key columns can only be NOT NULL. Default values are inserted to avoid Interbase/Firebird exceptions.
Best fit for data displayed in grid can now be limited for small tables only (configurable in Options)
Options improved
Improved logging speed of field validations errors (such as invalid dates)
Improved update of progress dialog for tables with huge blobs where database can handle only a few records per second
Improved Oracle target speed when table doesn't contain BLOBs
Delimited text file no more requires character columns to be enclosed in quotes. VARCHAR is now default field type, used when no other type passes validation rules.
SQL sent to database is flushed before it reaches 1MB in size to avoid problem with typical setup of MySQL and BLOBs.
Installation files are now signed
Fixed dropping of Access tables (dependant foreign key constraints were not dropped correctly)
Fixed detection of Access autoincrement columns
Fixed detection of Access referential integrity rules (on update/on delete)
Fixed a bug where Oracle FLOAT data type used digit instead of binary precision, resulting in less precision than desired
Fixed detection of Interbase/Firebird primary keys
Full Convert 1.9 released (Interbase/Firebird Edition introduced)
August 30, 2005
Interbase/Firebird Edition introduced!
Added XML support
Separated conversion into 4 stages (create tables, transfer data, create indexes, apply constraints), so that data is always transferred, even if it does not conform correctly to unique indexes and constraint rules
All targets now save referential integrity constraints
Added support for ON DELETE and ON UPDATE rules
Added error return code so scheduled conversion can trap errors
Interbase/Firebird now handles both SQL Dialects 1 and 3
Improved compatibility with Oracle 8.x (which does not support multi-byte characters)
Improved conversion of default values
You can now select tables of any user in Session Wizard for Oracle source
Improved Oracle connection dialog so server and port can more easily be defined
Improved responsiveness of Cancel button in progress dialog
License keys should now work also with most exotic characters in our customers' names :)
SQL Log no longer takes up memory during conversion
Fixed case where some Excel sheets were not displayed as tables
Removed delay on typing SQL Server connection server name (network was polled for existing SQL Servers too often)
Improved detection of invalid data in source database
Removed 'Professional' and 'Standard' versions as such. 'Standard' versions are no more supported, and 'Professional' are simply Editions.
Full Convert 1.8 released
June 13, 2005
Fixed Interbase/Firebird error with mixed-case table names
Performance much improved in SQL Server target
Improved progress dialog
Fixed cancelling in memory optimized mode
Added Oracle target option: Long text columns are now by default converted to VARCHAR(4000), because Oracle limits table structure to have only one LONG column per table
Added detection of multiple same columns defined in index
Fixed incorrect detection of Excel print areas as sheets
Full Convert 1.7 released
May 5, 2005
Added memory optimized mode for huge tables (tens of millions of records) to Enterprise version. This mode slows down conversion a bit, but uses small memory footprint. Supported source databases:
MySQL
FoxPro
Oracle
Access (must have primary key defined to take advantage of this feature)
SQL Server (must have primary key defined to take advantage of this feature)
Fixed MySQL partial index recognition
Full Convert 1.6 released (Access Edition introduced)
March 27, 2005
Fixed invalid handling of SQL Server timestamp column
Fixed conversion of strings containing ASCII value of zero characters. They are now replaced with spaces allowing SQL to be executed properly.
Fixed occasional Interbase/Firebird server list error
Fixed truncating of decimal values to 2 decimal places
Fixed unicode column types detection in databases not supporting unicode
Fixed numerous Access target bugs
Fixed ignoring of MySQL table type option - InnoDB was always used.
Access Edition introduced!
Added ability to supress invalid field value errors to speed up conversion when there are many
Added ability to force Unicode or Non-Unicode columns to target database
Fixed Oracle blob and clob columns reading
Fixed incorrect setting of Paradox 00:00 time values to NULL
Fixed occasional wrong conversion of decimal datatype as integer from Interbase source