Toggle Submenu
  1. Forums
  2. Recent
  3. Категории
  4. Теги
  5. Пользователи
Добавить ответ Показать ответы (4)

Решено Synchronisation with MS SQLServer

  1. Chris Zakrewsky
    Chris Zakrewsky
  2. as Valentina DB Server
  3. Среда, Апрель 20 2016, 04:15 PM
  4.  Подписаться через 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
Комментарий
There are no comments made yet.
Ответы (4)
Ruslan Zasukhin
Ruslan Zasukhin Ответ принят
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
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as Valentina DB Server
  3. Постоянная ссылка на этот ответ
Smart City doo
Smart City doo Ответ принят
Is there any example how to create file within trigger?

Zoran
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as Valentina DB Server
  3. Постоянная ссылка на этот ответ
Ivan Smahin
Ivan Smahin Ответ принят
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
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as Valentina DB Server
  3. Постоянная ссылка на этот ответ
Ivan Smahin
Ivan Smahin Ответ принят
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.
Комментарий
There are no comments made yet.
  1. больше, чем месяц назад
  2. as Valentina DB Server
  3. Постоянная ссылка на этот ответ
  • Страница :
  • 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