Re: Problems in exporting constraints and keys

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@xxxxxxxxxxx> wrote in message
news:u4O6%23LnMHHA.448@xxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: Ownership objects after copying them with the Copy SQL-Server
    ... For tables then you can use the wizard to do the DataPump ... To do the views I would script them out and apply. ... database I created the ...
    (microsoft.public.sqlserver.dts)
  • Copy Table + data from database A to database B
    ... I'm really new to this DBA stuff and I need an explanation for what just happened. ... I just used the copy wizard to copy Table A from database A to database B. ... I had to generate a script for the table to create that table in database B with the IDENTITY in place and ...
    (microsoft.public.sqlserver.server)
  • re: Drop-Dowm-Box based on database results
    ... This starts the Database Results ... On page 4 of the wizard, select Dropdown List - One Record ... add the following script to ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.programming)
  • [NEWS] IBM Informix Web DataBlade Local Root by Design
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
    (Securiteam)
  • RE: Need some MySQL query help...
    ... attempting to run the script: ... passed to the database. ... passwd entry to the current database entry. ...
    (perl.dbi.users)
Loading