{"id":7209,"date":"2015-04-16T15:41:50","date_gmt":"2015-04-16T12:41:50","guid":{"rendered":"http:\/\/blog.natro.com\/?p=7209"},"modified":"2024-04-02T12:38:53","modified_gmt":"2024-04-02T09:38:53","slug":"mssql-script-import-islemi-adim-2","status":"publish","type":"post","link":"https:\/\/www.natro.com\/blog\/mssql-script-import-islemi-adim-2\/","title":{"rendered":"MsSQL Script Import \u0130\u015flemi – Ad\u0131m 2"},"content":{"rendered":"

Biliyorsunuz ki Natro\u00a0MsSQL<\/strong> database hizmetinde direkt import i\u015flemine izin vermemektedir. Bu sebepten dolay\u0131 i\u00e7eri aktaraca\u011f\u0131m\u0131z datalar\u0131 \u00f6ncelikle script format\u0131na \u00e7evirmemiz gerekir. Bir \u00f6nceki MsSQL<\/strong> i\u00e7erikli yaz\u0131m\u0131zda, database i\u00e7eri\u011finin\u00a0generate script<\/strong><\/p>\n

i\u015flemine nas\u0131l tabi tutaca\u011f\u0131m\u0131z\u0131 anlatm\u0131\u015ft\u0131k.<\/p>\n

\u201d\u00a0MsSQL Generate Script i\u015flem ad\u0131mlar\u0131 i\u00e7in t\u0131klay\u0131n\u0131z.<\/a>\u00a0\u201d
\nBu yaz\u0131m\u0131zda ise ald\u0131\u011f\u0131m\u0131z script yedeklerini nas\u0131l i\u00e7eriye aktarabilece\u011fimizi anlataca\u011f\u0131m.<\/p>\n

MsSQL Script \u0130mport<\/strong><\/h2>\n
    \n
  1. \u00d6ncelikle ald\u0131\u011f\u0131m\u0131z script yedek dosyas\u0131n\u0131 not defteri vb. programlar ile a\u00e7\u0131yoruz. Script i\u00e7eri\u011fimiz haz\u0131rda bekleyebilir.<\/li>\n
  2. Microsoft SQL Server Management Studio program\u0131 yard\u0131m\u0131yla MsSQL hesab\u0131m\u0131za eri\u015fimi ger\u00e7ekle\u015ftiriyoruz.<\/li>\n
  3. Ba\u011flant\u0131m\u0131z\u0131 ger\u00e7ekle\u015ftirdik. \u015eimdi a\u00e7\u0131lan listede database hesab\u0131m\u0131z\u0131 buluyoruz ve sa\u011f tu\u015f \u201cNew Query\u201d<\/strong>butonuna t\u0131kl\u0131yoruz.<\/li>\n<\/ol>\n

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

    4.\u00a0 Haz\u0131rda bekletmi\u015f oldu\u011fumuz script i\u00e7eri\u011fini Notepad vb. a\u00e7arak i\u00e7eri\u011fini kopyalay\u0131p \u201cNew Query<\/strong>\u201d alan\u0131na yap\u0131\u015ft\u0131r\u0131yoruz.<\/p>\n

    5.\u00a0 \u201cCreate Table<\/strong>\u201cdan \u00f6nceki t\u00fcm verileri siliyoruz. Yani sayfam\u0131z\u0131n ba\u015flang\u0131c\u0131 \u201cCreate Table<\/strong>\u201d olacakt\u0131r.\u00a0 \"\"<\/p>\n

    6.\u00a0 Son i\u015flem ad\u0131m\u0131 olarak \u201cExecute<\/strong>\u201d butonuna t\u0131kl\u0131yoruz ve restore i\u015flemini tamaml\u0131yoruz.<\/p>\n

    \"\"<\/p>\n

    7.\u00a0 A\u015fa\u011f\u0131daki uyar\u0131y\u0131 g\u00f6rd\u00fc\u011f\u00fcn\u00fczde Veritaban\u0131 script dosyan\u0131z\u0131n restore i\u015flemi tamamlanm\u0131\u015f demektedir.<\/p>\n

    \"\"<\/p>\n

    8.\u00a0 Art\u0131k ald\u0131\u011f\u0131m\u0131z script yede\u011fini MsSQL hesab\u0131m\u0131z\u0131n i\u00e7erisine aktard\u0131k. Aktar\u0131m sonras\u0131 dilerseniz MsSQL hesab\u0131 i\u00e7erisinde yer alan tablo ve data kay\u0131tlar\u0131n\u0131 kontrol edebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"Biliyorsunuz ki Natro\u00a0MsSQL database hizmetinde direkt import i\u015flemine izin vermemektedir. Bu sebepten dolay\u0131 i\u00e7eri aktaraca\u011f\u0131m\u0131z datalar\u0131 \u00f6ncelikle script…\n","protected":false},"author":7,"featured_media":28809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[179],"class_list":{"0":"post-7209","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sunucu","8":"tag-veritabani"},"_links":{"self":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/7209","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=7209"}],"version-history":[{"count":4,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/7209\/revisions"}],"predecessor-version":[{"id":34905,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/posts\/7209\/revisions\/34905"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media\/28809"}],"wp:attachment":[{"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/media?parent=7209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/categories?post=7209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.natro.com\/blog\/wp-json\/wp\/v2\/tags?post=7209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}