Back to Blog list

Data Migration Tool Compatible with Magento 2.0

Profile photo of Windig Windig Magento 2, News, Updates 46 Comments November 20, 2015
LinkedIn0
Pinterest0
Aug 6, 2020 Update
UB Data Migration Pro v3.2.4 here. Fully compatible with Magento 2.4.0.
Sept 20, 2018 Update:
Check out the latest UB Data Migration Pro v3.1.6, with all-new dashboard UI. Fully compatible with Magento 2.2.6. It supports delta migration, Command-line Interface, PHP Memcached and fully ready for large-scale data migration.
May 17, 2016 Update:
We decided to upgrade our free migration tool to a premium version — UB Data Migration Pro to provide a better, stable and more feature-rich solution for Magento 2 migration. Check out this 9-minute video to learn more about how this new migration tool can help with Magento 2 migration.

To back up an appointment, whenever Magento 2.0 with the new version we also update the tool. Surely you are familiar with our tool, today we have some new information for you about the changes to the tools.If this is the first time you have come across this tool, then do read in detail about the features, which we have covered in our earlier blog post. Not only we have updated it to work with current version of Magento 2 but we have also focused on improvements and it is now more user-friendly than ever.

In this version we have:

Magento 2 Migration Data Tool

Highlights of Version 0.1.20

Changes in table

Magento 2 Migration Data Tool

+ Removes Tables

Magento 2 Migration Data Tool

In this post, we are standing at process 1 To use this migration tool, follow the steps below.

# Pre-condition: Install Magento 2

Download the latest version of Magento2 from Github + Follow our Installation guide to Install Magento 2

# Step 1: Configure the tool

1 -- Make a folder named “migrate_data_tool” in your web root. For example: PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool

Magento 2 Migration Data Tool

+ Download the latest version of this tool at Magento 2 Data Migration
+ Extract all source code from downloaded file to the folder you have just created (migrate_data_tool)
+ Make writeable permission for folders at:

>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\assets
>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\protected\runtime

+ Make writeable permission for config file at:

>>> PATH_TO_YOUR_WEB_ROOT_FOLDER\migrate-data-tool\protected\config\config.php

# Step 2: Run this tool

Open your browser and type in the url to run this tool. For example: go to http://localhost/migrate-data-tool/ and press Enter key.

Magento 2 Migration Data Tool

  • Version: to select version of Magento
  • Database Server Host: identify the database server host name
  • Database Server UserName: indentify the username of database server
  • Database Server Password: identify the password of database server
  • Table Prefix: identify the table prefix

# Step 3: Follow step by step to migrate data

Follow step by step to migrate needed Data from Magento 1 website to Magento2 website.

Magento 2 Migration Data Tool

# Step 4: Complete the tasks below to finish the data migration process.

Re-save all the Attribute Sets (Product Template) migrated in the back-end of your Magento 2 website. (Open the attribute set, edit it if needed and click the save button) Open the command line window and go to the folder: PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\dev\shell\ and type in the command line: php indexer.php reindexall then press enter key to re-index all data in your Magento 2 website.

Magento 2 Migration Data Tool

Copy media files to complete migration:

+ Copy the folder at PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento1_folder\media\catalog and paste replace to PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\pub\media\

+ Copy the folder at PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento1_folder\media\downloadable and paste replace to PATH_TO_YOUR_WEB_ROOT_FOLDER\your_magento2_folder\pub\media\

# Step 5: Now you can test the data which have been migrated into your Magento 2 website from the browser.

Download Magento 2 Migration Tool Crafts: Free Magento 2 Theme

More about Magento 2 :

LinkedIn0
Pinterest0

Written By

Further Reading

Comments
  • Mary Smith

    Magento 2 – is a more developed version. However there are still companies ( like this one http://magecom.net/ ) who got used to work with the fist version. It’s always the problem – to adapt to changes (even to design).

    • Uber Theme

      Thanks for your comment. Yes, as Magento 2.0 has just been released which takes a large
      work load to convert themes and extensions from Magento 1.x to 2.0. We
      are now in the first step to convert Techzone.

  • Bernard Bachmann

    2 things, the indexing process has changed:
    1: cd bin
    1: ./magento indexer:reindex

    2: The products are listed, but I can’t see the details in the edit mode.

  • Rudi Khoury

    Can this tool handle the “delta” changes – i.e do the migration, build the site, then come and do the new data, then go live?

  • Richard

    I have a problem with store view
    SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento20.catalogsearch_fulltext_scope2’ doesn’t exist, query was: INSERT INTO `search_tmp_566101c86d0148_36850016` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope2` AS `search_index`
    LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
    LEFT JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id
    LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = ‘1’ WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 15)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
    #0 C:xampphtdocsmagento20vendormagentoframeworkDBStatementPdoMysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
    #1 C:xampphtdocsmagento20vendormagentozendframework1libraryZendDbStatement.php(303): MagentoFrameworkDBStatementPdoMysql->_execute(Array)
    #2 C:xampphtdocsmagento20vendormagentozendframework1libraryZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
    #3 C:xampphtdocsmagento20vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `se…’, Array)
    #4 C:xampphtdocsmagento20vendormagentoframeworkDBAdapterPdoMysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `se…’, Array)
    #5 C:xampphtdocsmagento20vendormagentoframeworkDBAdapterPdoMysql.php(499): MagentoFrameworkDBAdapterPdoMysql->_query(‘INSERT INTO `se…’, Array)
    #6 C:xampphtdocsmagento20vendormagentoframeworkSearchAdapterMysqlTemporaryStorage.php(69): MagentoFrameworkDBAdapterPdoMysql->query(‘INSERT INTO `se…’)
    #7 C:xampphtdocsmagento20vendormagentoframeworkSearchAdapterMysqlAdapter.php(77): MagentoFrameworkSearchAdapterMysqlTemporaryStorage->storeDocumentsFromSelect(Object(MagentoFrameworkDBSelect))
    #8 C:xampphtdocsmagento20vendormagentomodule-searchModelSearchEngine.php(42): MagentoFrameworkSearchAdapterMysqlAdapter->query(Object(MagentoFrameworkSearchRequest))
    #9 C:xampphtdocsmagento20vendormagentomodule-catalog-searchModelResourceModelFulltextCollection.php(197): MagentoSearchModelSearchEngine->search(Object(MagentoFrameworkSearchRequest))
    #10 C:xampphtdocsmagento20vendormagentoframeworkDataCollectionAbstractDb.php(331): MagentoCatalogSearchModelResourceModelFulltextCollection->_renderFiltersBefore()
    #11 C:xampphtdocsmagento20vendormagentomodule-catalog-searchModelResourceModelFulltextCollection.php(224): MagentoFrameworkDataCollectionAbstractDb->_renderFilters()
    #12 C:xampphtdocsmagento20vendormagentomodule-eavModelEntityCollectionAbstractCollection.php(906): MagentoCatalogSearchModelResourceModelFulltextCollection->_renderFilters()
    #13 C:xampphtdocsmagento20vendormagentomodule-catalogModelResourceModelProductCollection.php(719): MagentoEavModelEntityCollectionAbstractCollection->load(false, false)
    #14 C:xampphtdocsmagento20vendormagentomodule-reviewObserverCatalogBlockProductCollectionBeforeToHtmlObserver.php(38): MagentoCatalogModelResourceModelProductCollection->load()
    #15 C:xampphtdocsmagento20vendormagentoframeworkEventInvokerInvokerDefault.php(73): MagentoReviewObserverCatalogBlockProductCollectionBeforeToHtmlObserver->execute(Object(MagentoFrameworkEventObserver))
    #16 C:xampphtdocsmagento20vendormagentoframeworkEventInvokerInvokerDefault.php(61): MagentoFrameworkEventInvokerInvokerDefault->_callObserverMethod(Object(MagentoReviewObserverCatalogBlockProductCollectionBeforeToHtmlObserver), Object(MagentoFrameworkEventObserver))
    #17 C:xampphtdocsmagento20vendormagentoframeworkEventManager.php(65): MagentoFrameworkEventInvokerInvokerDefault->dispatch(Array, Object(MagentoFrameworkEventObserver))
    #18 C:xampphtdocsmagento20vargenerationMagentoFrameworkEventManagerProxy.php(95): MagentoFrameworkEventManager->dispatch(‘catalog_block_p…’, Array)
    #19 C:xampphtdocsmagento20vendormagentomodule-catalogBlockProductListProduct.php(203): MagentoFrameworkEventManagerProxy->dispatch(‘catalog_block_p…’, Array)
    #20 C:xampphtdocsmagento20vendormagentoframeworkViewElementAbstractBlock.php(651): MagentoCatalogBlockProductListProduct->_beforeToHtml()
    #21 C:xampphtdocsmagento20vargenerationMagentoCatalogBlockProductListProductInterceptor.php(882): MagentoFrameworkViewElementAbstractBlock->toHtml()
    #22 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(542): MagentoCatalogBlockProductListProductInterceptor->toHtml()
    #23 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(518): MagentoFrameworkViewLayout->_renderBlock(‘category.produc…’)
    #24 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘category.produc…’)
    #25 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘category.produc…’)
    #26 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘category.produc…’, true)
    #27 C:xampphtdocsmagento20vendormagentoframeworkViewElementAbstractBlock.php(492): MagentoFrameworkViewLayoutInterceptor->renderElement(‘category.produc…’, true)
    #28 C:xampphtdocsmagento20vendormagentomodule-catalogBlockCategoryView.php(98): MagentoFrameworkViewElementAbstractBlock->getChildHtml(‘product_list’)
    #29 C:xampphtdocsmagento20vendormagentomodule-catalogviewfrontendtemplatescategoryproducts.phtml(18): MagentoCatalogBlockCategoryView->getProductListHtml()
    #30 C:xampphtdocsmagento20vendormagentoframeworkViewTemplateEnginePhp.php(59): include(‘C:\xampp\htdocs…’)
    #31 C:xampphtdocsmagento20vendormagentoframeworkViewElementTemplate.php(255): MagentoFrameworkViewTemplateEnginePhp->render(Object(MagentoCatalogBlockCategoryView), ‘C:/xampp/htdocs…’, Array)
    #32 C:xampphtdocsmagento20vendormagentoframeworkViewElementTemplate.php(279): MagentoFrameworkViewElementTemplate->fetchView(‘C:/xampp/htdocs…’)
    #33 C:xampphtdocsmagento20vendormagentoframeworkViewElementAbstractBlock.php(652): MagentoFrameworkViewElementTemplate->_toHtml()
    #34 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(542): MagentoFrameworkViewElementAbstractBlock->toHtml()
    #35 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(518): MagentoFrameworkViewLayout->_renderBlock(‘category.produc…’)
    #36 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘category.produc…’)
    #37 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘category.produc…’)
    #38 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘category.produc…’, true)
    #39 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘category.produc…’)
    #40 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘content’)
    #41 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘content’)
    #42 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘content’)
    #43 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘content’, true)
    #44 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘content’)
    #45 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘main’)
    #46 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘main’)
    #47 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘main’)
    #48 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘main’, true)
    #49 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘main’)
    #50 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘columns’)
    #51 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘columns’)
    #52 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘columns’)
    #53 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘columns’, true)
    #54 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘columns’)
    #55 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘main.content’)
    #56 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘main.content’)
    #57 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘main.content’)
    #58 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘main.content’, true)
    #59 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘main.content’)
    #60 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘page.wrapper’)
    #61 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘page.wrapper’)
    #62 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘page.wrapper’)
    #63 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘page.wrapper’, true)
    #64 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(569): MagentoFrameworkViewLayoutInterceptor->renderElement(‘page.wrapper’)
    #65 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(520): MagentoFrameworkViewLayout->_renderContainer(‘root’)
    #66 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement(‘root’)
    #67 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(472): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement(‘root’)
    #68 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(193): MagentoFrameworkViewLayout->renderElement(‘root’, true)
    #69 C:xampphtdocsmagento20vendormagentoframeworkViewLayout.php(938): MagentoFrameworkViewLayoutInterceptor->renderElement(‘root’)
    #70 [internal function]: MagentoFrameworkViewLayout->getOutput()
    #71 C:xampphtdocsmagento20vendormagentoframeworkInterceptionInterceptor.php(144): call_user_func_array(Array, Array)
    #72 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewLayoutInterceptor.php(494): MagentoFrameworkViewLayoutInterceptor->___callPlugins(‘getOutput’, Array, Array)
    #73 C:xampphtdocsmagento20vendormagentoframeworkViewResultPage.php(241): MagentoFrameworkViewLayoutInterceptor->getOutput()
    #74 C:xampphtdocsmagento20vendormagentoframeworkViewResultLayout.php(162): MagentoFrameworkViewResultPage->render(Object(MagentoFrameworkAppResponseHttpInterceptor))
    #75 [internal function]: MagentoFrameworkViewResultLayout->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
    #76 C:xampphtdocsmagento20vendormagentoframeworkInterceptionInterceptor.php(74): call_user_func_array(Array, Array)
    #77 C:xampphtdocsmagento20vendormagentoframeworkInterceptionChainChain.php(70): MagentoFrameworkViewResultPageInterceptor->___callParent(‘renderResult’, Array)
    #78 C:xampphtdocsmagento20vendormagentoframeworkInterceptionChainChain.php(63): MagentoFrameworkInterceptionChainChain->invokeNext(‘Magento\Framewo…’, ‘renderResult’, Object(MagentoFrameworkViewResultPageInterceptor), Array, ‘result-varnish-…’)
    #79 C:xampphtdocsmagento20vendormagentomodule-page-cacheModelControllerResultVarnishPlugin.php(74): MagentoFrameworkInterceptionChainChain->MagentoFrameworkInterceptionChain{closure}(Object(MagentoFrameworkAppResponseHttpInterceptor))
    #80 [internal function]: MagentoPageCacheModelControllerResultVarnishPlugin->aroundRenderResult(Object(MagentoFrameworkViewResultPageInterceptor), Object(Closure), Object(MagentoFrameworkAppResponseHttpInterceptor))
    #81 C:xampphtdocsmagento20vendormagentoframeworkInterceptionChainChain.php(68): call_user_func_array(Array, Array)
    #82 C:xampphtdocsmagento20vendormagentoframeworkInterceptionInterceptor.php(136): MagentoFrameworkInterceptionChainChain->invokeNext(‘Magento\Framewo…’, ‘renderResult’, Object(MagentoFrameworkViewResultPageInterceptor), Array, ‘result-builtin-…’)
    #83 C:xampphtdocsmagento20vendormagentomodule-page-cacheModelControllerResultBuiltinPlugin.php(67): MagentoFrameworkViewResultPageInterceptor->MagentoFrameworkInterception{closure}(Object(MagentoFrameworkAppResponseHttpInterceptor))
    #84 [internal function]: MagentoPageCacheModelControllerResultBuiltinPlugin->aroundRenderResult(Object(MagentoFrameworkViewResultPageInterceptor), Object(Closure), Object(MagentoFrameworkAppResponseHttpInterceptor))
    #85 C:xampphtdocsmagento20vendormagentoframeworkInterceptionInterceptor.php(141): call_user_func_array(Array, Array)
    #86 C:xampphtdocsmagento20vargenerationMagentoFrameworkViewResultPageInterceptor.php(130): MagentoFrameworkViewResultPageInterceptor->___callPlugins(‘renderResult’, Array, Array)
    #87 C:xampphtdocsmagento20vendormagentoframeworkAppHttp.php(119): MagentoFrameworkViewResultPageInterceptor->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
    #88 C:xampphtdocsmagento20vendormagentoframeworkAppBootstrap.php(258): MagentoFrameworkAppHttp->launch()
    #89 C:xampphtdocsmagento20index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttp))
    #90 {main}

  • Jeffery

    I have an error prompt in below:

    CDbConnection failed to open the DB connection: could not find driver

    • Hello,

      Please give us more detail and post your issue to our QUESTION area with full information then our team will solve.

      Thanks

      Sincerely,

      Ubertheme Team

      • Jeffery

        It’s solved.Thanks!

        • sachin

          Hello, I have the same issue. Please let me know, How did you solved it. I am using ubuntu machine.

          • Hi sachin,
            This tool use the PHP Sqlite, let’s enable it in your web server to solve the issue.
            Regards,
            UberTheme.

          • dickd

            Is pdo_Sqlite the same as Sqlite ?

            and if not will going back to a php version that has Sqlite fix the issue ?
            The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.”

          • Hi dickd,
            Seem you have a prefix in database of your Magento 1? Let’s setting it in step 1 of this tool.
            And contact me if you have more question on this tool.
            Regards,
            Mall.

  • Jeffery

    I have 80000+ product in magento1.7 .
    Execution to the step5: Migrate Products.
    After about 10 hours, the page of migration tool is still running.
    I opened the back-end of magento2, to view the number of products, have all migrated.
    But why not jump to the next step?

  • moe

    I’m getting the following error when trying to migrate my Magento 1.7 site to Magento 2.0 :
    CDbException
    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.

    • Hello,

      Please click to next button to complete step 9 then do # Step 4: Complete the tasks bellow to finish the data migration process: https://github.com/ubertheme/magento2_data_migration.

      Other way, Please make lightshot all your error process and send to us, we will support and work out

      Thanks,

      Best,

      Ubertheme Team

  • asad app

    USA yellow pages http://ypagesonline.com .,.

  • Fernando Moles

    Dear, I have tis error:

    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.

    /chroot/home/compunov/foronotebooks.com.ar/html/data-migration/yii/db/ar/CActiveRecord.php(2385)

    2373
    2374 /**
    2375 * Constructor.
    2376 * @param CActiveRecord $model the model instance
    2377 * @throws CDbException if specified table for active record class cannot be found in the database
    2378 */
    2379 public function __construct($model)
    2380 {
    2381 $this->_modelClassName=get_class($model);
    2382
    2383 $tableName=$model->tableName();
    2384 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null)
    2385 throw new CDbException(Yii::t(‘yii’,’The table “{table}” for active record class “{class}” cannot be found in the database.’,
    2386 array(‘{class}’=>$this->_modelClassName,'{table}’=>$tableName)));
    2387
    2388 if(($modelPk=$model->primaryKey())!==null || $table->primaryKey===null)
    2389 {
    2390 $table->primaryKey=$modelPk;
    2391 if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey]))
    2392 $table->columns[$table->primaryKey]->isPrimaryKey=true;
    2393 elseif(is_array($table->primaryKey))
    2394 {
    2395 foreach($table->primaryKey as $name)
    2396 {
    2397 if(isset($table->columns[$name]))

  • nht48823

    I am getting the following error, after i enter the database info save and click next thats when i see this error.
    for testing purposes i have created two test1 and test2 databases with root and no pw. i am still getting this error.

    CDbException

    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiidbarCActiveRecord.php(2385)

    2373
    2374 /**
    2375 * Constructor.
    2376 * @param CActiveRecord $model the model instance
    2377 * @throws CDbException if specified table for active record class cannot be found in the database
    2378 */
    2379 public function __construct($model)
    2380 {
    2381 $this->_modelClassName=get_class($model);
    2382
    2383 $tableName=$model->tableName();
    2384 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null)
    2385 throw new CDbException(Yii::t(‘yii’,’The table “{table}” for active record class “{class}” cannot be found in the database.’,
    2386 array(‘{class}’=>$this->_modelClassName,'{table}’=>$tableName)));
    2387
    2388 if(($modelPk=$model->primaryKey())!==null || $table->primaryKey===null)
    2389 {
    2390 $table->primaryKey=$modelPk;
    2391 if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey]))
    2392 $table->columns[$table->primaryKey]->isPrimaryKey=true;
    2393 elseif(is_array($table->primaryKey))
    2394 {
    2395 foreach($table->primaryKey as $name)
    2396 {
    2397 if(isset($table->columns[$name]))

    Stack Trace

    #0

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiidbarCActiveRecord.php(411):
    CActiveRecordMetaData->__construct(Mage1Website)

    #1

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiidbarCActiveRecord.php(661):
    CActiveRecord->getMetaData()

    #2

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiidbarCActiveRecord.php(1355):
    CActiveRecord->getTableSchema()

    #3

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiidbarCActiveRecord.php(1475):
    CActiveRecord->query(CDbCriteria, true)

    #4

    –

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masterprotectedcontrollersMigrateController.php(237):
    CActiveRecord->findAll(“code ‘admin'”)

    232 //variables to log
    233 $migrated_website_ids = $migrated_store_group_ids = $migrated_store_ids = array();
    234
    235 //Get list front-end websites from magento1
    236 $condition = “code ‘admin'”;
    237 $websites = Mage1Website::model()->findAll($condition);
    238
    239 if (Yii::app()->request->isPostRequest && $step->status == MigrateSteps::STATUS_NOT_DONE){
    240
    241 //uncheck foreign key
    242 Yii::app()->mage2->createCommand(“SET FOREIGN_KEY_CHECKS=0”)->execute();

    #5

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebactionsCInlineAction.php(49):
    MigrateController->actionStep2()

    #6

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebCController.php(308):
    CInlineAction->runWithParams(array())

    #7

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebCController.php(286):
    CController->runAction(CInlineAction)

    #8

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebCController.php(265):
    CController->runActionWithFilters(CInlineAction, array())

    #9

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebCWebApplication.php(282):
    CController->run(“step2”)

    #10

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiiwebCWebApplication.php(141):
    CWebApplication->runController(“migrate/step2”)

    #11

    +

    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masteryiibaseCApplication.php(184):
    CWebApplication->processRequest()

    #12

    –
    E:wampwwwdata-migration-toolmagento2_data_migration-mastermagento2_data_migration-masterindex.php(13): CApplication->run()

    08
    09 //remove the following line when in production mode
    10 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’, true);
    11
    12 require_once($yii);
    13 Yii::createWebApplication($config)->run();

  • nht48823

    does this tool work?
    i am still getting this error…please help

    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database.

    /chroot/home/installs/installsoundgear.com/html/migrate-data-tool/yii/db/ar/CActiveRecord.php(2385)

    • @nht48823:disqus

      Thanks for working around this tool, hope it could help you some way.
      As data migration itself is a complex task as it relates to different factors including the server condition etc., we do provide migration custom service. Just add a note here, in case you might want to use our service.

      Regards,
      UberTheme.

    • Seem the issue come from your permission files/folders.
      Let’s enable recursive write permission for folder in your magento 2 webroot: /pub
      Regards,
      UberTheme.

  • This blog is very useful. Thanks for giving information – http://goo.gl/5qymnH

  • Mindless3Witches

    The table “{{core_website}}” for active record class “Mage1Website” cannot be found in the database, Please provide me infor about this if anyone have solved this issue!

    • Hi Mindless3Witches,
      Can you share me more information about your working? Some screenshots will be as a good information.
      Also, for technical question let’s submit at: https://www.ubertheme.com/questions/
      Regards,
      Mall.

      • Mindless3Witches

        Thank you! I fixed the above problem but I need further help in customer transfer, I completed all the steps in Data Migration Tool successfully and regarding the customer there are 221 customer in my old magento 1 database which is successfully transferred according to Data Migration Tool but it is not shown in magento 2 admin can you please suggest me how to debug!

        • @mindless3witches:disqus
          Let’s make reindex the data of your Magento 2 to solve the issues.
          Regards,
          Mall.

      • Mindless3Witches

        Hi,

        Thank you for reply, I did fixed above problem but I got another problem can you help me please,

        When I transfer product all product transfer successfully but with configurable product I get error non of the product get associated with configurable product any can you help me to fix this problem please?

        • @mindless3witches:disqus:
          Did you re-index the data of your Magento2?
          Regards,
          Mall.

          • Mindless3Witches

            Yes I did re-index magento 2, everything is working fine but configurable product are not linked, no error occur in data migration, when I see log of magento 2 it says “product name” do not have associated product

  • Mindless3Witches

    When I transfer product all product transfer successfully but with configurable product I get error non of the product get associated with configurable product any can you help me to fix this problem please?

  • vipul baldaniya

    Thanks for the information. Now a days Magento 2.0 is best option for Ecommerce development – http://goo.gl/i9f5hs

  • Nice Blog. Thanks for the information. Now a days Magento 2.0 is best option for Ecommerce development – http://goo.gl/PJYqez

  • Hi All,

    Glad to introduce our newly launched UB Data Migration Pro version, with the whole code base revamped. It gives the ability to effectively migrate store data from Magento 1 to Magento 2 site with ease; allows to skip specific group of data and proceed migration in a separated step later on and much more.

    Here you can find full features list: https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro

    PS. For any question or concern about this migration tool, feel free to head over to our Help desk – http://www.ubertheme.com/questions, our team are happy to help you out.

    Sincerely,
    Ubertheme team

  • Hi all,

    Just want to share a reference Magento resource:
    Infographic – The ultimate comparison between Magento 1 and Magento 2 database structure
    (Full size graphic): http://bit.ly/Magento-1-vs-Magento-2-database.

    Hope it can help anyone new to Magento 2 save time to learn about the key changes in Magento 2 database structure, compared to Magento 1.

    Regards,
    Ubertheme Team

  • Hans Proggie

    i got an error in back end try to edit the products and the front end some missing products are not show but all products are migrate.

    exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘petshop_new.catalogsearch_fulltext_scope3’ doesn’t exist

    • Hans Proggie We recently decide to upgrade our migration tool to a premium version UB Data Migration Pro, and no longer maintain the old version on Github. We have a new Lite version (free) as well.

      If you’re interested, here is the full feature list of our new premium migration tool – https://www.ubertheme.com/magento-news/magento-2-data-migration-pro-release/

      Thanks for your understanding.
      Regards,
      Ubertheme Team

      • Hans Proggie

        if im gonna purchase that all this error will be gone?? currently im using 1.6.1.0 magento and im decide to migrate to 2.x

        • @hansproggie:disqus Please try to reindex to see if it helps. If the issue remains, highly recommend you consider our Pro version as it is stable and packed with full features.

          Our Pro version has helped many users migrate their M1 site successfully. Most of issues so far are either they miss specific steps in our guideline or the issues from server side, not our tool.

          PS. Please note our UB Data Migration Pro works with Magento CE only, and your M2 must be a fresh M2 installation.

          Hope that helps.
          Regards,
          Ubertheme Team

          • Hans Proggie

            but i follow all the steps. and prerequisites

          • It’s hard for us to debug as the issue associated with the old migration version that we no longer maintain.

            Our Pro version for sure will help you ease migration. In case of issue that might relate to your server or specific issue of your database, our developers will debug and help you out.

            Further, we have 7 days money guarantee back, you’re safe to go with our UB Data Migration pro. Anyway, for all our recent users who use this tool recently, there appear some issues in specific cases, however all are from outside factors, not our tool and we did successfully resolve those issues.

            Hope you take that into consideration.
            Regards,
            UberTheme

  • Hi guys,
    We’ve just released a big update to UB Data Migration Pro (V3) – http://bit.ly/ub-data-migration-v3. Just want to leave a message here in case you miss this important update.
    It enables delta migration, supports PHP Memcached and much more.
    Hope you like the new V3.
    Regards,
    Ubertheme team