{"id":31470,"date":"2024-11-12T18:27:28","date_gmt":"2024-11-12T17:27:28","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/need-help-opening-a-massive-dbo-45gb-any-advice\/"},"modified":"2024-11-12T18:27:28","modified_gmt":"2024-11-12T17:27:28","slug":"need-help-opening-a-massive-dbo-45gb-any-advice","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/need-help-opening-a-massive-dbo-45gb-any-advice\/","title":{"rendered":"Need Help Opening A Massive .dbo (45GB) \u2014 Any Advice?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hey everyone! I\u2019ve got this gigantic file, ePCR.dbo.MedicalRecord, sitting at a whopping 45.4 GB, and I\u2019m stumped on how to open it. \ud83d\ude05 I tried using DBeaver, but I keep hitting an OutOfMemoryError, even after bumping up the memory settings. It seems like it\u2019s way too big for DBeaver to handle.<\/p>\n<p>Does anyone have any experience with these kinds of files or know any tricks for working with huge .dbo files? Ideally, I\u2019d like to export the data to a CSV so I can actually dig into it, but I\u2019m open to any advice or tool suggestions. I\u2019m not even 100% sure what program originally created this file, so I\u2019m working with limited info here.<\/p>\n<p>Image: <a href=\"https:\/\/imgur.com\/QjQnBmO\">File Properties<\/a><\/p>\n<p>Any help would be awesome \u2014 thanks in advance! \ud83d\ude4f<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/alb53\"> \/u\/alb53 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1gppzgg\/need_help_opening_a_massive_dbo_45gb_any_advice\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1gppzgg\/need_help_opening_a_massive_dbo_45gb_any_advice\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-31470 jlk' href='javascript:void(0)' data-task='like' data-post_id='31470' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-31470 lc'>0<\/span><\/a><\/div><\/div> <div class='status-31470 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hey everyone! I\u2019ve got this gigantic file, ePCR.dbo.MedicalRecord, sitting at a whopping 45.4 GB, and I\u2019m stumped&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-31470","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/31470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=31470"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/31470\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=31470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=31470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=31470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}