Ignition 8, MSSQL
Our ignition installation is in its infancy and I want to get the SQL database structure right at the start.
The factory is split into approximately 6 departments, with around 4 manufacturing cells per department, each containing a number of machines or other assets. Eventually, we will be aquiring data from most of the assets.
I currently have two schema, one is used as a historian (ignition tag historian) and the other is used for storing batch data for use in various reports.
Are there any recommendations for a good database structure for the setup above? Should I have a schema for each manufacturing cell and set this as its own historical data provider? I ask because I see the potential for issues with the current arrangement when we are logging all historical data to 1 schema.
Any advice would be great. Thanks.