Exporting database schema

[matanasescu]

I would like to export database schema of an Access database to an SQL
script. How can I export using Access 2002?

Thanks,
Marius

 

[a a r o n _ k e m p f]

you can't.

Jet doesn't support this DDL functionality.

upsize to SQL Server, and then right-click CREATE TO new query window

 

[BruceM]

I don't know the answer, but Aaron's reply is not to be trusted. He says
the same thing no matter the question.

 

[Tony Toews [MVP]]

I would like to export database schema of an Access database to an SQL
script. How can I export using Access 2002?

One approach would be to upsize the database. Note that the built in
upsizing tool has "issues"

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/