I have a vendor that is providing data to us in the form of a FTP server with Quest LiteSpeed backups that are updated on a daily basis.
We only have macs and do most of our work in the cloud, so I'm trying to figure out how I can make the data accessible from these backups in an automated fashion. I hadn't heard about Quest before, but my understanding is that there is a (windows only) GUI utility that can restore or convert the backups as well as some kind of extension that you can install on/in/with MSSQL Server to allow you to backup from T-SQL and the command line. It isn't clear to me which product I would need to buy in order to have this functionality, or if there is some kind of free tool.
I would love to find some kind of programming bindings that would allow me to convert the Quest LiteSpeed backups into native. Ideally I'd have some kind of cron job that would copy the backup file to cloud storage, then a lambda/cloud function to convert or restore the backup into something that I can access via code.
I'm pretty new to the world of MSSQL, so any advice would be appreciated.