I am using Magento 2.0.7 and installed Data Migration Tool. I have found that there are no option to migrate data from magento also I have tried to use ubertheme migration tool but getting below error:

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO `store` (`website_id`, `group_id`, `sort_order`, `is_active`, `store_id`, `code`, `name`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)

Can anyone help me to fix this issue or suggest any better solution to migrate the data? Any help will be appreciated.

  • why there is no option to migrate data from ? DMT works from ->
    – MagenX
    Commented Aug 9, 2016 at 15:08
  • I have edit my question. It Magento 2.0.7 and in DMT 2.0.7 there is no option to migrate form Commented Aug 10, 2016 at 5:36

2 Answers 2

  1. Make sure that the Data Migration Tool has a network access to connect to Magento 1 and Magento 2 databases. Open ports in your firewall.
  2. Stop all activity in the Magento 1.x Admin Panel (except for order management, such as shipping, creating invoice, credit memos etc.)

NOTE: Activity cannot resume until your Magento 2 store goes live.

  1. Stop all Magento 1.x cron jobs.
  2. Use the migration tool to migrate settings and websites.
  3. Copy your Magento 1.x media files to Magento 2.0. (You must copy these manually from /media to /pub/media)
  4. Use Data Migration Tool to migrate your data from Magento 1 database to Magento 2 database. If some of your extensions have data you want to migrate, you might need to install these extensions adapted for Magento 2. In case the extensions have a different structure in Magento 2 database, use the mapping files provided with the Data Migration Tool.
  5. Use the magento indexer:reindex command to reindex all indexers.
  6. Thoroughly test your Magento 2.0 site.

More details on : http://devdocs.magento.com/guides/v2.0/howdoi/migrate/migrate-data.html

I hope this helps you !!

  1. Go to your local database.
  2. Search for "store".
  3. Delete the "Main Store" having website_id=1
  4. Clear cache. And you are done with this error

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.