Preserving Recnum During Migration

Picture of Mertech Mertech : Feb 25, 2008 6:36:00 PM

DataFlex

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.

 
Data Security with Flex2SQL and BTR2SQL Connectivity Products

Data Security with Flex2SQL and BTR2SQL Connectivity Products

Mertech Support: Oct 1, 2025 12:45:52 PM

The most common reason for Enterprises looking to migrate from legacy Btrieve or DataFlex databases is the urgent need to address security and...

Btrieve BTR2SQL Flex2SQL MS SQL Server Oracle MySQL MariaDB
Read More
Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Picture of Riaz Merchant Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...

Btrieve BTR2SQL PostgreSQL Modernization ISAM
Read More
Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Picture of Riaz Merchant Riaz Merchant: Oct 18, 2024 9:21:56 AM

COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....

Btrieve MS SQL Server Oracle PostgreSQL COBOL
Read More