{"id":814,"date":"2022-08-03T11:41:10","date_gmt":"2022-08-03T15:41:10","guid":{"rendered":"http:\/\/dab-04.eproofs.ca\/?post_type=product_solution&#038;p=814"},"modified":"2025-10-29T15:11:00","modified_gmt":"2025-10-29T19:11:00","slug":"fast-dbtools","status":"publish","type":"product_solution","link":"https:\/\/www.da.ca\/fr\/product_solution\/fast-dbtools\/","title":{"rendered":"Fast DBTools"},"content":{"rendered":"<p><em>Fast DBTools<\/em> is a SQL Server Specific program that performs the DBDump, DBLoad and DBCopy operations, copying data between a Sage 300 ERP dataset and a SQL server database in a fraction of the time taken using the standard database-independent utilities. In a production-like network environment, a time of 90 minutes was reduced to 22 minutes on a 10.8Gb database with 384 tables.<br \/>\nTests on sample data show 10x performance gains. Tests on moderate sized databases show 100x performance gains. In general, performance gains will be even larger for larger databases. The current release will G\/L, A\/R, A\/P and I\/C data. Future versions will extend checking to other applications.<\/p>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><strong>Supports CSV!<\/strong>\u00a0the dump and load operations will read and write using either the binary REC format or a readable CSV format.<\/td>\n<\/tr>\n<tr>\n<td><strong>View a Dataset Without Loading It!<\/strong>\u00a0For a large dataset that may take hours to load, being able to view any row of any table in that dataset can be a big time-saver.<\/td>\n<\/tr>\n<tr>\n<td><strong>Sage 300 ERP Installation Not Required!<\/strong>\u00a0IT practice may dictate that ERP applications are NOT installed on the production database server. SOX Fast DBLoad will install and run as a stand-alone utility.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td colspan=\"2\"><strong><br \/>\nFeatures and Benefits<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>FAST! Download the user manual for timing details.<\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>View a Sage 300 ERP dataset without loading it.<\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>Display metadata from the dataset including active applications and versions.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td colspan=\"2\"><strong><br \/>\nPlatform Requirements<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>Sage 300 ERP version 5.4, 5.5, 5.6 or 6.0 or Sage 300 ERP 2012<\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>A single executable program works with all platforms<\/td>\n<\/tr>\n<tr>\n<td>\u2022<\/td>\n<td>Microsoft SQL Server is required<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><iframe loading=\"lazy\" src=\"http:\/\/www.youtube.com\/embed\/NNj9YwIAyE4\" width=\"500\" height=\"395\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fast DBTools is a SQL Server Specific program that performs the DBDump, DBLoad and DBCopy operations, copying data between a Sage 300 ERP dataset and a SQL server database in a fraction of the time taken using the standard database-independent utilities. In a production-like network environment, a time of 90 minutes was reduced to 22 [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","product_category":[37],"class_list":["post-814","product_solution","type-product_solution","status-publish","hentry","product_category-other-development-partner-products"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.da.ca\/fr\/wp-json\/wp\/v2\/product_solution\/814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.da.ca\/fr\/wp-json\/wp\/v2\/product_solution"}],"about":[{"href":"https:\/\/www.da.ca\/fr\/wp-json\/wp\/v2\/types\/product_solution"}],"wp:attachment":[{"href":"https:\/\/www.da.ca\/fr\/wp-json\/wp\/v2\/media?parent=814"}],"wp:term":[{"taxonomy":"product_category","embeddable":true,"href":"https:\/\/www.da.ca\/fr\/wp-json\/wp\/v2\/product_category?post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}