Post reply

Copying data from one server to another - SQL Server 2008

  • December 7, 2011 at 12:35 pm

    #253262

    I have to 2008 SQL servers with identical databases..

    Server1: database Energy has a table called Weather

    Server2: database Energy has a table called Weather

    I want to copy specific data (result of a select query) from Server1 to Server2

    What's the quickest way to do this manually?

  • December 7, 2011 at 1:02 pm

    #1418344

    Try the SQL Server Import/Export Wizard.

  • December 7, 2011 at 1:07 pm

    #1418347

    That would be the easiest.. If you need to do it more than once I'd save the package created by the wizard since it is really just an SSIS package.. And you can modify it later..

    CEWII

  • December 7, 2011 at 1:34 pm

    #1418358

    This is what I did:

    At the source "server2"

    Created a linked server (Server1)

    Ran the follwoing query:

    insert into Server1.Energy.dbo.Elect_XMain_Daily

    select * from Elect_XMain_Daily

    where Date_Stamp > '11-21-2011'

  • December 7, 2011 at 1:54 pm

    #1418366

    Not a fan of linked servers.. They have their place but I caution against using them much.

    CEWII

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

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