[dba-SQLServer] Upsize wizard and named queries

Jc

I did a large up size and odbc pulling large recordsets was way to slow. ADO and redid them all was the only way to go. Just changed everything to match. I was using 2003 as well which nade it easier. Also used upsizing pro and performance pro really worth getting as well for pre upsizing reports.

Each case is different of course.

Martin

-----Original Message-----
    From: "John Colby"<jwcolby at colbyconsulting.com>
    Sent: 1/21/06 12:08:02 AM
    To: "'Access Developers discussion and problem solving'"<accessd at databaseadvisors.com>, "dba-sqlserver at databaseadvisors.com"<dba-sqlserver at databaseadvisors.com>
    Subject: [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?
    Are they supposed to?  If so, what will happen?  Will the queries be deleted
    from the query tab?  What happens to the object properties
    (form/combo/list)?  Or is this only for ADPs?  If it is only for ADPs how do
    I manually upsize the queries and then how do I replace the queries in the
    object properties with the SPs or whatever the equivalent is in SQL Server.
    
    Confused in CT
    
    John W. Colby
    www.ColbyConsulting.com 
    
    
    _______________________________________________
    dba-SQLServer mailing list
    dba-SQLServer at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
    http://www.databaseadvisors.com