@scottalanmiller said in $200 firewall:
You can't spend much on a UBNT AP here in North America. APs start around $65, that's what I paid for mine. They definitely get up closer to $300, but normally for super high end units.
I bought 2 X UniFi AP AC's in 2014 for A$ 370 each and it looks like now you get the Pro version for A$250ish..
@scottalanmiller said in $200 firewall:
Their wireless access points are excellent, too.
I have a couple of their APs here in the Oz office, they are not cheap here however 
So I was not expecting any of their products in that price range.
I ordered one from the Amazon link you sent!
This is for my mid-west office.
The current firewall got fried after the last month's storm and I do not want to buy a similar model as I now got only 2 users in that office (I thought I could enable the firewall options on the Comcast cable modem but for some reason it is not allowing me to disable the "remote management" rules setup by the Comcast team).
Can someone suggest some firewall models (not a Firewall +WiFi combo) in the $200 range please?
(No VPN server required, just a basic firewall)
I am trying to set this up at the moment but I couldn't find any documentation other than a link posted on https://www.mediawiki.org/wiki/Topic:Skkooey4fmnshld0 , which is also of not great help - I followed it but couldn't get the Parsoid working.
@scottalanmiller said in How to sync MSSQL with Maria DB:
Did any of these resources end up getting you to where you needed to be? Or are you still looking for more guidance?
We wrote a PHP script and at the moment it is working the way we wanted. Script basically polls the MS SQL database every 10mins and looks for new records and copies to our local MariaDB. It was a great learning curve though
Thanks everyone for your help and suggestions!
@scottalanmiller I do not think I am knowledgeable enough to make something similar all by myself.
It is a bunch of interconnected SQL tables but making a user friendly customer interface requires some coding skills I think.
We have been using http://www.trackvia.com/ for more than 5 years and now they are pushing their customers to their newer platform with a starting price of US$ 1,000 per month (this is huge when compared to their original platform which was starting at as little as $100 per month and we are paying only ~ $400 per month at the moment).
Are there anyone using similar services to give me some recommendations?
@scottalanmiller
Let me explain. We are into wind farm development industry and recently, I have been tasked to develop an in-house system to collect and store data from our various Wind farms so that our research team could use this data to further improve our wind modelling software.
At the moment, we are downloading a "sub-set" of this data from a dashboard provided by our turbine manufacturer by going through a VPN tunnel to their network. When I discussed this requirement with our turbine manufacturer, they gave us read access to our specific database on their MS SQL based database server. Since our researchers are using LAMP for development works I setup a LAMP server using Cent OS 7 and connected to this remote database using the Linux ODBC drivers supplied by Microsoft over a vpnc session.
Now I could connect to the remote MSSQL server using the isql command and query the database.
However, I still need to figure out a way to sync this remote database to my local mysql database.
"Sync" may not be the right word to use as I would need to copy only a specific set of tables every 10 minutes in one direction (MSSQL -> MYSQL)
Would this be possible without buying any third party software tools (like https://dbconvert.com/mysql/mssql/)?
Thanks everyone for your help!
Linked MSSQL server may not be viable in my situation as the MSSQL server is maintained by our service provider on their own network and I won't be able to setup anything on their network.
However, I did find something here http://dominik.szynk.net/centos-6-x-and-microsoft-sql-server-odbc-linux-driver/ which seems to be the way to in my case.
I have a requirement for syncing (say every 10 minutes) a Maria DB database with MS SQL 2012 server over a VPN connection.
My LAMP server and VPN are up but I have no idea how to talk to the MS SQL server from the Linux box.
Can someone give me some guidance please?