The Use Regular Save During Migration (SQL Server only) means that when it is checked, SQL puts recnum in sequence on backend which meaning they won’t match the sequence from DataFlex. If the option is on, then the recnum will follow the DataFlex sequence on the backend. When this option is on, the migration takes longer. Flex2SQL contains facilities for high-speed data migration, including generating SQL*Loader scripts and text files for Oracle and bulk copying of data to MS SQL Server, making it easier to transfer very large databases with both drivers. The SQL scripts enable you to create tables and indexes outside the tool. The high-speed data migration is the default option.
Archive for February, 2008
Preserving Recnum During Migration
Monday, February 25th, 2008How to Obtain Flex2SQL Driver Licensing Information From sql_drv.cfg
Monday, February 25th, 2008Is accessing Flex2SQL Driver registration information registered on their server, is there any program that can check the liceseing information (such as Licened To:, Number of users:, etc) from the file SQL_DRV.CFG possible?
- The information can be obtained from Flex2SQL -> Help -> About. In this screen the licensed to and user count is found, along with other pertinent information.
Using the Restructuring Source Code Generated by Flex2SQL in VDF
Monday, February 25th, 2008Flex2SQL will auto generate these files:
How to use Triggers in With Flex2SQL Drivers
Monday, February 25th, 2008The following is a simple program which inserts records on ITEM table and the HEADER.TOTAL field is updated automatically:
Flex2SQL Indexes in the Backend
Monday, February 25th, 2008When you add a segment to table with our drivers there is a representation of those in the backend (MS SQL, Oracle, MySQL and PostgreSQL).
These are the column sufix, of these segments:
(more...)