Generating Script for a DataBase

Originally Posted by deepuv04

Hi,
The first option Script Database as will generate the script at database level, means if you select created to option then it will generate script for create
database (a blank database).

The second option Generate Script is used to include database elements also such as Tables, Functions, Procedures, Rules.. You can specify various options in the wizard for creating the script and specify all or specific objects for script.


Thanks

Originally Posted by nmsreddi

HI deepuv

Thanks for your reply,

i used second option for generating script and also checked select all objects in database option that occur in second pane .

but now the problem is when i run the script in another server i got the database and all its objects correctly but the foreign key relations ships are missing ,
is there any more options to select, in the third pane (Choose Scripts Option) is there any changes to be made for these script options .

Any help pleaase.

Thanks

Originally Posted by deepuv04

Hi,
In the third pane, under Table/View Options set Script Foreign keys to true.

Thanks