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.

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

"Chakravarthy" <r_chakravarthy (AT) hotmail (DOT) com> wrote