The 2SQL solution encompasses 100% of SQL Server-based processing of SQL Expressions. If processing does not occur in SQL Server, it must occur in the (client) Microsoft Access environment which defeats the purpose of migrating to SQL Server. Client-side processing means that the data must be pulled down from SQL Server first, creating the problem of severely compromised performance.
Although it is possible to manually determine which SQL expressions will or will not compromise performance, the 2SQL automated solution delivers server-side processing unconditionally. This guarantees the power of SQL Server processing, paving the way for future development as the new application is subsequently enhanced post-conversion to provide more functionality.