cancel
Showing results for 
Search instead for 
Did you mean: 

Solution Packager- Sql server - Foreign key constraints and Trigger

Former Member
0 Kudos

Hi all,

Is it possible to keep foreign key constraints and Trigger define from one company to the new one when using solution packager?

Thank you.

Mathieu Malmendier

Accepted Solutions (1)

Accepted Solutions (1)

former_member201110
Active Contributor
0 Kudos

Hi Mathieu,

SQL triggers and constraints on standard SBO tables are not supported for use with SAP Business One. The only exception is if they are on user-defined tables or non-SBO SQL tables and that the trigger does not write to any standard SBO table.

Because of this, I doubt that Solution Packager would allow you to package these types of objects.

Kind Regards,

Owen

Former Member
0 Kudos

Hi Owen,

Thank you for your answer.

In fact, it's on user defined tables and user defined fields that i want to create constraints and trigger. Right now, when i use solution packager the constraints are not copied from one company to the other. I suppose that our only option to reproduce the constraint is to create a script.

Kind Regards,

Mathieu

Answers (0)