Post reply

copy all table structure in one database to another

  • October 6, 2010 at 9:31 am

    #239290

    If trying to copy all table structure from one database to another but can't seem to remember how to. Any help will be appreciated.

  • October 6, 2010 at 9:42 am

    #1232729

    Right click the db -> Tasks -> Generate Scripts

  • October 6, 2010 at 10:01 am

    #1232749

    Thanks. I did what you said but what i'm trying to acomplish is to copy all table structure and objects from dbase(Tan) to dBase (Tany). Do I need to modify the scripts generated from General script?

  • October 6, 2010 at 10:04 am

    #1232755

    When you select the objects to script out, select only Tables (and their dependencies..make sure you get keys, indexes, etc), then run that script on the new DB.

  • October 6, 2010 at 10:14 am

    #1232766

    Thanks you so much. It worked!! I appreciate your effort.

Viewing 5 posts - 1 through 4 (of 4 total)

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