sql server programming: Upsizing Access Queries to SQLExpress -- sql server programming

Upsizing Access Queries to SQLExpress

dotNET learner
4/8/2007 9:10:42 PM

sql server programming: I could successfully upsize all TABLES of an Access2002 database to
SQLEXPRESS.

How can I export/upsize Access Queries (which are many and useful)??

Newbie seeks help.

Thanks !

Re: Upsizing Access Queries to SQLExpress

Sylvain Lafontaine
4/8/2007 11:36:25 PM

The SQL Server Migration Assistant for Access (SSMA-Access) will do a better
job than the Access Upsizing Wizard for upsizing queries. However, for a
lot of them, you will have to do the job yourself using the SQL Server
Management Studio (SSMS, come with SQL-Server 2005) or the SQL
Server Management Studio Express (SSMSE, for SQL-Server 2005 Express, free).

SSMA-Access:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

SSMSE:
http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

[quoted text, click to view]