Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 7.x > Portal Engine > Will adding a split function to the database break the upgrade path?

View modes:

Member

vcarter - 7/9/2013 11:36:51 AM

Will adding a split function to the database break the upgrade path?

After conferring with our client, we have decided that the best way to handle many to many data relations for advanced content filtering is via custom user controls and the addition of a simple split function to SQL server.

My thoughts are that provided no Kentico functions are altered, the addition of a Split UDF will not be impacted by future updates, however I would like to make sure all bases are covered moving forward.

Any information on this subject would be appreciated.

Kentico Legend

Brenden Kehren - 7/9/2013 12:41:06 PM

RE:Will adding a split function to the database break the upgrade path?

As long as you give the function a unique name you should be just fine. I'd suggest to not use similar naming conventions as Kentico because there could be problems with that if they search by a LIKE term. So stay away from "Func_...." do something like "fn_Your_Name" or "custom_fn_your_name".


Member	vcarter - 7/9/2013 12:43:38 PM RE:Will adding a split function to the database break the upgrade path? Thanks FroggEye, as always you are a great source of information and it is greatly appreciated.


Kentico Legend	Brenden Kehren - 7/9/2013 12:52:59 PM RE:Will adding a split function to the database break the upgrade path? Not a problem! I've added several stored procs and functions that I wasn't able to add within the UI and as long as you stay away from Kentico's naming schema, I will almost guarantee you're safe.

Member

vcarter - 7/9/2013 1:11:05 PM

RE:Will adding a split function to the database break the upgrade path?

That's what I figured. I spent a bunch of time trying to find a way of doing this utilizing the portal engine, but in the end, custom user controls and the addition of simple function definitely seems like the way to go. And the client is on board so long as it doesn't negatively impact the update/upgrade process. Which IMO, even if it needed to be re-created wouldn't really be that big of a deal.

Thanks again.

Top