{"id":148,"date":"2011-02-16T14:35:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=148"},"modified":"2011-02-16T14:35:00","modified_gmt":"1970-01-01T00:00:00","slug":"sql-server-management-studio-kullanarak-veritabanina-ait-create-ve-insert-scriptler-nasil","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2011\/02\/16\/sql-server-management-studio-kullanarak-veritabanina-ait-create-ve-insert-scriptler-nasil\/","title":{"rendered":"SQL Server Management Studio kullanarak veritabanina ait create ve insert scriptler nasil olusturulur"},"content":{"rendered":"<p>Bazi zamanlar veritabanimizda bulunan tablo,view vb gibi nesnelere ait create scriptlere ve tablo i&ccedil;inde bulunan veriler i&ccedil;inde insert scriptlere ihtiyacimiz olur. Bu islemi yapmak i&ccedil;in gelistirilmis 3rd parti bir&ccedil;ok ara&ccedil; vardir, fakat Sql Server Management Studio i&ccedil;inde gelen &ldquo;Generate Script&rdquo; araci isimizi g&ouml;recektir. Bu makalemizde bu araci nasil kullanacagimizi &ouml;grenecegiz.<\/p>\n<p class=\"MsoNormal\">&Ouml;rnek i&ccedil;in AdventureWorks veritabanini kullanacagiz. Ilk olarak veritabanini sag tiklayarak Task menusun altinda bulunan &ldquo;Generate Script&rdquo; se&ccedil;enegini tikliyoruz.<\/p>\n<p class=\"MsoNormal\"><a href='www.yazilimmutfagi.com'>.<\/a><\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shapetype\nid=\"_x0000_t75\" coordsize=\"21600,21600\" o:spt=\"75\" o:preferrelative=\"t\"\npath=\"m@4@5l@4@11@9@11@9@5xe\" filled=\"f\" stroked=\"f\">\n<v:stroke joinstyle=\"miter\" \/>\n<v:formulas>\n<v:f eqn=\"if lineDrawn pixelLineWidth 0\" \/>\n<v:f eqn=\"sum @0 1 0\" \/>\n<v:f eqn=\"sum 0 0 @1\" \/>\n<v:f eqn=\"prod @2 1 2\" \/>\n<v:f eqn=\"prod @3 21600 pixelWidth\" \/>\n<v:f eqn=\"prod @3 21600 pixelHeight\" \/>\n<v:f eqn=\"sum @0 0 1\" \/>\n<v:f eqn=\"prod @6 1 2\" \/>\n<v:f eqn=\"prod @7 21600 pixelWidth\" \/>\n<v:f eqn=\"sum @8 21600 0\" \/>\n<v:f eqn=\"prod @7 21600 pixelHeight\" \/>\n<v:f eqn=\"sum @10 21600 0\" \/>\n<\/v:formulas>\n<v:path o:extrusionok=\"f\" gradientshapeok=\"t\" o:connecttype=\"rect\" \/>\n<o:lock v:ext=\"edit\" aspectratio=\"t\" \/>\n<\/v:shapetype><v:shape id=\"Picture_x0020_1\" o:spid=\"_x0000_i1032\" type=\"#_x0000_t75\"\nstyle='width:265.5pt;height:337.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image001.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"354\" height=\"450\" v:shapes=\"Picture_x0020_1\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_1.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\"><o:p>&nbsp;<\/o:p><\/p>\n<p class=\"MsoNormal\">&Ouml;n&uuml;m&uuml;ze gelen ekranda next dedikten sonra hangi veritabanina ait script olusturacagimiz soruluyor burada zaten se&ccedil;ili olan &ldquo;AdventureWorks&rdquo; veritabanini se&ccedil;ili birakip next diyoruz.<\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_2\" o:spid=\"_x0000_i1031\" type=\"#_x0000_t75\" style='width:285pt;\nheight:256.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image003.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"380\" height=\"342\" v:shapes=\"Picture_x0020_2\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_2.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Bu asamadan sonra olusturacagimiz script ile ilgili detayli bilgileri se&ccedil;ebilecegimiz asagidaki ekran geliyor.<\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_3\" o:spid=\"_x0000_i1030\" type=\"#_x0000_t75\" style='width:337.5pt;\nheight:553.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image005.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"450\" height=\"738\" v:shapes=\"Picture_x0020_3\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_3.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Yukaridaki ekranda bizim i&ccedil;in &ouml;nemli olan &ldquo;script create&rdquo; ve &ldquo;script data&rdquo; se&ccedil;enekleridir. Script Create ile sonraki ekranlarda se&ccedil;ecegimiz nesnelere ait create scriptleri olustur demil oluyoruz. Script data ile ise se&ccedil;ecegimiz tablolarda bulunan veriler i&ccedil;in insert scriptlerini olustur diyoruz. Sizde ihtiyaciniza g&ouml;re bu ekrandaki degerleri true veya false yaparak istediginiz scriptleri olusturabilirsiniz. Ekrandaki gibi 2 se&ccedil;enege ait degerleri True yapalim ve digerlerini degistirmeyelim daha sonra next diyip devam edelim.<br \/>\n<a href='www.yazilimmutfagi.com'>.<\/a><\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_8\" o:spid=\"_x0000_i1029\" type=\"#_x0000_t75\" style='width:337.5pt;\nheight:304.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image007.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"450\" height=\"406\" v:shapes=\"Picture_x0020_8\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_4.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Sonraki asamada yukaridaki ekranda g&ouml;rd&uuml;g&uuml;n&uuml;z gibi hangi tip nesneler i&ccedil;in script olusturacagimizi se&ccedil;ityoruz. Biz &ouml;rnegimizde schema ve table se&ccedil;eneklerini isaretliyoruz. Isterseniz se&ccedil;eneklerde g&ouml;rd&uuml;g&uuml;n&uuml;z gibi triggerlardan procedurelara kadar t&uuml;m nesneleri se&ccedil;ebilirsiniz. <span style=\"mso-spacerun:yes\">&nbsp;<\/span>Next diyip devam ediyoruz. Gelen ekranda ise person semasi altindaki Contact tablosunu se&ccedil;iyoruz.<\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_5\" o:spid=\"_x0000_i1028\" type=\"#_x0000_t75\" style='width:337.5pt;\nheight:304.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image009.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"450\" height=\"406\" v:shapes=\"Picture_x0020_5\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_5.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_6\" o:spid=\"_x0000_i1027\" type=\"#_x0000_t75\" style='width:337.5pt;\nheight:304.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image011.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"450\" height=\"406\" v:shapes=\"Picture_x0020_6\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_6.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Next dedikten sorna asagidaki ekran gelir. Bu ekranda olusturulacak scripti bir dosyayami yazmak istedigimiz yoksa yeni bir sorgu penceresindemi g&ouml;r&uuml;nt&uuml;leyecegimiz gibi sorular sorulur.<\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_9\" o:spid=\"_x0000_i1026\" type=\"#_x0000_t75\" style='width:337.5pt;\nheight:304.5pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image013.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"450\" height=\"406\" v:shapes=\"Picture_x0020_9\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_7.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Eger insert scriptleri de olusturuyorsaniz ve tablonuzdaki kayit sayisi &ccedil;ok fazla ise bu ekranda script to file se&ccedil;enegini se&ccedil;menizi tavsiye ederim. Bizim tek bir k&uuml;&ccedil;&uuml;k tablo i&ccedil;in islem yapacagimiz i&ccedil;in yeni bir sorgu ekraninda scriptleri g&ouml;relim. Finish dedik ve islemin tamamlanmasini bekledik.<br \/>\n<a href='www.yazilimmutfagi.com'>.<\/a><\/p>\n<p class=\"MsoNormal\"><span style=\"mso-fareast-language:TR;mso-no-proof:yes\"><!--[if gte vml 1]><v:shape\nid=\"Picture_x0020_10\" o:spid=\"_x0000_i1025\" type=\"#_x0000_t75\" style='width:323.25pt;\nheight:291pt;visibility:visible;mso-wrap-style:square'>\n<v:imagedata src=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_image015.png\"\no:title=\"\" \/>\n<\/v:shape><![endif]--><!--[if !vml]--><img decoding=\"async\" loading=\"lazy\" width=\"431\" height=\"388\" v:shapes=\"Picture_x0020_10\" alt=\"\" src=\"http:\/\/www.yazilimmutfagi.com\/yuklenendosyalar\/image\/sabri\/createscript\/SqlGenerateScript_8.png\" \/><!--[endif]--><\/span><\/p>\n<p class=\"MsoNormal\">Islem tamamlandigi zaman sql serverda yeni bir sorgu ekrani a&ccedil;ililcak ve t&uuml;m scriptlerimi oraya yazilacak. SQL serverda &ccedil;alisanlar i&ccedil;in olduk&ccedil;a faydali bir ara&ccedil;. Umarim sizinde isinize yarar.<br \/>\n<a href='www.yazilimmutfagi.com'>.<\/a><\/p>\n<p class=\"MsoNormal\"><o:p>&nbsp;<\/o:p><\/p>","protected":false},"excerpt":{"rendered":"<p>Bazi zamanlar veritabanimizda bulunan tablo,view vb gibi nesnelere ait create scriptlere ve tablo i&#231;inde bulunan veriler i&#231;inde insert scriptlere ihtiyacimiz olur. Bu islemi yapmak i&#231;in gelistirilmis 3rd parti bir&#231;ok ara&#231; vardir, fakat Sql Server Management Studio i&#231;inde gelen \u201cGenerate Script\u201d araci isimizi g&#246;recektir. Bu makalemizde bu araci nasil kullanacagimizi &#246;grenecegiz.<\/p>\n","protected":false},"author":517,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[4337,6094,5087,6044,5749,5677,5182,4438],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/148"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/148\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}