Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

In SSMS, right-click the database and select Tasks > Back Up. Select the Files and filegroups option. Select the files and filegroups that you want to back up and press OK. How to Create a File or ...

I strongly recommend setting the database to simple recovery model. Create the database schema by running Create IMDB-schema.sql in the database. Download and import the IMDB dataset using the ...