Re:Show HN: X to Elasticsearch Sync
by TYPE_FASTER on Saturday November 18, 2017 @02:44PM
(#15730322)
I’m assuming they’re adding a trigger to the source table.
[ Parent
| on HN ]
> I’m assuming they’re adding a trigger to the source table.
Their video demo for SQL Server simply points the command line at a connection string, and it then says 2 item(s) indexed. There wasn't a way to pick specific tables.
That means if the trigger method is true, they're adding a trigger by default to every single table in the database. That would be a remarkably bad idea.
Re:Show HN: X to Elasticsearch Sync
by Mister_Snuggles on Saturday November 18, 2017 @06:12PM
(#15731204)
The PostgreSQL one uses the logical replication feature, perhaps the MSSQL piece does something similar.