I have the below requirement:
I need to migrate data from a source to Azure SQL DB.
Source: Csv file. Number of sheets = Number of entities. Number of columns in sheet = Fields in respective entities. I need to migrate data from Source to Azure SQL DB. Source is on my local system.
I tried to used to Copy Data Launch wizard keeping Source connector as File System. However, in that scenario, I am unable to install the gateway.
Please suggest me how do I proceed.
You can also put those CSV files on a BLOB storage and upload their content to a SQL Azure Database as shown below.
BULK INSERT Test
WITH ( DATA_SOURCE = 'MyAzureBlobStorage',
FORMAT='CSV', CODEPAGE = 65001,
Hope this helps.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?