{"id":3306,"date":"2020-02-16T17:27:50","date_gmt":"2020-02-16T16:27:50","guid":{"rendered":"http:\/\/van-maanen.com\/?p=3306"},"modified":"2020-02-16T17:27:50","modified_gmt":"2020-02-16T16:27:50","slug":"adding-data-in-azure-with-the-bulk-loader","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=3306","title":{"rendered":"Adding data in Azure with the bulk loader"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I am quite impressed with Azure SQL Server. The DBMS is easy to understand as will be shown below.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The problem is how to add data from a local file (&#8220;uit&#8221;) to the Azure SQL Server environment. This is done in two steps. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The first step is to create a table from the command line with help of sqlcmd:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlcmd.exe -S sqlservertomvanmaanen.database.windows.net -d sqlservertomvanmaanen -U tomvanmaanen -P ******** -I -Q \"CREATE TABLE ff1(test varchar(50));\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The actual loading process is then done with the bulk loader command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">bcp ff1 in C:\\Users\\tmaanen\\CloudStation\\Pensioenfonds\\Python\\uit -S sqlservertomvanmaanen.database.windows.net -d sqlservertomvanmaanen -U tomvanmaanen -P ********  -q -c -t  ,<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 (&#8220;uit&#8221;) to the Azure SQL Server environment. This is done in two steps. The first step is to create a table from the command line [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3306","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3306"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3306\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3306"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}