Post reply

Copy Table from one SQL Server to another

  • January 12, 2009 at 11:37 am

    #198211

    I need to copy a table that I have on a 2005 SQL Server to a Diffrent SQL 2005 Server

  • January 12, 2009 at 11:43 am

    #925449

    Right click on the database > Tasks > Export Data. Go through the wizard to find your source, destination, etc and you should be good to go. Make sure that you specify source and destination correctly so that you don't overwrite production data, etc.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • January 13, 2009 at 8:49 am

    #925962

    Import/Export wizard is the way to go

    Unless you want the more complicated alternatives

    Create a linked server, and select from the linked server on the destination SQL Server etc..

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

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

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