|
Пример файла config.php
|
|---|
<?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()
)
)
); |
Просмотров: 45536
Дата последнего изменения: 28.12.2023
Дата последнего изменения: 28.12.2023
Роберт Басыров
Сложность урока:
2 уровень - несложные понятия и действия, но не расслабляйтесь.
1
2
3
4
5
Недоступно в лицензиях:
Ограничений нет
