Post reply

Server to Server copy table

  • October 27, 2009 at 3:29 am

    #205925

    How to copy table structure from one server to another server

  • October 27, 2009 at 3:58 am

    #1071093

    Right click on the table you want to copy in management Studio choose "Script Table As" -> "Create To" -> "Clipboard"

    Make a connection to the server you want to copy it to in Management Studio right click -> paste then execute the T-SQL to create the table.

    Probably the easist way

  • January 4, 2010 at 2:10 am

    #1098306

    If you have more than one object to be copied from one server to another, or if you have some updates on the structure of the objects, you can do it very easily from Redgate SQL Compare tool. Its a very good structure compare tool which compares the differences in structure and scripts them to accomodate easily in either or source or dest server.

    --Divya

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

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