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 ,