{"id":1285,"date":"2016-01-21T15:09:16","date_gmt":"2016-01-21T14:09:16","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=1285"},"modified":"2016-01-28T15:12:23","modified_gmt":"2016-01-28T14:12:23","slug":"how-to-combine-multiple-databases-into-one","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2016\/01\/21\/how-to-combine-multiple-databases-into-one\/","title":{"rendered":"How to combine multiple databases into one"},"content":{"rendered":"<p>In order to combine data stored in two separate databases within a single database we may consider one of the following options:<\/p><p><strong>ASCII IMPORT\/EXPORT METHOD<\/strong><\/p><p>First of the possible ways is to export data from one database into CSV files using the procedure presented here:<\/p><p><a href=\"http:\/\/www.amibroker.com\/kb\/2006\/03\/04\/how-to-export-quotations-from-amibroker-to-csv-file\/\">http:\/\/www.amibroker.com\/kb\/2006\/03\/04\/how-to-export-quotations-from-amibroker-to-csv-file\/<\/a><\/p><p>Once we have our quotations exported into text files, we can load the other database and use built in ASCII importer to import data. The detailed procedure is outlined in the following Knowledge Base Article:<\/p><p><a href=\"http:\/\/www.amibroker.com\/kb\/2014\/12\/29\/importing-data-using-multiple-column-separators\/\">http:\/\/www.amibroker.com\/kb\/2014\/12\/29\/importing-data-using-multiple-column-separators\/<\/a><\/p><p><strong>FILE COPY METHOD<\/strong><\/p><p>Another way of combining the databases is to copy the individual symbols files. Each database stores individual data files within 0-9,a-z,&#8221;_&#8221; subfolders and it is possible to copy the individual data files between databases. When copying, we need to maintain the same folder pattern and copy symbols from &#8220;a&#8221; subfolder of one database into &#8220;a&#8221; subfolder of the other database (the same for other folders), so each of the symbols would land in its respective folder.<\/p><p>After we copy the data files, we also need to delete <strong>broker.master<\/strong> file from the target database folder. This is because this file stores pre-generated symbol list used for fast loading. When we delete the file, it will be reconstructed based on information from individual data files.<\/p><p>More information about the database structure can be found in the manual:<br \/><a href=\"http:\/\/www.amibroker.com\/guide\/h_workspace.html\">http:\/\/www.amibroker.com\/guide\/h_workspace.html<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>In order to combine data stored in two separate databases within a single database we may consider one of the following options:ASCII IMPORT\/EXPORT METHODFirst of the possible ways is to export data from one database into CSV files using the procedure presented here:http:\/\/www.amibroker.com\/kb\/2006\/03\/04\/how-to-export-quotations-from-amibroker-to-csv-file\/Once we have our quotations exported into text files, we can load the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[54,87,31,47,88],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1285"}],"collection":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/comments?post=1285"}],"version-history":[{"count":2,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1285\/revisions"}],"predecessor-version":[{"id":1287,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/1285\/revisions\/1287"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=1285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=1285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}