Fast DBTools is a SQL Server Specific program that performs the DBDump, DBLoad and DBCopy operations, copying data between a Sage 300 ERP (Accpac) 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.
Tests 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.
|Supports CSV! the dump and load operations will read and write using either the binary REC format or a readable CSV format.|
|View a Dataset Without Loading It! For 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.|
|Sage 300 ERP (Accpac) Installation Not Required! IT 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.|
Features and Benefits
|•||FAST! Download the user manual for timing details.|
|•||View a Sage 300 ERP dataset without loading it.|
|•||Display metadata from the dataset including active applications and versions.|
|•||Sage ERP Accpac version 5.4, 5.5, 5.6 or 6.0 or Sage 300 ERP 2012|
|•||A single executable program works with all platforms|
|•||Microsoft SQL Server is required|