Adding data in Azure with the bulk loader

I am quite impressed with Azure SQL Server. The DBMS is easy to understand as will be shown below.

The problem is how to add data from a local file (“uit”) to the Azure SQL Server environment. This is done in two steps.

The first step is to create a table from the command line with help of sqlcmd:

sqlcmd.exe -S sqlservertomvanmaanen.database.windows.net -d sqlservertomvanmaanen -U tomvanmaanen -P ******** -I -Q "CREATE TABLE ff1(test varchar(50));"

The actual loading process is then done with the bulk loader command:

bcp ff1 in C:\Users\tmaanen\CloudStation\Pensioenfonds\Python\uit -S sqlservertomvanmaanen.database.windows.net -d sqlservertomvanmaanen -U tomvanmaanen -P ********  -q -c -t  ,

Door tom