Catalog Partition for 8.15

pkellner

Vote:

Hi,

I'm trying to get Catalog Paritioning working with Episerver Commcerce 8.15. I've followed the directions here:

http://world.episerver.com/documentation/Items/Developers-Guide/EPiServer-Commerce/8/Catalogs/Catalog-database-partitioning/

The script ecf_db_CatalogSystem_DataLoad.sql failed due to there being no Application table in the new catalog database. So I ran the following:

ecf_db_ApplicationSystem_schema.sql

ecf_db_ApplicationSystem_storedprocedures.sql

ecf_db_ApplicationSystem_DataLoad.sql

ecf_db_ApplicationSystem_diagram.sql

And we able to complete ecf_db_CatalogSystem_DataLoad.sql without error. However on going to the website I got an error that GetContentSchemaVersionNumber did not exist, so I added the table SchemaVersion from cms_db_schema.sql and populated with data using script cms_db_dataload.sql.

After this the website now states that the table dbo.ShippingMethodParameter doesn't exist in the table, it appears that the new database is being used for all Commerce functionality and not just Catalog like I wanted. Is there a reason for this? Is there a setting in the old Commerce database that needs to be set to enable partitioning?

Thanks

#143271

Jan 18, 2016 22:45

Mark Hall

Vote:

I am assuming you create a new connectionstring and pointed ecf.catalog.config to that. I am not sure this feature still works in version 8. I think once you fix the configuration the problem will be the metaclass and metafield tables need to replicated to the new server becasue the stored procedure generation needs those two to properly update.

#143311

Jan 20, 2016 1:38

pkellner

Vote:

Yes, that is correct.

What I am trying to accomplish is a way to have the Commerce Catalog data in a test environment, verify and then transfer only the Catalog data to production. Additionally have the ability to rollback any Catalog changes in prodution if there are issues.

To me, the Catalog Parition feature would fit the bill here, what would be the recommended path to accomplish this?

Thanks

#143341

Jan 20, 2016 18:04

Quan Mai

Vote:

I think you can use the catalog export/import feature here. Would be easier to do than the catalog partitioning.

Regards,

#143342

Jan 20, 2016 18:53

pkellner

Vote:

This seems to work to synch the data, however associated assets like images or pdf's don't get synched. Is there a recommendation for this?

Thanks

#143693

Jan 28, 2016 23:26

Quan Mai

Vote:

Hi,

If you are using the associated assets, you'll have to import/export in the context of front-end site (which has the required content type models).

You can use Mediachase.Commerce.Catalog.ImportExport.ImportJob to write that feature - would be very small code anyway.

Another option is to use ServiceAPI.

Regards.

#143697

Jan 29, 2016 7:05