I think the BluePrism schema should be more robust handling scenarios like implementation of the data modelling changes like Historical Tables or Historical database schema concept, I have recommended in the past to change the schema design to implement historical database/table concept in the schema where the data will be moved to history database or tables periodically.
We can enable database catalog or table catalog to enable the read/write on the historical data and restrict the live data to 90 days from the current date and the optional schema should include ability to read data from the historical database/tables from the blue prism Interface.
I believe BP should consider the implementation of advanced features of RDBMS.
If the above cannot be included in the primary schema as some features may not be available in SQL Express edition, however the optional schema options should be provided to the clients where the client uses MS SQL enterprise edition etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.