You have to specify more precisely what you need. Do you want to store individual values every 30 seconds as a separate records, or just update the 'current record' with the latest value? If you just need the last one, there's not much point to running the entire SQL setup to store it, so I assume you want the former.
How is your BBB connected to your other boxes: USB or Ethernet? This list is about beaglebone, so probably you won't get much help for setting your Windows/SQL box here, but basically there are two ways to do this system: pushing data from the BBB to Windows, and pulling the data from Windows. If you are familiar with Windows and/or have access to people who can help you there, you should try the latter. You got some good advice on your Google post---use ODBC or other database connector from MSSQL to BBB and automate the periodic update on Windows. Actually, the simplest BBB setup would be a tight loop that waits for a network connection, does a single sensor read and returns the current value; the Windows code would then periodically connect, read and store the data into MSSQL. Having said that, BBB is capable of running the database itself---have you considered implementing the whole system on the BBB? Start describing your system in more detail: first what you want it to do, then what parts you have, then how you want to use them for your purpose. You will help yourself to understand your problem better, and also help others to answer your questions. On Sun, Jan 4, 2015 at 8:30 AM, SHAO MIN <[email protected]> wrote: > Hello, > > does anyone know how to transfer sensor value that i got from my weather > cape auto updated to the sql database server (Windows) and also let the > sensor value run every like 30 seconds and update itself into the sql > database? > > > > > Regards, > Tiffany > > -- > For more options, visit http://beagleboard.org/discuss > --- > You received this message because you are subscribed to the Google Groups > "BeagleBoard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- For more options, visit http://beagleboard.org/discuss --- You received this message because you are subscribed to the Google Groups "BeagleBoard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
