[dba-SQLServer] Upsize wizard and named queries

John

I would try that. Just link the tables and see how it goes. 

How about local caching then update back to sql server. Static recordsets you could pull down locally then pass the updates back if it turns out go be slow. Its also possible to populate local tables in the mdb of lookup values etc from sql server to help with speed. 

martin


-----Original Message-----
    From: "John Colby"<jwcolby at colbyconsulting.com>
    Sent: 1/21/06 3:41:11 AM
    To: "dba-sqlserver at databaseadvisors.com"<dba-sqlserver at databaseadvisors.com>
    Subject: Re: [dba-SQLServer] Upsize wizard and named queries
    
    Oh yea, I'm reading up on the "gotchas" and it looks like darned few of my
    queries will upsize correctly.  It's interesting now because all of the
    literature out there discusses upsizing to ADPs and now that is a dead end
    road.  Luckily in this specific case the client is using 2002 so I can at
    least do conversions one by one from queries to SPs, where the most effect
    is gained.
    
    Does anyone have any experience with how the performance compares between
    jet with large recordsets and SQL Server "emulating" jet over ODBC
    connections (linked tables)?  IOW, If I just upsize the tables and replace
    the links to the MDB with links to SQL Server tables will the database take
    a huge performance hit?  This specific db is a smallish (10 active users)
    "call center" kind of database where users enter tiny little records re the
    calls they place, but they do look at data about 150k people, divided by
    state etc.  I think I could fairly rapidly upgrade the main form to use SPs
    to pull just the small set of people data they need to work with which would
    speed up that main form dramatically I think, even over JET.
    
    
    John W. Colby
    www.ColbyConsulting.com 
    
    
    -----Original Message-----
    From: dba-sqlserver-bounces at databaseadvisors.com
    [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
    Harkins
    Sent: Friday, January 20, 2006 7:50 PM
    To: dba-sqlserver at databaseadvisors.com
    Subject: Re: [dba-SQLServer] Upsize wizard and named queries
    
    I thought that someone said I needed to pull all SQL out of properties and
    create named queries so that the upsize wizard could upsize them.  I did so
    but I am not seeing any indication that the saved queries are being upsized?
    
    =======Not all queries will upsize correctly. If you have the book that
    Martin and I did together, he mentions a number of problems you have to fix
    before upsizing. I'd look up the page if I had a copy handy, but I don't
    right this minute. If you don't have it, Martin or I could probably create a
    short list of gotchas. 
    
    Susan    

[Message truncated. Tap Edit->Mark for Download to get remaining portion.]