Generating a script for database

  • Hi all,

    I am generating a script for a database so that i can execute it on some other server to create a replica of objects of current database. But this way the description written in the tables is not getting transfer.

    Please suggest some method so the description also get transferred....

    Thanks.

  • If you are using Enterprise Manger to generate the SQL script, there are some options on the Format tab that may need to be enabled. Try the "Include extended properties"

    SQL = Scarcely Qualifies as a Language

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply