{"id":1303,"date":"2020-02-20T12:53:30","date_gmt":"2020-02-20T12:53:30","guid":{"rendered":"http:\/\/blog.inetmar.com\/?p=1303"},"modified":"2024-07-29T14:56:54","modified_gmt":"2024-07-29T11:56:54","slug":"mssql-script-ile-veritabani-yedegi-almak","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mssql-script-ile-veritabani-yedegi-almak\/","title":{"rendered":"MSSQL Script ile Veritaban\u0131 Yede\u011fi Almak"},"content":{"rendered":"

Merhaba,<\/p>\n

Bu makalemizde sizlere Sql Server Management Studio ile veritaban\u0131n\u0131z\u0131n yede\u011fini nas\u0131l alabilece\u011finize de\u011finece\u011fiz. \u00d6ncelikle Sql Server Management Studio program\u0131m\u0131z\u0131 a\u00e7\u0131p veritaban\u0131m\u0131za ba\u011flan\u0131yoruz. Daha sonra a\u015fa\u011f\u0131daki resimde g\u00f6rece\u011finiz gibi yede\u011fini almak istedi\u011fimiz veritaban\u0131na sa\u011f t\u0131klay\u0131p , \u201cTasks\u201d men\u00fcs\u00fc alt\u0131nda \u201cGenerate Scripts\u201d alan\u0131na t\u0131klayoruz.<\/p>\n

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

Veritaban\u0131m\u0131z\u0131 se\u00e7tikten sonra bir sonraki i\u015fleme ge\u00e7iyoruz kar\u015f\u0131m\u0131za a\u015fa\u011f\u0131da g\u00f6rd\u00fc\u011f\u00fcm\u00fcz Choose Script Options ekran\u0131 \u00e7\u0131kacakt\u0131r. Burada scriptin i\u00e7eri\u011fini esnek bir bi\u00e7imde belirleyebilirsiniz. \u00d6nemli di\u011fer nokta ise e\u011fer veritaban\u0131n\u0131zda datalar var ise ve bu datalar\u0131 script ile beraber ta\u015f\u0131mak isterseniz Script Data \u00f6zelli\u011fini true yapman\u0131z gerekti\u011fidir.<\/p>\n

Bu b\u00f6l\u00fcm\u00fc ge\u00e7tikten sonra kar\u015f\u0131m\u0131za gelen ekran tablolar\u0131m\u0131z, view ve store procedurelerimizi i\u00e7erin bir se\u00e7enek sunmakta. Neyi ta\u015f\u0131mak istiyorsak onlar\u0131 se\u00e7ip yolumuza devam ediyoruz. Ben hepsini se\u00e7iyorum.<\/p>\n

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

 <\/p>\n

Kar\u015f\u0131m\u0131za output options se\u00e7ene\u011fi \u00e7\u0131kmakta burada scriptimizi nereye ve hangi formatta kaydedice\u011fimizi se\u00e7memiz gerek. Dilersek bilgisayar\u0131m\u0131zda herhangi bir yere kaydedebilir veya direk sql \u00fczerinde \u00e7al\u0131\u015ft\u0131rabiliriz. Direk scripti g\u00f6rmek i\u00e7in sql \u00fczerinden \u00e7al\u0131\u015ft\u0131raca\u011f\u0131z. Finish se\u00e7ene\u011fi ile i\u015flemi sonland\u0131r\u0131yoruz.<\/p>\n

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

 <\/p>\n

\u0130\u015flemin hangi tablolarda ba\u015far\u0131l\u0131 oldu\u011funa dair bir ekran gelecektir. Report se\u00e7ene\u011finden i\u015flem s\u0131ras\u0131nda olanlar\u0131 dilerseniz kaydedebilir veya mail atabilirsiniz. Close se\u00e7ene\u011fini t\u0131klayarak ekran\u0131 kapat\u0131yoruz<\/p>\n

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

 <\/p>\n

Bu iki ekran\u0131 s\u0131rayla ge\u00e7tikten sonra script ekran\u0131m\u0131za gelecektir. Kar\u015f\u0131m\u0131za gelen scripti diledi\u011fimiz yerde \u00e7al\u0131\u015ft\u0131rabiliriz. Tek yapmam\u0131z gereken o isimde bir database olu\u015fturmak ve o database \u00fczerinden i\u015flemi ger\u00e7ekle\u015ftirmek. Database isimlendirmesinde b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf uyumuna dikkat edilmeli isim birebir yaz\u0131lmal\u0131d\u0131r.<\/p>\n

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

 <\/p>\n

Bu makalemizinde sonuna geldik. Sizlere yararl\u0131 olaca\u011f\u0131n\u0131 umuyoruz.<\/p>\n

\u00dccretsiz y\u00f6netim hizmetleri ile VPS sat\u0131n alma<\/a> f\u0131rsatlar\u0131.<\/p>\n","protected":false},"excerpt":{"rendered":"

Merhaba, Bu makalemizde sizlere Sql Server Management Studio ile veritaban\u0131n\u0131z\u0131n yede\u011fini nas\u0131l alabilece\u011finize de\u011finece\u011fiz. \u00d6ncelikle Sql Server Management Studio program\u0131m\u0131z\u0131 a\u00e7\u0131p veritaban\u0131m\u0131za ba\u011flan\u0131yoruz. Daha sonra a\u015fa\u011f\u0131daki resimde g\u00f6rece\u011finiz gibi yede\u011fini almak istedi\u011fimiz veritaban\u0131na sa\u011f t\u0131klay\u0131p...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,46,48],"tags":[],"class_list":["post-1303","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-sunucu","category-win-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=1303"}],"version-history":[{"count":10,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1303\/revisions"}],"predecessor-version":[{"id":9731,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1303\/revisions\/9731"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=1303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=1303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=1303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}