[AccessD] Terrible performance like I have never seen before

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



My 2 cents on this.

Provided you tables are in good condition you can move the data from Access to SQL Server painlessly and fast.  SQL Server has some excellent tools to import data from many valid sources.

Most of the work will moving all of the heavy lifting (queries, processing etc) from MS Access/VBA to SQL Server Stored Procs.  The learning curve is not too bad but it is usually a fairly manual process.

I normally keep both database running in parallel until you are confident the SQL Server version is working as expected.

Hope that helps a bit.

Cheers
Darryl
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Friday, 9 July 2010 12:07 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Terrible performance like I have never seen before

Jim, BE conversion to SS is something I have been planning to start doing
with my clients.  Can you give a bit more detail on how you proceeded?  Did
you convert the BE totally to SS, then debug the FE until it was working,
then tune it?  Or did you have 2 BE and gradually convert table by table?
Or other??

Thanks,

Doug

On Wed, Jul 7, 2010 at 7:43 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> I have heard your story before and have held a couple of clients back from
> upgrading until I can transfer their BE to MS SQL or SQL Express. The last
> app that I migrated from a MDB BE to SQL Express, took about a month, in
> dribs and drabs, to re-write, with SPs and using ADO-OLE connection. (Real
> men and women do not use ODBC so we will not use that four letter
> euphemism,
> in polite company, again.) ;-)
>
> The new app now runs about twice as fast as the old 2003 FE/BE even using
> the retarded Access2007 FE. This fall or early spring I will be moving the
> FE to .Net and that will be an end to it.
>
> Jim
>
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________