Is there a way to import Blob files into sql server 2008 other than using CLR ?
The file size is around 300MB so CLR isn't efficient enough. Is there a possibility to use
BULK INSERT or
OPENROWSET in 2008 server?
Example in Sql Server 2017 we can do this
CREATE DATABASE SCOPED CREDENTIAL AzureDevBlobImportCred WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = 'st=2018-12-05T.....' go CREATE EXTERNAL DATA SOURCE AzureDevBlobImportExternalSrc WITH ( TYPE = BLOB_STORAGE, LOCATION = 'https://myStorageAccount.blob.core.windows.net', -- storage account URL CREDENTIAL = AzureDevBlobImportCred -- External Data Source );
then we can use the external data source in bulk import
BULK INSERT #Mytemptable FROM 'filename' WITH (DATA_SOURCE = 'AzureDevBlobImportExternalSrc' );
So do we have something like above to import blob files in Sql Server 2008 ?