Local SQL Server Container for automatic buffering and deletion of SQL data log.

Look into the possibility of

• A native HC Service Container with the ability to redirect all the SQL queries to the Customer's Production SQL Server
• Can keep the buffer while the SQL Server is not approachable,
• otherwise, simply relay the REDO logs to the main SQL Server
• Reporting Connector always updates the local instance
• Produce load aggregation so verify the concept it able to coop up with the requirement of a fully loaded system
• Identify any possible hiccups
• scale up/down if needed
• perform load tests to check the system resource usage class i-e memory, CPU, Network, IO.
• Involve someone with SQL server expertise to implement the above.