Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bennyk123456
Starting Member
3 Posts |
 Posted - 2011-10-29 : 19:40:53
|
| Hello,i am an engineering student who badly needs help.I have taken on a project where i must create an industrial historian database cheaply.basically i will have data from a speed sensor comming into a computer. i nedd to be able to log this data in a database and access speed values at different times.I would like a database that would update automatically and log a speed along with a time stamp. I have downloaded SQL server 2008 inthe hope of creating a database.the problem is i dont know where to start or even if SQL 2008 can fullfil my requirments.if anyone could direct me in creating a database that would automatically log data and time stamp it i would be very gratefulthanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bennyk123456
Starting Member
3 Posts |
Posted - 2011-11-01 : 07:18:03
|
| Hello,Thank you very much for the reply. wel i am not really that strong at any programming languageIf there was already an application created that i could downlaod to write to the database I could use that.just to give a quick overview of what i am trying to achieve:I have 4 discrete pulse signals coming into a PLC that contains a high speed counter. I would like to be able to connect the PLC to the SQL server database via OPC. As mentioned I would like the SQL server database to record the speed in 1 minute increaments automatically. then I would like to be able to pull the archived data from the SQL database and display it the form of trends with VB.I can use any pre designed applications etc (free ones preferably). the main priority is to get the system working.regards,Brendan |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-01 : 07:25:20
|
| I think it unlikely that you would want to capture the data from within sql server.You might use the agent to schedule a task to capture it and insert into the database - but that task would probably be written in something that could easily interface with the PLC.Treat the interface as separate from the database.Create a table to hold the data and the interface application just extracts from the PLC and inserts.A seperate task is to query that data.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Help for a student