Due to size limitation of SQL express (10GB) I've had to make a new database to give the IT team time to figure out archiving of old data. In the meantime, I'd like to be able to read data from the old database and the new one, based on the date. I use a few (3) easy charts, so there's not a lot of changes to make. Currently the easy chart displays historical data based on the date range selected by the user, but if that date range spans the database change-over time, how do I query (and combine) both databases?
There's no automatic way to do that.
If you need a free database, convert to PostgreSQL or MariaDB.
2 Likes
I'm not looking for an automatic way, but rather something like a drop down selector for the user that lets them choose which database to read from. The real trouble is going to be if a time span crosses databases, I don't know how to combine datasets in the easy chart, if it's even possible?
I don't have control over which database is installed 
though I will certainly suggest to the IT team.
Not possible.
You could script something to combine datasets for the Classic Chart.
1 Like
Ah, okay then. Time to stop beating my head against the wall!
Thanks!