diffrent database for some tables

How can I a change the database of product table?

I want to nop feeds the product table from another database.

You really cannot change the database of product table.  use the import, or write custom code.

where can I change the connection information of product table in code?

oortaj wrote:

I'm not sure but you need to try with below solution.

First create a Link Server in SQL server and make a schedule job for importing products from another database to nopCommerce product table.

You need to create stored procedure that has ability to check if product is already exist in nop product table then update and if product is not exist in nop product table then insert new product.

but you need to be careful because you need to insert data in nopCommerce another product related tables.

Put this stored procedure in sql server schedule job so that it will run in specific interval.

Thank You.