{"id":12277,"date":"2016-12-06T09:00:13","date_gmt":"2016-12-06T07:00:13","guid":{"rendered":"http:\/\/blog.natro.com\/?p=9896"},"modified":"2019-09-10T10:24:51","modified_gmt":"2019-09-10T07:24:51","slug":"excel-den-sql-veri-tabanina-veri-aktarma-2","status":"publish","type":"post","link":"https:\/\/www.natro.com\/blog\/excel-den-sql-veri-tabanina-veri-aktarma-2\/","title":{"rendered":"EXCEL’den MsSQL Veritaban\u0131na Veri Aktarma"},"content":{"rendered":"

Sizlerden gelen yo\u011fun istek \u00fczerine bu yaz\u0131m\u0131zda Excel yap\u0131s\u0131nda bulunan verilerimizi nas\u0131l MsSQL veritaban\u0131<\/strong> hesab\u0131m\u0131za aktaraca\u011f\u0131m\u0131za anlataca\u011f\u0131z. Sizlerin de bildi\u011fi gibi Excel her t\u00fcr veriyi tablolar i\u00e7inde tutan veri sayfalar\u0131d\u0131r. Fakat Excel taraf\u0131nda veri yo\u011funlu\u011funu artt\u0131k\u00e7a sayfalar ve tablolar \u00fczerinde yap\u0131lan i\u015flemler olduk\u00e7a yava\u015flayacakt\u0131r.<\/span><\/p>\n

Ayr\u0131ca veri yo\u011funlu\u011funun ciddi boyutlara ula\u015fmas\u0131yla beraber gerek veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fcn bozulmamas\u0131 gerekse\u00a0temiz bir data kullan\u0131m\u0131 i\u00e7in sql yap\u0131s\u0131na ge\u00e7i\u015f ka\u00e7\u0131n\u0131lmaz olur. Yukar\u0131da da belirtmi\u015f oldu\u011fumuz gibi bu yaz\u0131m\u0131zda excel datalar\u0131n\u0131z\u0131 nas\u0131l\u00a0MsSQL\u00a0veritaban\u0131<\/strong>\u00a0hesab\u0131n\u0131za\u00a0aktarabilece\u011finizi payla\u015faca\u011f\u0131z.<\/span><\/p>\n

Forumlarda ara\u015ft\u0131rma yaparsan\u0131z ilgili i\u015flemi bir den \u00e7ok y\u00f6ntem ile tamamlayabilece\u011finize dahil makaleler bulabilirsiniz. Fakat biz bu yaz\u0131m\u0131zda veri\u00a0aktar\u0131m\u0131n\u0131 en h\u0131zl\u0131 ve en kolay \u015fekilde nas\u0131l yapabilece\u011finizi payla\u015faca\u011f\u0131z.<\/span><\/p>\n

Excel tablomuzda 12 farkl\u0131 ki\u015fiye ait isim ve ya\u015f verisi bulunmakta. Bu verileri sql veri taban\u0131 hesab\u0131m\u0131za aktaraca\u011f\u0131z.<\/span><\/p>\n

Art\u0131k i\u015flem ad\u0131mlar\u0131na ba\u015flayabiliriz.<\/span><\/p>\n

1 \u2013 Veri aktar\u0131m\u0131n\u0131 tamamlayabilmek i\u00e7in SQL server<\/strong> import \/ export arac\u0131n\u0131 kullan\u0131yoruz. A\u015fa\u011f\u0131da payla\u015ft\u0131\u011f\u0131m g\u00f6rselde g\u00f6rebilece\u011finiz gibi veri taban\u0131\u00a0hesab\u0131m\u0131za sa\u011f tu\u015f t\u0131kl\u0131yoruz ve task b\u00f6l\u00fcm\u00fcnden import data butonuna t\u0131kl\u0131yoruz.<\/span><\/p>\n

\"1\"<\/a><\/span><\/p>\n

2 \u2013 Butona t\u0131klamam\u0131z ile beraber bizi SQL Server import and Export Wizard ekran\u0131 kar\u015f\u0131layacak. Next butonuna t\u0131klayarak i\u015flem ad\u0131mlar\u0131m\u0131za devam ediyoruz.\u00a0Bir sonraki ad\u0131mda \u201cchoose a Data Source<\/strong>\u201d ekran\u0131na ula\u015faca\u011f\u0131z. Bu ekranda aktar\u0131m\u0131n\u0131 ger\u00e7ekle\u015ftirece\u011fimiz verinin data kayd\u0131\u011f\u0131n\u0131 se\u00e7iyoruz.<\/span><\/p>\n

A\u015fa\u011f\u0131daki g\u00f6rselde g\u00f6rebilece\u011finiz gibi data source b\u00f6l\u00fcm\u00fcnden \u201d Microsoft Excel<\/strong> \u201d se\u00e7imi ger\u00e7ekle\u015ftirildi ve \u201cexcel file path:<\/strong> \u201d b\u00f6l\u00fcm\u00fcnden \u00e7a\u011fr\u0131ca\u011f\u0131m\u0131z\u00a0dosyan\u0131n local path yolu belirlendi.<\/span><\/p>\n

First row has colums names<\/strong>: Se\u00e7imini ger\u00e7ekle\u015ftirirsek excel taraf\u0131ndaki 1. sat\u0131rlar\u0131m\u0131z\u0131 ba\u015fl\u0131k olarak atayabiliriz. E\u011fer bu tiki i\u015faretlemezsek her kolon\u00a0i\u00e7in F1,F2,F3 \u015feklinde atama ger\u00e7ekle\u015ftirilecektir.<\/span><\/p>\n

Se\u00e7imleri tamamlad\u0131ktan sonra next botuna basarak i\u015flem ad\u0131mlar\u0131na devam ediyoruz.<\/span><\/p>\n

\"2\"<\/a><\/span><\/p>\n

3 \u2013 Choose a Destination ekran\u0131na ula\u015ft\u0131k. Bu ekranda datalar\u0131n aktar\u0131laca\u011f\u0131 veritaban\u0131 hesab\u0131n\u0131 se\u00e7iyoruz ve ba\u011flant\u0131 bilgilerine ili\u015fkin atamalar\u0131\u00a0tamaml\u0131yoruz. Bir sonraki i\u015fleme ge\u00e7meden \u00f6nce Authentication b\u00f6l\u00fcm\u00fcnden \u201cUse SQL Server Authentication<\/strong>\u201d se\u00e7imini ger\u00e7ekle\u015ftirerek veritaban\u0131 user\u00a0bilgilerini girmeyi unutmay\u0131n\u0131z.<\/span><\/p>\n

Next butonuna t\u0131klayarak i\u015flem ad\u0131mlar\u0131na devam ediyoruz.
\n\"3\"<\/a><\/span><\/p>\n

4 \u2013 Bir sonraki ad\u0131mda sorgulama y\u00f6netimi kullanarak data aktar\u0131m\u0131n\u0131 sa\u011flayabiliriz. Fakat biz a\u015fa\u011f\u0131daki g\u00f6rselde g\u00f6rebilece\u011finiz gibi birden fazla veriyi\u00a0kopyalama se\u00e7ene\u011fini i\u015faretleyerek i\u015flem ad\u0131mlar\u0131m\u0131za devam ediyoruz.<\/span><\/p>\n

\"4\"<\/a><\/span><\/p>\n

5 \u2013 Art\u0131k \u201cSelect Source Tables and Wiews<\/strong>\u201d b\u00f6l\u00fcm\u00fcne ula\u015ft\u0131k. \u0130lgili b\u00f6l\u00fcmde diledi\u011finiz sayfa ve tablo atamas\u0131 i\u015flemi ger\u00e7ekle\u015ftirebilirsiniz. \u00d6rnek bir i\u015flem\u00a0olmas\u0131 nedeniyle her hangi bir atama yapmadan next diyerek devam ediyoruz.<\/span><\/p>\n

6 \u2013 Bir sonraki ad\u0131mda bizi \u201cRun immediately<\/strong>\u201d kutucu\u011fu kar\u015f\u0131layacak her hangi bir atama yapman\u0131za gerek bulunmuyor. Next <\/strong>veya da finish <\/strong>butonlar\u0131na t\u0131klayarak\u00a0i\u015flem ad\u0131mlar\u0131n\u0131 tamamlayabilirsiniz. \u0130\u015flem ad\u0131mlar\u0131 tamamland\u0131\u011f\u0131nda ekran \u00e7\u0131kt\u0131s\u0131 a\u015fa\u011f\u0131daki gibi olmal\u0131d\u0131r.<\/p>\n

\"5\"<\/a><\/span><\/p>\n

7 \u2013 \u0130\u015flemlerimizi ba\u015far\u0131l\u0131 bir \u015fekilde tamamlad\u0131k. Verilerimnizin sa\u011fl\u0131kl\u0131 bir \u015fekilde aktar\u0131l\u0131p aktar\u0131lmad\u0131\u011f\u0131n\u0131 eklemi\u015f oldu\u011fumuz tabloya sa\u011f tu\u015f \u201cSelect\u00a0top 1000 rows<\/strong>\u201d se\u00e7ene\u011fini t\u0131klayarak g\u00f6rebiliriz.<\/span><\/p>\n

A\u015fa\u011f\u0131daki g\u00f6rselde de g\u00f6rebilece\u011finiz gibi 12 ki\u015finin ismi ve ya\u015f bilgisi exel tablolar\u0131ndan \u00e7ekilerek MsSQL database hesab\u0131m\u0131z\u0131n i\u00e7erisine aktar\u0131ld\u0131.<\/span><\/p>\n

\"6\"<\/a><\/span><\/p>\n

Faydal\u0131 olmas\u0131 dile\u011fiyle.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"Sizlerden gelen yo\u011fun istek \u00fczerine bu yaz\u0131m\u0131zda Excel yap\u0131s\u0131nda bulunan verilerimizi nas\u0131l MsSQL veritaban\u0131 hesab\u0131m\u0131za aktaraca\u011f\u0131m\u0131za anlataca\u011f\u0131z. Sizlerin…\n","protected":false},"author":7,"featured_media":10210,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,28,36],"tags":[],"class_list":{"0":"post-12277","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-genel","8":"category-nasil-yapilir","9":"category-sunucu"},"_links":{"self":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/12277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/comments?post=12277"}],"version-history":[{"count":0,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/12277\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media\/10210"}],"wp:attachment":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media?parent=12277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/categories?post=12277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/tags?post=12277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}