Last post May 13, 2019 12:06 PM by PatriceSc
May 13, 2019 11:53 AM|elahi1mahdi|LINK
I want synchronize two table in two database every 1 hour in sql server ?
can i use job , how to do it ?
May 13, 2019 12:06 PM|PatriceSc|LINK
If not using SQL Server Express that doesn't support using jobs see https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job?view=sql-server-2017#SSMSProcedure
A common approach is to create a job that will just call a stored procedure (rather than copy/pasting complex code as part of the job itself). If this is a full synchronization you could take advantage of https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-2017 and
maybe even of https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017 to skip unchanged rows.