1

I have a logical model and a database generated from it. How can I export database from Rational rose and import it to MS Access? I managed to export database as *.ddl file. enter image description here

J.Olufsen
  • 13,415
  • 44
  • 120
  • 185
  • Looks like a duplicate of http://stackoverflow.com/questions/1153471/how-can-i-import-a-database-schema-into-ms-access-2003-from-sql-text-file, where the answers do not include the command line tool option. – Pekka Jul 04 '13 at 18:07

1 Answers1

0

This was answered, as well as can be done, in How can I import a database schema into MS Access 2003 from sql text file? The process is cumbersome, and does not lend itself well to automation.

A possible more practical solution is to use a command line tool and run the DDL as a script. See http://en.wikibooks.org/wiki/JET_Database/Manipulation_tools for a list of tools (unchecked).

The JetSQLConsole command line tool at SourceForce is current and can implement what you require.

Community
  • 1
  • 1
Pekka
  • 3,529
  • 27
  • 45