{"id":1327,"date":"2012-03-07T08:28:44","date_gmt":"2012-03-07T08:28:44","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=1327"},"modified":"2025-03-21T06:57:23","modified_gmt":"2025-03-21T06:57:23","slug":"sql-server-export-varcharmax-column-to-text","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/sqllobeditor\/sql-server-export-varcharmax-column-to-text.html","title":{"rendered":"SQL Server export varchar(max) column to text"},"content":{"rendered":"<p>First, you need <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download DBBlobEditor<\/a> <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DBBlobEditor\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&amp;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&amp;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&amp;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&amp;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DBBlobEditor&amp;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<p>Run <a href=\"\/dbblobeditor\/\">DBBlobEditor<\/a>, click the &#8220;Export LOB&#8221; button.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1328\" title=\"lobeditor_toolbar\" src=\"http:\/\/www.withdata.com\/wp\/wp-content\/uploads\/2012\/03\/lobeditor_toolbar.png\" alt=\"\" width=\"465\" height=\"38\" \/><\/p>\n<p>Choose the table name, varchar(max) column name (Lob Field), &#8220;Save To&#8221;, etc. <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1329\" title=\"export_mssql_text\" src=\"http:\/\/www.withdata.com\/wp\/wp-content\/uploads\/2012\/03\/export_mssql_text.png\" alt=\"\" width=\"439\" height=\"561\" \/><\/p>\n<p>Click &#8220;Export&#8221; button.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1330\" title=\"do_export_mssql_text\" src=\"http:\/\/www.withdata.com\/wp\/wp-content\/uploads\/2012\/03\/do_export_mssql_text.png\" alt=\"\" width=\"439\" height=\"561\" \/><\/p>\n<p>Done!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, you need Download DBBlobEditor Windows 64 bit Windows 32 bit Linux .deb (For Debian, Ubuntu) 64 bit Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit MacOS 64 bit Run DBBlobEditor, click the &#8220;Export LOB&#8221; button. Choose the table name, varchar(max) column name (Lob Field), &#8220;Save To&#8221;, etc. Click &#8220;Export&#8221; button. Done!<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109],"tags":[176,175],"class_list":["post-1327","post","type-post","status-publish","format-standard","hentry","category-sqllobeditor","tag-text","tag-varcharmax"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=1327"}],"version-history":[{"count":4,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1327\/revisions"}],"predecessor-version":[{"id":27406,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1327\/revisions\/27406"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=1327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=1327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=1327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}