Cannot go into category and productDetails after data migration

I recently ported my data from one nopCommerce3.5 database to another by using SQL Server export/import tools on selected tables. I believe I have ported all the tables I need.

However, I noticed I cannot go into categories and product details page after this. Everything else seems okay. I can solved it by opening the category/product from Admin console and save it again. I cannot go into thousands of products I have migrated and click save on all of them. Please help.

From generated html <a href> part is missing. Does anyone know why this is not generated after I migrated my data? I can't find anything in database that is related to this.

Here is example of generated html from a fixed category

<div class="title">
            <strong>
                <a href="/finished-chain" title="Finished Chain">Finished Chain</a>
            </strong>
</div>
<div class="picture">
            <a href="/finished-chain" title="Show products in category Finished Chain">
                <img class="lazy" alt="Picture for category Finished Chain" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" data-original="http://mystore.com/content/images/thumbs/0004223_finished-chain_150.jpeg" />
            </a>
</div>

Here is example of generated html from a bad category
<div class="title">
          <strong>
                <a title="Bails">Bails</a>
            </strong>
</div>
<div class="picture">
            <a title="Show products in category Bails">
                <img class="lazy" alt="Picture for category Bails" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" data-original="http://mystore.com/content/images/thumbs/0001311_bails_150.jpeg" />
            </a>
        </div>

I just realized I forgot to migrate table: UrlRecord. All my seo links are missing, therefore I cannot access my category and productDetails. After port UrlRecord table over, my problem is resolved.