I need to create online dashboard using data from SQL database from windows server 2012. This dashboard should contain charts, and should be able to autorefresh data.
My biggest problem is how can I make an access to that SQL file (which is around 600mb) from windows server.
Making php based charts is not a big deal, also I have found plenty online services that are offering online charts, but my problem is how can I connect it, because, I can copy database, and make a chart from it, but it needs to be a "live" connection between win server and that website where I'm gonna place dashboard, becuase it's the only way to make autorefreshed chart (at least I think it is). I have also thought to autosync it with dropbox and then somehow make a connection with dropbox, but I think that's not possible. Any help will be highly appreciated.