The Differences between SQL Version and DBF Version
Evaluate Item Differences between SQL and DBF Version
Common Task
No Differences

Operating Interface

No Differences
Speed of creating invoice and data at Local Sitel
 Almost the Same
Speed of creating invoice and data at Remote Site

SQL can remote login through telephone line or broadband in a reasonable speed. However, DBF version cannot.

Database Integrity When the network or the file server is not stable in office, there will be a high opportunity of getting data lost. However, SQL version can avoid this situation by Protective Policy in SQL Server. Data can remain stable.
Search Customers and Product Information by Code Almost the same, both can have result immediately
Search Customers and Product Information by Name When searching from huge amount of data, SQL can have result immediately. However DBF version takes a longer time
Summary Analysis Report When searching from huge amount of data, SQL can have result immediately. However DBF version takes a longer time
Analysis Tools

SQL version can alomost support External Analysis Tool. However, DBF version cannot.
There is an internal "VIEWS" in Dynamic Account System's Database. The main functions are calculating Cost, Invoicing Balance, Customer Outstanding Balance, and to export data for third party software to further analyse.