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. Version 3.2 - Nov 28, 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 Version 3.1 - Nov 17, 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 Version 3.0 - Nov 16, 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 Version 2.16 - Jul 23, 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 Version 2.13 - Feb 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 Version 2.12 - Jan 5, 2007
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 Version 2.11 - Oct 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 Fixed parsing of Paradox negative smallint and int values Version 2.10 - Sep 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 Version 2.9 - Aug 19, 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 Version 2.8 - Jul 27, 2006
Fixed Interbase/Firebird huge tables reading by chunks in Enterprise Fixed Oracle option to change (N)CLOBs to (N)VARCHARs 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. Version 2.5 - Jun 8, 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 Version 2.4 - May 31, 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 DBF reader now parses CDX files to support translation of indexes Session saving is now enabled in trial 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 Version 2.3 - Mar 26, 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 Version 1.7 - May 24, 2005
Paradox handling improvedAccess supports passwords and system databaseNon-delimited text files support
Full Convert Enterprise 5.0 Advanced database conversion with . instantly. 16 database
formats supported!... [read more] [download now]
First Remote Patient Monitoring Trial Using Mobile Technology in New Zealand Nov 08 2009, 12:47 The Auckland District Health Board (ADHB), Gen-i (a member of the Telecom New Zealand Group) and Alcatel-Lucent have joined efforts to launch New Zealand’s first trial of a healthcare remote patient monitoring (RPM) solution using mobile technology to monitor and manage chronic illness in the home. The three-month trial focuses on 20 heart disease patients selected by Auckland Hospital. read full story
Telecom Companies Announce a Standards Based Solution for Voice and SMS Services over LTE Nov 04 2009, 19:58 AT&T, Orange, Telefonica, TeliaSonera, Verizon, Vodafone, Alcatel-Lucent, Ericsson, Nokia Siemens Networks, Nokia, Samsung Electronics, and Sony Ericsson have defined the preferred way to ensure the smooth introduction and delivery of voice and SMS services on Long Term Evolution (LTE) networks worldwide. read full story
NEC Bring Clearer Television Pictures to Denmark Nov 04 2009, 19:26 NEC announced that it has completed the implementation of the digital terrestrial TV-network in Denmark for the network operator, Broadcast Service Danmark A/S (BSD). The switchover from analogue to digital took place on October 31, 2009 at midnight, marking a significant date in Danish television history. read full story
E Ink and Freescale to Develop Integrated Processors for eBook Market Oct 20 2009, 22:16 The industry’s top provider of processors for eBooks has joined forces with the leading supplier of eBook electronic paper displays to develop highly integrated embedded solutions that lower costs and foster innovation for eBook manufacturers and their customers. read full story
