Problems in exporting constraints and keys -- sql server clients

Andrew J. Kelly
1/7/2007 12:18:29 PM

Why don't you script the database and all its objects and then run that
instead of the wizard? Right click on the db and choose All Tasks -
Generate SQL Scripts for the script wizard.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Chakravarthy
1/7/2007 9:16:24 PM

When i try to replicate a production database as a new development database
by creating an empty DB called, say 'AppDev' in Enterprise Manager, and then
export the data using the Tasks->Export Data , the constraints, Primary Keys
and Foreign Keys are not exported , even though i have selected these
options . The data however is exported.

Is there a catch, or a better way to do this ?

Thanks,
Raj.

sql server clients : Problems in exporting constraints and keys