SaaS CMS has officially launched! Learn more now.

Catalog Partition for 8.15

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
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
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
Vote:
 

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

Regards,

/Q

#143342
Jan 20, 2016 18:53
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
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.

/Q

#143697
Jan 29, 2016 7:05
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.