locked
I need records from db table which is on one server and move those records to different domain server db RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Aniruddha http://aniruddhathengadi.blogspot.com/

    Wednesday, December 31, 2014 8:52 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Aniruddha,

    Just as Erland said, the best method is use SQL Server Integration Services (SSIS) to move some records from one server table to another domain server database.

    To create a SSIS package to achieve your requirement, please refer to the following steps:

    1. Drag a Data Flow Task to Control Flow Task.
    2. Create two OLE DB Connection Managers that separately connects to the corresponding server database.
    3. Drag an OLE DB Source that connects to the source OLE DB Connection Manager.
    4. Connect OLE DB Destination to OLE DB Source.
    5. Drag an OLE DB Destination that connects to the target OLE DB Connection Manager, then create a new table as the destination table.
    6. Click Mapping pane to finish the mapping.


    References:
    Creating the Project and Basic Package in SSIS

    Thanks,
    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Thursday, January 1, 2015 6:10 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    01. Linked Server

    02. SSIS

    - Vishal

    SqlAndMe.com

    Wednesday, December 31, 2014 8:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    01. Linked Server

    02. SSIS

    And since they are in different domains, SSIS looks like the better bet. Linked servers across domains can be difficult.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Wednesday, December 31, 2014 9:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Aniruddha,

    Just as Erland said, the best method is use SQL Server Integration Services (SSIS) to move some records from one server table to another domain server database.

    To create a SSIS package to achieve your requirement, please refer to the following steps:

    1. Drag a Data Flow Task to Control Flow Task.
    2. Create two OLE DB Connection Managers that separately connects to the corresponding server database.
    3. Drag an OLE DB Source that connects to the source OLE DB Connection Manager.
    4. Connect OLE DB Destination to OLE DB Source.
    5. Drag an OLE DB Destination that connects to the target OLE DB Connection Manager, then create a new table as the destination table.
    6. Click Mapping pane to finish the mapping.


    References:
    Creating the Project and Basic Package in SSIS

    Thanks,
    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Thursday, January 1, 2015 6:10 AM