@Grant Fritchey - Thanks for your reply. We kind of have the AZure active directory set-up. I am planning to do BCP out to local server for export (.dat file), use Azure copy to copy the .dat file to Azure blob storage and do an import with the help of using EXTERNAL DATA SOURCE and BULK insert commands to Azure SQL database. Thinking of creating 3 different SPROC's for the above operations and use Elastic jobs for scheduling it(with powershell). Will this approach not work? We can use Azcopy to copy the files.. Am I thinking in the rite direction?