Scriptoria for SQL Server is an advanced Microsoft Access to SQL Server migration and prototyping tool.
The Query Translation Facility expertly converts all MS-Access queries, including variable column cross tabs and multi-table updates into SQL Server views, procedures and/or functions.
With the .Net conversion option, MS-Access Forms are converted to ASP.Net WebForms and Reports to SQL Server Reporting Services (SSRS) or Crystal Reports .Net.
You can also generate new MS-Access applications (in MDB format) that utilize the converted queries while retaining the exact look-and-feel and operation of the original application, effectively transforming them into true client-server architecture. Since the data and queries now operate on the SQL Server platform, the MS-Access front-end operates as an efficient presentation layer.
Copyright