[AccessD] Upsizing to SQL Server

John

Step 1
Get this tool

http://www.ssw.com.au/ssw/UpsizingPRO/Default.aspx

Be more than worthwhile even the free version is worth it will look at the access structures etc and tell you of any issues. Havnt done one with express but sql
 server itself yip.

Martin
-----Original Message-----
    From: "John Colby"<jwcolby at colbyconsulting.com>
    Sent: 21/12/05 19:04:44
    To: "'Access Developers discussion and problem solving'"<accessd at databaseadvisors.com>
    Subject: [AccessD] Upsizing to SQL Server
    
    I have a rather large application that I would like to upsize to SQL Server
    express.  My concern is that this is a "mission critical" app and am
    wondering how to do this.  First, can the express edition be selected from
    the Access upsizing wizard?  Second, there are 40 users.  I have no idea
    what the actual impact will be on the speed of the app etc.  This would be a
    straight data update at first, i.e. just moving the data to the Express
    server and linking via odbc (I assume) so that the app works "just like an
    access BE".  Since I can't predict the impact, I can't really say whether it
    will stand up to the load, be faster, slower, immensely slower etc. and thus
    can't just recommend that we "just do it".  SQL Server has a bunch of
    improvements that recommend it in general but I have no feel for whether
    this would really work.
    
    Has anyone ever done something like this?  The Access BE is approaching 500
    mbytes now, with about 40 concurrent users.
    
    John W. Colby
    www.ColbyConsulting.com 
    
    Contribute your unused CPU cycles to a good cause:
    http://folding.stanford.edu/
    
    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com