Hello,
I have multiple tables in different databases on a SQL server 2019, and I have a join query that pulls rows from those multiple tables and insert into one table, This insert query is scheduled to run every 30 minutes, in every run it truncates the target table and loads all the rows. Instead of truncate and load all the rows every time is there a way to set up live data synchronization between those multiple tables and one target table based on the the join query results?
Thanks