Upsizing Access Queries to SQLExpress

[dotNET learner]

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 !

 

[Sylvain Lafontaine]

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/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

[dotNET learner]

This is what I wanted.

Thank you so much !

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/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

[Aaron Kempf]

you can learn SQL Server and lose the training wheels