Problems in exporting constraints and keys - 01-07-2007 , 09:46 AM
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 ?
Re: Problems in exporting constraints and keys - 01-07-2007 , 11:18 AM
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