[AccessD] upsize mdb to SQL Server

[John Colby]

You can get extraordinary speedup by converting your access queries to
queries running on sql server. As in 20 minutes down to a few seconds
depending on the original complexity of the query. Been there done that.

On Wed, Nov 6, 2019, 11:44 John Bodin <jbodin at sbor.com> wrote:

> I was wondering if someone could send me some links to docs & how tos, or
> share advice on converting access back-end mdb to SQL Server, and continue
> to use access front-end to access that data.  I know there are some data
> types that change or don't convert (yes/no fields I believe is one) and
> Queries and SQL statements need to be re-written, among other things.  I
> have a long time access database a company is running successfully that
> needs a face-lift and more robust BE.
>
> This will be a multi-phase year-long project and I was hoping to upsize
> the BE data to SQL Server and initially, just link the FE to those tables
> to run the program as is (I know there will be no speed gains but hopefully
> data integrity will be solid and users will not know that BE has changed.)
> Then proceed to convert FE to use ADO(?) while another developer writes a
> Mobile/web-based app for customer's technicians to use, that integrates
> with the SQL data (tried ASP.Net with MDB file and although it worked, it
> wasn't reliable enough when a lot of people were on the mobile piece.)
> Once Mobile piece working and FE optimized to use ADO or something else,
> app to integrate QuickBooks w/Access will be written, and when that is
> done, Access FE will get re-written for the web.  Will not be an overnight
> project, everyone understands that.  And data is small enough that SQL
> Express probably can be used, at least initially. Have room left on host
> for test VM's for project.
>
> Appreciate any guidance.
>
> John
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>