Upsizing Access Queries to SQLExpress

  • Thread starter Thread starter dotNET learner
  • Start date Start date
D

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 !
 
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
 
This is what I wanted.

Thank you so much !

Sylvain Lafontaine said:
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
 
Back
Top