Problems in exporting constraints and keys

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@.hotmail.com> wrote in message
news:u4O6%23LnMHHA.448@.TK2MSFTNGP04.phx.gbl...
> 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