@Mehboob Ahmad No. Stored procedures and triggers execute within the context of a single container and logical partition key.
In this example, Both data types should be stored in a single container with a property to discern between the “model” type and “serial” type. For example, if we had an airline database where every ticket booking also generates a seat reservation item, we would include both types of items within a single container.
However, if you want to respond to something happening to your model container, say a new item is inserted or an existing item is updated. Then check a specific property value and use that to then do something else in your Serial container, that’s something you can do using Change Feed. In that scenario, I would not store the data in the same container.
Dear Sir @GeethaThatipatri-MSFT
On Insert/Update document In Model Container i want call trigger which will insert document in Serial Container
is it possible or not?
if not then define way to handle this Problem?
@Mehboob Ahmad Thanks for sharing this information, li am checking internally if this is possible.