{"id":1119,"date":"2012-11-09T11:39:07","date_gmt":"2012-11-09T09:39:07","guid":{"rendered":"http:\/\/hen.co.za\/blog\/?p=1119"},"modified":"2012-11-09T11:39:07","modified_gmt":"2012-11-09T09:39:07","slug":"sqlscripter","status":"publish","type":"post","link":"https:\/\/hen.co.za\/blog\/2012\/11\/sqlscripter\/","title":{"rendered":"SQLScripter"},"content":{"rendered":"<p>I&#8217;ve been wanting to creating something like this for myself for a while. A simple tool to quickly create a backup copy of a SQL Server database &#8216;structure&#8217; (or schema if you will). It is really a simple command line tool that simply takes a few parameters like server\\instance name, database, output directory and a prefix name for the output files.<\/p>\n<p>It creates separate files for Tables, Views and Stored procedures (which includes UDFs)<\/p>\n<p>Example usage:<\/p>\n<p style=\"padding-left: 30px;\">SQLScripter.exe\u00a0&lt;-s:server&gt;\u00a0&lt;-d:database&gt;\u00a0[-od:outputDirectory]\u00a0[-p:prefixFileName]<\/p>\n<p>Grab it <a title=\"SQLScripter.zip\" href=\"https:\/\/dl.dropbox.com\/u\/20983\/SQLScripter.zip\" target=\"_blank\">here <\/a>(plain exe in a zip file). It make use of the .Net 4.0 client framework.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been wanting to creating something like this for myself for a while. A simple tool to quickly create a backup copy of a SQL Server database &#8216;structure&#8217; (or schema if you will). It is really a simple command line &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/hen.co.za\/blog\/2012\/11\/sqlscripter\/\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[7,254,37,303,216,49,41],"class_list":["post-1119","post","type-post","status-publish","format-standard","hentry","category-development","category-projects","tag-net","tag-backup","tag-database","tag-development","tag-script","tag-sql","tag-tool"],"_links":{"self":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/comments?post=1119"}],"version-history":[{"count":2,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1119\/revisions"}],"predecessor-version":[{"id":1121,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/posts\/1119\/revisions\/1121"}],"wp:attachment":[{"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/media?parent=1119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/categories?post=1119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hen.co.za\/blog\/wp-json\/wp\/v2\/tags?post=1119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}