Forum Discussion

Mirek_Silhavy's avatar
Mirek_Silhavy
Copper Contributor
Feb 12, 2024

Send data from MSSQL DB to UA server

Hi.

I would like to know if it is possible to send data from DB to UA server - change the value on the UA Server. 

Like some trigger, which checks one column in DB and when value in this column changes (there is just one row in column and the value changes) server sends/writes this changed value (int16) into the UA server tag/cell.

Is this possible to do directly in the DB system?

 

Thanks for advice/ explanation.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Feb 13, 2024
    For me your post/requirement is not clear. Why not a simple backup + restore?
    • Mirek_Silhavy's avatar
      Mirek_Silhavy
      Copper Contributor
      Feb 13, 2024

      olafhelper 

      Hi. What should I backup and restore?

      What do I need is: I have DB where one cell can change value in time and I need to send this value directly to Siemens PLC when it changes.

      But I assume it is not possible to send this value to PLC using MSSQL functions. So I want to send it to UA Server (this is the main question - is it possible?) and the PLC would read it from this server.

      Third possibility for me is to write connector between MSSQL and Siemens PLC (I already have working part). But it will be better when the MSSql could solve it itself.

Resources