Regarding the data migration of sql, the younger brother is a beginner. I think it should not be a difficult problem. .

unicorn1

Copy the data of some fields of a table from the remote SQL server to a table in the local SQL server. I want to make a script-like thing and execute it regularly every day. Is there any way?

weh007

There is this function in the database

elfxnami

Use a program or a database

unicorn1

Program do

xuluwei8

I really don't know how to do it on the web. If you use windows form, it is relatively simple. Put a timer in the form and run it once regularly.

heromhd

Write a sql script as a stored procedure, and then create a job, call this stored procedure regularly