EveryDay data copy from one sql server to another sql serverHi Team
I would like to copy data everyday 4:00AM from one sql server to another sql server
1)creating a new windows service to copy data
2)source sql will send data in the form of a text file and placed in a location from where the data can be loaded to the LCT ASH SQL DB.
Let me know which is best (1 or 2)and can be done in less time.
and what are the requirements for 2nd one.