Hello every one
I need to copy data between 2 different SQL Servers.
I need it to be scheduled every hour. how can I do this?
I tried the Insert into query on SQL Job (for schedule) but there is limitation with the insert into query.
so if there's another method or I can modify the job I would be happy to know
thanks in advance.