How to copy database structure to another server?

  • Hi experts,

       I want to copy over one SQL Server 2000 database structure to another SQL Server 2000, but no data need to be copied over?

    Thank you.

  • There are several ways to accomplish this.  DTS has a "Copy Objects" task which can either include data or not.  My preferred method tends to be scripting out the database objects and then running the script on the target server.  This can be done in Enterprise Manager by right clicking the database, go to "all tasks" and then generate script.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

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

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