[AccessD] Moving to SQL Server

I like the idea that it recommend whether a query should be converted to a
certain object on the SQL server but give the developer the option to change
it.  Default conversions could be standard select queries get converted to
views, but any action queries (make table, append, delete) would get
converted to stored procedures or pass throughs.

HTH

Rusty

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
Sent: Tuesday, June 13, 2006 4:04 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Moving to SQL Server


Hi
 
I am working (sort of with) the development people for the new SQL Server
2005 Migration Assistant. Anyway. When moving queries etc to SQL Server what
server side objects should they be converted to
 
Stored Procedures
Views
Passs Throughs
UDFs
 
Or should the developer have the choice. Say a dialog which listed the
objects and allowed oyu to pick the most appropriate.
I am interesteed in teh real work developers do as the primary focus of the
assistant is developers. 
 
Would a wizartd driven interface help or would you prefer no wizard. If
there was a wizard would you want it to do the whole thing or just prepare
the databsae and then let you manually adjust things like queries and data
types?
 
How would you like queries in form objects handled?
 
So what do you think?
 
All comments etc will be passed on to the development group.
 
Martin
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 
 

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************