{"id":32615,"date":"2022-01-05T11:10:49","date_gmt":"2022-01-05T08:10:49","guid":{"rendered":"https:\/\/www.natro.com\/blog\/?p=32615"},"modified":"2022-01-05T11:11:25","modified_gmt":"2022-01-05T08:11:25","slug":"mssql-database-generate-script-islemi-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/www.natro.com\/blog\/mssql-database-generate-script-islemi-nasil-yapilir\/","title":{"rendered":"MsSQL Database Generate Script \u0130\u015flemi Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"\n<p>Bu yaz\u0131mda size\u00a0<strong>MsSQL<\/strong>\u00a0<strong>Database Generate Script<\/strong>\u00a0\u00f6zelli\u011finden bahsetmek istiyoruz. Sizlerinde bildi\u011fi \u00fczere\u00a0<strong>Natro<\/strong>\u00a0payla\u015f\u0131ml\u0131 sunucular\u0131 i\u00e7erinde bulunan\u00a0<strong>MsSQL\u00a0<\/strong>veritaban\u0131 hesaplar\u0131n\u0131za elinizde bulunan .bak dosyalar\u0131n\u0131 direkt restore edemiyorsunuz. Bu i\u015flemi ger\u00e7ekle\u015ftirebilmeniz i\u00e7in\u00a0<strong>MsSQL<\/strong>\u00a0veritaban\u0131 hesab\u0131n\u0131z\u0131n script yede\u011fini \u00e7\u0131kartman\u0131z gerekir. Bu i\u015flemi ger\u00e7ekle\u015ftirebilmek i\u00e7in a\u015fa\u011f\u0131da iletmi\u015f oldu\u011fum ad\u0131mlar\u0131 takip ederek<strong>MsSQL<\/strong>\u00a0veritaban\u0131 hesab\u0131n\u0131za ait i\u00e7eri\u011fi \u201c<strong>generate script\u201d<\/strong>\u00a0i\u015flemine tabi tutabilirsiniz.<\/p>\n\n\n\n<p>\u0130\u015flem ad\u0131mlar\u0131 hakk\u0131nda detay vermeden \u00f6nce \u00e7o\u011fu\u00a0<strong>MsSQL<\/strong>\u00a0kullan\u0131c\u0131s\u0131n\u0131n kar\u015f\u0131la\u015ft\u0131\u011f\u0131 bir sorun hakk\u0131nda bilgi vermek isterim.<strong>\u00a0MsSQL<\/strong>\u00a0<strong>Server 2008<\/strong>\u00a0\u00fczerinden ald\u0131\u011f\u0131m\u0131z bir yede\u011fi 2005 veya da alt\u0131 versiyonlara restore edemiyorduk. Fakat generate script \u00f6zelli\u011fini kullanarak i\u015flem ad\u0131mlar\u0131nda se\u00e7ebilece\u011fimiz versiyon tipine g\u00f6re generate script i\u015flemini tamamlayabilir ve istedi\u011fimiz versiyona Mssql veritaban\u0131 i\u00e7eri\u011fimizi aktarabiliriz.<\/p>\n\n\n\n<p>1- \u00d6ncelikle\u00a0<strong>SQL Server Management Studio<\/strong>\u00a0program\u0131 arac\u0131l\u0131\u011f\u0131 ile sql server authentication methodunu kullanarak database hesab\u0131m\u0131za ula\u015fmam\u0131z gerekir.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/1.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/1.png\" alt=\"mssql server\" class=\"wp-image-6938\"\/><\/a><\/figure><\/div>\n\n\n\n<p>2- SQL server authentication methodunu kullanarak ba\u011flant\u0131m\u0131z\u0131 sa\u011flad\u0131k.\u00a0<strong>Databases<\/strong>\u00a0b\u00f6l\u00fcm\u00fc alt\u0131ndan veritaban\u0131 hesab\u0131m\u0131z\u0131 bulmam\u0131z gerekiyor. Hesaba ula\u015ft\u0131ktan sonra veritaban\u0131 hesab\u0131m\u0131za sa\u011f tu\u015f\u00a0<strong>tasks \/ generate scripts<\/strong>\u00a0butonuna t\u0131kl\u0131yoruz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/2.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/2.png\" alt=\"mssql-ayarlar\u0131\" class=\"wp-image-6940\"\/><\/a><\/figure><\/div>\n\n\n\n<p>3-\u00a0<strong>Generate script<\/strong>\u00a0butonuna basmam\u0131z ile beraber bizi kar\u015f\u0131layacak olan\u00a0<strong>introduction<\/strong>\u00a0b\u00f6l\u00fcm\u00fcn\u00fc\u00a0<strong>next<\/strong>\u00a0diyerek ge\u00e7iyoruz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/3.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/3.png\" alt=\"mssql-yap\u0131land\u0131rma\" class=\"wp-image-6943\"\/><\/a><\/figure><\/div>\n\n\n\n<p>4-\u00a0<strong>\u0130ntroduction<\/strong>\u00a0b\u00f6l\u00fcm\u00fc ge\u00e7ti\u011fimizde\u00a0<strong>choose objects<\/strong>\u00a0b\u00f6l\u00fcm\u00fcne ula\u015faca\u011f\u0131z. Bu b\u00f6l\u00fcmde hangi objelerin scripte d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesini istiyorsak se\u00e7imini ger\u00e7ekle\u015ftirebiliriz. A\u015fa\u011f\u0131da iletmi\u015f oldu\u011fum detaylara g\u00f6re se\u00e7iminizi ger\u00e7ekle\u015ftirerek\u00a0<strong>next<\/strong>\u00a0butonu ile devam ediyoruz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/4.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/4.png\" alt=\"mssql-objects-ayarlar\u0131\" class=\"wp-image-6945\"\/><\/a><\/figure><\/div>\n\n\n\n<p>\u2013\u00a0<strong>Script entire database and database objects<\/strong>: Veritaban\u0131na ait i\u00e7erik ve t\u00fcm objelerin yede\u011fini \u00e7\u0131kartacakt\u0131r.<br>\u2013\u00a0<strong>Select spesific database object<\/strong>: Database i\u00e7eri\u011finde bulunan tablo, prosed\u00fcr ve user i\u00e7eriklerini iste\u011fe ba\u011fl\u0131 se\u00e7imler yaparak yede\u011fini \u00e7\u0131karacakt\u0131r.<\/p>\n\n\n\n<p>5-\u00a0<strong>Set Scripts Options<\/strong>, ula\u015ft\u0131\u011f\u0131m\u0131z ekranda script i\u00e7eri\u011finin nas\u0131l kaydedilebilece\u011fini se\u00e7ebilir ve iste\u011fe ba\u011fl\u0131 olarak\u00a0<strong>web service<\/strong>\u00a0kullanarak\u00a0yay\u0131n\u0131n\u0131 ger\u00e7ekle\u015ftirebiliriz.<\/p>\n\n\n\n<p>\u2013<strong>Save to File<\/strong>: Script i\u00e7eri\u011fini t-sql dosyas\u0131na export etmemiz i\u00e7in yard\u0131mc\u0131 olmaktad\u0131r. Single file poer object se\u00e7ene\u011fi ile generate i\u015flemini tamamlarsan\u0131z her bir nesneyi ayr\u0131 dosyalar halinde export etmi\u015f olacakt\u0131r.<\/p>\n\n\n\n<p>\u2013<strong>Save to Clipboard<\/strong>: \u0130\u00e7eri\u011fi herhangi bir yere kopyal\u0131yarak kullan\u0131m\u0131na ba\u015flayabiliriz. \u00d6rnek vermek gerekirse ctrl + c kombinasyonunu kullanarak herhangi bir i\u00e7eri\u011fi kopyalam\u0131\u015f gibi olaca\u011f\u0131z.<\/p>\n\n\n\n<p>\u2013<strong>Save to New Query Windows<\/strong>\u00a0: Script i\u00e7eri\u011fini yeni bir query ekran\u0131na yazd\u0131rm\u0131\u015f olacakt\u0131r.<\/p>\n\n\n\n<p>\u2013<strong>File Name<\/strong>\u00a0: Bu b\u00f6l\u00fcmde script dosyam\u0131z\u0131 bilgisayar\u0131m\u0131zda nereye kaydetmek istedi\u011fimizi se\u00e7ebiliriz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/5.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/5.png\" alt=\"mssql-scripting-ayarlar\u0131\" class=\"wp-image-6946\"\/><\/a><\/figure><\/div>\n\n\n\n<p>6- \u0130\u015flem ad\u0131mlar\u0131m\u0131z\u0131n en \u00f6nemli noktas\u0131na ula\u015ft\u0131k.\u00a0<strong>Set Script Options<\/strong>\u00a0ekran\u0131nda\u00a0<strong>Advanced<\/strong>\u00a0b\u00f6l\u00fcm\u00fcnde bulunan parametreler\u00a0<strong>generate script<\/strong>\u00a0i\u015flemi i\u00e7in \u00f6nem arz etmektedir. Se\u00e7enekler i\u00e7erisinde yer alan ve en \u00f6nemli yeri tutan \u00f6zellikleri a\u015fa\u011f\u0131da bilginize sunuyorum.<\/p>\n\n\n\n<p><strong>-Script Logins<\/strong>: Se\u00e7ene\u011fi true konumuna getirirsek database i\u00e7eri\u011fi ile user kay\u0131tlar\u0131n\u0131 da script i\u00e7eri\u011fine alm\u0131\u015f olaca\u011f\u0131z.<\/p>\n\n\n\n<p><strong>-Type of data to script<\/strong>\u00a0: Bir \u00e7ok sql kullan\u0131c\u0131s\u0131 bu se\u00e7ene\u011fi es ge\u00e7ti\u011finden dolay\u0131 tablo verilerinin yede\u011fini script i\u00e7eri\u011fine d\u00f6kememi\u015f oluyor. \u0130lgili b\u00f6l\u00fcmde schema only se\u00e7ene\u011fi ile sadece sql veritaban\u0131 hesab\u0131m\u0131z\u0131n scheme i\u00e7eri\u011fini scripte d\u00f6km\u00fc\u015f olaca\u011f\u0131z. Yaz\u0131mda ben schema and data secene\u011fi ile her ikisinin i\u00e7eri\u011fini scripte d\u00f6km\u00fc\u015f olaca\u011f\u0131m.<\/p>\n\n\n\n<p><strong>-Script For Version<\/strong>\u00a0: Bu se\u00e7enek ile hangi versiyona script haz\u0131rl\u0131yorsak onu se\u00e7ebiliriz. Ben Sql Server 2008 se\u00e7ene\u011fi ile generate script i\u015flemimi tamamlad\u0131m.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/6.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/6.png\" alt=\"mssql-advanced-ayarlar\u0131\" class=\"wp-image-6947\"\/><\/a><\/figure><\/div>\n\n\n\n<p>7-\u00a0<strong>Advanced settings<\/strong>\u00a0yap\u0131land\u0131rmam\u0131z\u0131 tamamlad\u0131\u011f\u0131m\u0131za g\u00f6re next butonunu kullanarak\u00a0<strong>generate script<\/strong>\u00a0i\u015flem ad\u0131mlar\u0131m\u0131za devam edebiliriz. Bir sonraki ad\u0131mda bizi\u00a0<strong>Summary<\/strong>\u00a0ekran\u0131 kar\u015f\u0131layacakt\u0131r. \u0130lgili b\u00f6l\u00fcmde i\u015flem ad\u0131mlar\u0131nda ger\u00e7ekle\u015ftirdi\u011fimiz se\u00e7imlerin \u00f6zeti sunulmaktad\u0131r.\u00a0<strong>Next<\/strong>\u00a0butonuna basarak\u00a0<strong>generate script<\/strong>\u00a0i\u015flemimize devam ediyoruz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/7.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/7.png\" alt=\"mssql-summary-ayarlar\u0131\" class=\"wp-image-6948\"\/><\/a><\/figure><\/div>\n\n\n\n<p>8- \u0130\u015flemlerimizin art\u0131k son a\u015famas\u0131na ula\u015ft\u0131k\u00a0<strong>Save or Publish Scripts<\/strong>\u00a0ekran\u0131nda i\u015flem s\u0131ras\u0131nda al\u0131nan aksiyonlar\u0131 ve hatalar\u0131 g\u00f6rebiliriz. Yapm\u0131\u015f oldu\u011fumuz i\u015flem ba\u015far\u0131l\u0131 bir \u015fekilde tamamland\u0131\u011f\u0131ndan dolay\u0131 result b\u00f6l\u00fcm\u00fcnde\u00a0<strong>success<\/strong>\u00a0bilgisine ula\u015fabilirsiniz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/8.png\"><img decoding=\"async\" src=\"https:\/\/www.natro.com\/blog\/wp-content\/uploads\/2015\/03\/8.png\" alt=\"mssql-yap\u0131land\u0131rma-ayarlar\u0131\" class=\"wp-image-6949\"\/><\/a><\/figure><\/div>\n\n\n\n<p>9-\u00a0<strong>Finish<\/strong>\u00a0butonuna basarak i\u015flemimizi tamamlayabiliriz. Art\u0131k belilemi\u015f oldu\u011funuz fiziksel yol \u00fczerinde\u00a0<strong>script<\/strong>\u00a0dosyan\u0131za ula\u015fabilirsiniz.<\/p>\n\n\n\n<p>Faydal\u0131 olmas\u0131 dile\u011fiyle.<\/p>\n","protected":false},"excerpt":{"rendered":"Bu yaz\u0131mda size\u00a0MsSQL\u00a0Database Generate Script\u00a0\u00f6zelli\u011finden bahsetmek istiyoruz. Sizlerinde bildi\u011fi \u00fczere\u00a0Natro\u00a0payla\u015f\u0131ml\u0131 sunucular\u0131 i\u00e7erinde bulunan\u00a0MsSQL\u00a0veritaban\u0131 hesaplar\u0131n\u0131za elinizde bulunan .bak dosyalar\u0131n\u0131&hellip;\n","protected":false},"author":7,"featured_media":31110,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":{"0":"post-32615","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-nasil-yapilir"},"_links":{"self":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/32615","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=32615"}],"version-history":[{"count":2,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/32615\/revisions"}],"predecessor-version":[{"id":32617,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/32615\/revisions\/32617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media\/31110"}],"wp:attachment":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media?parent=32615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/categories?post=32615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/tags?post=32615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}