Migration to MySQL

Example of config.php file
<?php

/* 
 * Config for Oracle/MSSQL => MySQL converter.
 * 
 * @date 12/02/2016
 * @author Alexander Serbul
 * @copyright Bitrix
 */

error_reporting(E_ALL);
ini_set('memory_limit', '1024M');

$config = array(
    'logFile' => '/tmp/migrate_log.txt',//log file (important for diagnostics)
    'logMigrateQueries' => false,//save queries as is to log file 
    'confirmTableDeletion' => true,//
    'confirmTableCreation' => true,//
    'skipCheckTruncation' => false,//skip checking of data truncation (slow)
    'storeMigrationStatus' => false,//remember table migration status
    'statusFolder' => '/tmp/mg_status',//where to save status about table migration
    
    'encFrom' => 'UTF-8',//oracle data encoding
    'encTo' => 'UTF-8',//mysql data encoding
    
    'db' => array(
        
        'oracle' => array(
            'connectionString'	=> 'localhost/XE',
            'user'				=> 'bitrix1',
            'password'			=> '123456',
            'database'			=> 'bitrix1',
            'ignoreTables'		=> array(//which source tables to ignore
                'B_FILE_ACTION',
                'B_SALE_BIZVAL_CODE_1C',
                'B_SALE_DELIVERY',
                'B_SALE_DELIVERY_HANDLER',
                'B_SALE_BIZVAL_PERSONTYPE'
            )
        ),

        'mssql' => array(
            
            'serverName'		=> 'WIN-HO7VTHGJ7ED',
            'connectionInfo'	=> array(
                "UID"=>"sa",
                "PWD"=>"123456",
                "Database"=>"bitrix2",
                //"CharacterSet" => "UTF-8",
                'ReturnDatesAsStrings'=>true
                //'ConnectionPooling' => false,
                //'MultipleActiveResultSets' => false
            ),
            'ignoreTables'		=> array(
                'B_FILE_ACTION',
                'B_SENDER_POSTING_LOCK',
                'B_POSTING_LOCK',
                'B_SALE_BIZVAL_CODE_1C',
                'B_FAVORITE_LANG',
                'B_LEARN_EXCEPTION_LOG',
                'eshop_brand_reference_uf_intm',
                'eshop_brand_reference_uf_tstringm'
            )
		),
		
        'mysql' => array (
            'host'		=> 'localhost',
            'port'		=> 3306,
            'user'		=> 'root',
            'password'	=> '',
            'database'	=> 'bitrix2',
            'ignoreTables'		=> array()
        )
        
    )
    
);
Bitrix Framework
