Here is a quick update of my migration. I have successfully migrated the product and category data with following SQLs. The only difference between the two databases is the new field introduced by TB1.0.0, which is 'displayfromsub', so excluded it when copying over the category table.
BTW, since we have not built up the product attribute data yet, just skipped the attributes related tables in my practice.
```
Table: category
Node: field 'displayfromsub' is not in the source table
insert into thirtybees.tbcategory (idcategory,idparent,idshopdefault,leveldepth,nleft,nright,active,dateadd,dateupd,position,isrootcategory) select idcategory,idparent,idshopdefault,leveldepth,nleft,nright,active,dateadd,dateupd,position,isrootcategory from prestashop.pscategory where id_category > 11;
Table: category_group
insert thirtybees.tbcategorygroup select * from prestashop.pscategorygroup where id_category > 11;
Table: category_lang
insert thirtybees.tbcategorylang select * from prestashop.pscategorylang where id_category > 11;
Table: category_shop
insert thirtybees.tbcategoryshop select * from prestashop.pscategoryshop where id_category > 11;
Set 'Maximum depth' setting of blockcategories module
Table: product
insert thirtybees.tbproduct select * from prestashop.psproduct where id_product > 7;
Table: product_lang
insert thirtybees.tbproductlang select * from prestashop.psproductlang where id_product > 7;
Table: product_shop
insert thirtybees.tbproductshop select * from prestashop.psproductshop where id_product > 7;
Table: category_product
insert thirtybees.tbcategoryproduct select * from prestashop.pscategoryproduct where id_category > 11;
Table: image
insert thirtybees.tbimage select * from prestashop.psimage where id_product > 7;
Table: image_lang
insert thirtybees.tbimagelang select * from prestashop.psimagelang where id_image > 23;
Table: image_shop
insert thirtybees.tbimageshop select * from prestashop.psimageshop where id_product > 7;
insert thirtybees.tbemployee select * from prestashop.psemployee where idemployee > 1;
insert thirtybees.tbemployeeshop select * from prestashop.psemployeeshop where idemployee > 1;
```