Issues after restoring MS-SQL Database

We are building a new ProductCart BTO store on a new server to replace an older productcart store.

We have exported the SQL DB from the old store, and I imported it into the new store, but I'm having a few issues. 

For example, whenever I click on any of the category links on the storefront after the restore, I now get errors such as:

“Description: Invalid object name 'pcCatPromotions'.

query=SELECT POrder FROM categories_products WHERE idCategory=XX;”

 and

“Description: Item cannot be found in the collection corresponding to the requested name or ordinal.

query=SELECT POrder FROM categories_products WHERE idCategory=1;”

I also am now getting a "Page Not Found" when clicking on certain links in the store, which just started happening after the DB restore.

In the PC Control Panel, all the old orders, etc now show up just fine, and the merchant account info transferred over, etc. - but if I click on certain links, such as "Manage Content Pages" (for example), I will get a "Error Loading Content Pages", and if I click on a product to edit in the CP, I get a "Error on modifyProduct in main SQL query"

Any help would be greatly appreciated on this, thank you

-J