{"id":1270,"date":"2012-03-23T10:51:07","date_gmt":"2012-03-23T10:51:07","guid":{"rendered":"http:\/\/galhano.com\/blog\/?p=1270"},"modified":"2012-03-23T11:00:05","modified_gmt":"2012-03-23T11:00:05","slug":"sql-server-dumper","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1270","title":{"rendered":"SQL Server Dumper"},"content":{"rendered":"<p><a href=\"http:\/\/www.ruizata.com\/images\/sql_dumper.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"http:\/\/www.ruizata.com\/images\/sql_dumper.png\" alt=\"\" width=\"176\" height=\"34\" \/><\/a>SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file.<\/p>\n<p>This program implements the following special features:<\/p>\n<ul>\n<li><strong>Foreign Keys<\/strong><img decoding=\"async\" src=\"http:\/\/www.ruizata.com\/images\/arrow_right.gif\" alt=\"&gt;\" \/> order tables in text file in order to insert data without colisions\/errors<\/li>\n<li><strong>Primary Key IDENTITY<\/strong><img decoding=\"async\" src=\"http:\/\/www.ruizata.com\/images\/arrow_right.gif\" alt=\"&gt;\" \/> guarantees the value of the IDENTITY field<\/li>\n<li><strong>Reference to itself<\/strong><img decoding=\"async\" src=\"http:\/\/www.ruizata.com\/images\/arrow_right.gif\" alt=\"&gt;\" \/> eliminates the constraint and at the end create it again<\/li>\n<\/ul>\n<p>http:\/\/sqldumper.ruizata.com\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,104],"tags":[173,121],"class_list":["post-1270","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-transact-sql","tag-sql-server","tag-t-sql","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1270"}],"version-history":[{"count":2,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1270\/revisions"}],"predecessor-version":[{"id":1274,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1270\/revisions\/1274"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1270"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}