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() ) ) ); |
Views: 3624
Last Modified: 29.06.2023
Last Modified: 29.06.2023