{"id":3268,"date":"2014-05-28T17:31:06","date_gmt":"2014-05-28T21:31:06","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/3268\/how-do-i-archive-my-database\/"},"modified":"2024-06-20T13:18:15","modified_gmt":"2024-06-20T17:18:15","slug":"how-do-i-archive-my-database","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/41559280\/how-do-i-archive-my-database\/","title":{"rendered":"How do I archive my inFlow On-Premise database?"},"content":{"rendered":"<p>Is your inFlow On-Premise database getting too big? Do you want to officially close out your year by starting afresh? If you&#8217;ve got SQL Server 2005 installed, the maximum space allowed is 4GB. If you&#8217;ve got SQL Server 2008 R2 \/ LocalDB 2014 \/ SQL Server 2014 installed, it&#8217;s 10GB.<\/p>\n<h3><\/h3>\n<h2>Check the size of your database<\/h2>\n<p>The database files can be found on your computer in the locations listed below (based on your operating system):<\/p>\n<p style=\"padding-left: 30px;\"><strong>Windows XP\/Server 2003:<\/strong> C:\\Documents and Settings\\All Users\\Application Data\\inFlow Inventory<br \/>\n<strong>Vista, Windows 7\/Server 2008, or Windows 8:<\/strong> C:\\ProgramData\\inFlow Inventory<\/p>\n<blockquote><p>PLEASE NOTE: If you&#8217;re not able to see the folders outlined below please follow these steps to show hidden files\/folders: <a href=\"http:\/\/www.microsoft.com\/resources\/documentation\/windows\/xp\/all\/proddocs\/en-us\/win_fcab_show_file_extensions.mspx?mfr=true\">Windows XP<\/a>, <a href=\"http:\/\/www.bleepingcomputer.com\/tutorials\/how-to-see-hidden-files-in-windows-vista\/\">Vista<\/a>, <a href=\"http:\/\/www.bleepingcomputer.com\/tutorials\/show-hidden-files-in-windows-7\/\">Windows 7<\/a>, <a href=\"http:\/\/www.bleepingcomputer.com\/tutorials\/show-hidden-files-in-windows-8\/\">Windows 8<\/a>, <a href=\"http:\/\/www.isunshare.com\/windows-10\/show-hidden-files-and-folders-in-windows-10.html\">Windows 10<\/a>.<\/p><\/blockquote>\n<p>Look for a file that says inFlow.mdf (or just inFlow). You should see its size next to it. (For reference, 1GB = 1024MB = 1,048,576 KB!)<\/p>\n<p>If your database file is about 4GB, you can just uninstall and reinstall inFlow with SQL Server 2014 instead. The capacity for SQL 2014 is 10GB so you will not need to archive your database at all. <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/59275394\/how-do-i-install-inflow\/\">See the advanced instructions here for how to customize your installation.<\/a><\/p>\n<p>If you&#8217;re\u00a0nearing 10GB already though, you will\u00a0need to archive your database following the steps below.<\/p>\n<h2>Creating your archive and starting over<\/h2>\n<p>The steps to archive your database consist of storing your information in the form of CSV files and then doing a hard reset on all of your data. Keep in mind that due to the reset, all of your preferences and settings, as well as company details and any customization will need to be re-entered\/re-selected in your new database.<\/p>\n<p>Before proceeding note the following:<\/p>\n<ul>\n<li>Work Orders <strong>cannot<\/strong>\u00a0be exported, so be sure to complete any open work order before archiving. You can also note down the details to re-create them as open work orders into the new database.<\/li>\n<li>Sales Quotes\u00a0can be exported but currently <strong>cannot be imported<\/strong>.<\/li>\n<li>Attachments and Pictures cannot be exported.<\/li>\n<li>Other than billing and shipping addresses, extra addresses\u00a0cannot be exported.<\/li>\n<li>Only your default pricing scheme can be exported. If you have multiple pricing schemes,\u00a0you can change the default pricing scheme and then export your product details\u00a0multiple times.<\/li>\n<li>All settings in Personal, General, and Print settings cannot be exported and must be set up again in the new database.<\/li>\n<\/ul>\n<h3>Export your data to a .csv file<\/h3>\n<p>Some data can be exported to Excel, so we&#8217;ll save these files first.<\/p>\n<ol>\n<li>Go to <em>Main Menu &gt; General &gt; Export Data.<\/em><\/li>\n<li>Choose your data type (each will have to be exported separately)<\/li>\n<li>Click to export.<\/li>\n<\/ol>\n<p>The data types you&#8217;ll need to export are <em>Product Details, Stock Levels, Customer, Vendor, <\/em>even<em> Bill of Materials<\/em> if you use it. If you have any open\/uncompleted orders, you&#8217;ll want to export <em>Sales Orders<\/em> and <em>Purchase Orders<\/em> too.<\/p>\n<blockquote><p><strong>NOTE<\/strong>: This only exports <strong>active<\/strong> entries. Anything that has been deactivated or cancelled will not be exported. If you would like to export deactivated entries, go to the appropriate listing (e.g product list for products, customer list for customers) and then change the &#8220;Show&#8221; filter to show &#8220;Inactive&#8221;. This will refresh the list to show all inactive entries. Right-click to export these entries.<\/p><\/blockquote>\n<h3>Save your other information manually<\/h3>\n<ol>\n<li>Go to <em>Main Menu &gt; Options &gt; Settings<\/em> and note down the following\u00a0information you have saved:\n<ul>\n<li><strong>costing method*<\/strong><\/li>\n<li>user settings (user login names, and access\/editing rights)<\/li>\n<li>company settings (home currency, taxing scheme, company info)<\/li>\n<li>references (payment terms, payment methods, sales reps, receiving addresses)<\/li>\n<li>custom fields<\/li>\n<\/ul>\n<\/li>\n<li>You may also want to export your custom documents if you&#8217;ve not retained copies elsewhere. Go to <em>Main Menu &gt; Settings &gt; Print Settings.<\/em><\/li>\n<li>Click the <em>Custom Docs<\/em>\u00a0icon.<\/li>\n<li>Choose the template to export and then click the <em>Export<\/em>\u00a0button on the right and choose where to save it.<\/li>\n<\/ol>\n<h3>Backup your data<\/h3>\n<ol>\n<li>Make a backup of your current database. You might save it as Archive2011-2013.ifi or something similar, just so you know what it contains.<\/li>\n<li>Go to <em>Main Menu &gt; General &gt; Reset All Data.<\/em> You&#8217;ve already made a backup so you can easily restore to this backup at any time if you like.<\/li>\n<\/ol>\n<h3>Importing your information<\/h3>\n<p>Next, we&#8217;ll have to import the information into the newly reset database. First, you should look through the exported files and trim them before importing, otherwise you&#8217;ll still run into the same problem of your database being too big.<\/p>\n<p>Tips:<\/p>\n<ul>\n<li>For your sales and purchase orders (which is the bulk of your archives) you should delete any completed orders in the file itself so you don&#8217;t import them in.<\/li>\n<li>Be sure to always import your stock\u00a0levels LAST. Assuming that your stock\u00a0levels were correct when the export was done, importing it before orders and other information may cause changes to those levels.<\/li>\n<li>Also, be sure to back up your database before each new import (so you can reverse any changes you do not wish to keep).<\/li>\n<\/ul>\n<p>Ready to begin? See below:<\/p>\n<ol>\n<li>Once you&#8217;ve reset your database, set up your company information and settings. It&#8217;s important to do this first as some settings, such as your costing method, <strong>need<\/strong> to be selected before importing data.<br \/>\n<blockquote><p><strong>NOTE<\/strong>: If your costing method is set to FIFO\/LIFO, you will need to import your stock levels in as an &#8220;Initial&#8221; purchase order, because these costing methods rely solely on purchase orders to calculate your cost. <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/i-switched-to-fifolifo-costing-but-now-all-my-costs-are-incorrect-what-do-i-do\/\">Please see here for how to quickly convert your stock\u00a0level file into a purchase order file<\/a>.<\/p><\/blockquote>\n<\/li>\n<li>If you think you might need to archive again soon, it might be best to make a backup of your database now and name it &#8220;NewArchive&#8221; &#8212; this will ensure that you can jump straight into importing your data instead of having to re-enter your settings manually next time.<\/li>\n<li>When you&#8217;ve set up your company information, you can import all your information back into inFlow from the files you exported earlier.<\/li>\n<li>Go to <em>Main Menu &gt; General &gt; Import Data.<\/em><\/li>\n<li>Choose your data type and import using the trimmed files. (each will have to be imported separately)<\/li>\n<li>Click <em>Next<\/em> and map the fields if need be, though inFlow should do this automatically.<\/li>\n<li>Click to import.<\/li>\n<\/ol>\n<p>Once you&#8217;ve done all your imports, you&#8217;re all set! If you ever need to check the data on previous history, you can just go to <em>Main Menu &gt; General &gt; Restore Data<\/em> and restore to the previous database to check your information.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is your inFlow On-Premise database getting too big? Do you want to officially close out your year by starting afresh? If you&#8217;ve got SQL Server 2005 installed, the maximum space allowed is 4GB. If you&#8217;ve got SQL Server 2008 R2 \/ LocalDB 2014 \/ SQL Server 2014 installed, it&#8217;s 10GB. Check the size of your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,28],"tags":[312,311,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3268"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=3268"}],"version-history":[{"count":20,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3268\/revisions"}],"predecessor-version":[{"id":30003,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/3268\/revisions\/30003"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=3268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=3268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=3268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}