Hosted SQL advice please
I’m looking to migrate away from our on prem DC and separate SQL server into Azure. My plan is to join our Windows 10 clients to our existing Azure domain (AAD), continue to use Exchange online for email and move files and folders to OneDrive. All of the above I’m happy with so far. The bit I’m unsure about is our SQL databases which our client software uses. I know I can create a SQL instance in Azure and potentially migrate our data across to it but am concerned about latency between the client app and the azure sql instance. We have a 100mb/100mb leased line as our internet link. any advice on this pleaseImport data from Azure Blob storage using Bulk insert Azure SQL Database
Hello there, I am facing one issue while using the BULK insert query to load a .csv file from Blob storage location to Azure SQL data base . I am able to load data into sql data base tables but not not able to create ERRORFILE with error records in BLOB storage . i am getting below error . Msg 4861, Level 16, State 1, Line 4 Cannot bulk load because the file could not be opened. Operating system error code 3(The system cannot find the path specified.). Can any one knows how to fix this error . Thanks Debi