You can then use Windows Task Scheduler to run this script. Then, use (free) to FTP the files.
Sqlbackupandftp is a software application that allows you to backup your SQL databases and transfer them to an FTP server with ease. It supports multiple SQL database types, including MySQL, PostgreSQL, and Microsoft SQL Server. Sqlbackupandftp License Key
: Install the app on the new server and enter your key. You can then use Windows Task Scheduler to run this script