If you run multiple environments such as a test and a production environment, you can follow the suggested approach to copy your product data from production (source) to your test (target) environment. Please note, it is not recommended to copy data from test to production environment.
Please ensure to take full backup first before starting the migration. This is an advanced topic and should only be performed by an experienced administrator who has strong understanding of DNN, SQL database and Revindex Storefront. The information provided here is to be used at your own risk without any warranty or support.
The following assumptions are required to successfully refresh the product data:
In order to refresh the product tables, the general idea is to delete the data at the target database first followed by inserting back from the source database. Because many adjacent tables rely on the data from these tables that are being refreshed, we also need to delete the data from the adjacent tables to maintain integrity. For example, we need to delete the data from the Revindex_Storefront_ProductReview, Revindex_Storefront_SalesOrderDetail, etc.
Using SQL Server Management Studio:
Powered by Revindex Wiki