Hi all

Is there a way of exporting database as well as the relationships of the
tables? I am trying to export data to Access or Excel.

Thanks

Yuelin

DTS is all about data transfer, not objects so it will not create
relationships. The UI side of DTS does generate some basic table structures,
but for full control these should be reviewed by hand, and can then be
implemented in Exec SQL Tasks. You can create relationships in access
through the tasks, but I don't know of any way to script this. Maybe there
is a third-party to tool to migrate data and structures from SQL to Access,
MS only provides the upsizing wizard to go the other way.

ACC2000: Create and Drop Tables and Relationships Using SQL DDL
(http://support.microsoft.com/kb/q209037/)


[quoted text, click to view]