$writer = new Zend_Log_Writer_Stream('php://output');
$writer->setFormatter(new Zend_Log_Formatter_Simple('[%priorityName%]: %message%' . PHP_EOL));
$logger = new Zend_Log($writer);
$logger->info('Initialization...');
error_reporting(-1);
ini_set('display_errors', 1);
ini_set('memory_limit', -1);
$response = new Mage_Core_Controller_Response_Http();
Mage::app()->setResponse($response);
$migration = new Mage_Migration();
$processedCategories = array();
$processedProducts = array();
Mage::getModel('enterprise_mview/client')->init('enterprise_url_rewrite_category')->execute('enterprise_catalog/index_action_url_rewrite_category_refresh');
Mage::getModel('enterprise_mview/client')->init('enterprise_url_rewrite_product')->execute('enterprise_catalog/index_action_url_rewrite_product_refresh');
Mage::getModel('enterprise_mview/client')->init('enterprise_url_rewrite_redirect')->execute('enterprise_urlrewrite/index_action_url_rewrite_redirect_refresh');
$tableProducts = $migration->getConnection()->newTable($migration->getEntityMigrationTable(Mage_Migration::ENTITY_TYPE_PRODUCT))->addColumn('id', Varien_Db_Ddl_Table::TYPE_CHAR, 512);
$tableCategories = $migration->getConnection()->newTable($migration->getEntityMigrationTable(Mage_Migration::ENTITY_TYPE_CATEGORY))->addColumn('id', Varien_Db_Ddl_Table::TYPE_CHAR, 512);
if ($migration->getConnection()->isTableExists($tableProducts->getName())) {
$migration->getConnection()->dropTable($tableProducts->getName());
}
if ($migration->getConnection()->isTableExists($tableCategories->getName())) {
$migration->getConnection()->dropTable($tableCategories->getName());
}
$migration->getConnection()->createTable($tableProducts);
$migration->getConnection()->createTable($tableCategories);
$rewritesSelect = $migration->getConnection()->select()->from($migration->getResource()->getTableName('core_url_rewrite'), array('product_id', 'category_id', 'store_id', 'request_path'))->order('url_rewrite_id');
$cpbAdapter = new Zend_ProgressBar_Adapter_Console(array('elements' => array(Zend_ProgressBar_Adapter_Console::ELEMENT_PERCENT, Zend_ProgressBar_Adapter_Console::ELEMENT_BAR, Zend_ProgressBar_Adapter_Console::ELEMENT_ETA, Zend_ProgressBar_Adapter_Console::ELEMENT_TEXT)));
$countSelect = clone $rewritesSelect;
$countSelect->reset(Zend_Db_Select::COLUMNS);
$countSelect->columns('COUNT(*)');
$row = $migration->getConnection()->fetchRow($countSelect);
