1. Chris Zakrewsky
  2. as Valentina DB Server
  3. Wednesday, April 20 2016, 04:15 PM
  4.  Subscribe via email
Hi,

I need to keep some tables in Valentina DB fully synchronized with identical tables in MS SQLServer.
In other words, any update to Valentina DB table should be mirrored in MS SQLServer table.

What would be the preferred implementation strategy in such case?
Is there any functionality provided by VServer which supports such scenario?
Is it even possible?

Cheers,
/Chris
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Chris,

may be there is sense to make triggers for that Valentina DB, ON INSERT, ON UPDATE, ON DELETE.
which will do something ... for example create file with SQL commands for SQL Server... or just Valentina SQL commands, and later some other app scann txt file and convert that info into SQL Server commands
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Smart City doo Accepted Answer
Is there any example how to create file within trigger?

Zoran
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
No, it's impossible to create file, but you may send notification from the trigger. Say, prepare some text of MSsql statement inside the Valentina trigger and send it to notification listener(s).

https://valentina-db.com/docs/dokuwiki/v11/doku.php?id=valentina:articles:vserver_notifications
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
Probably you should send some message-id within that statement, and store it somewhere as a mark that particular notification has been handled. Something like that to make sure - the both dbs are really synched.
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories