Post reply

Copy data

  • March 13, 2009 at 8:51 pm

    #128971

    Hi all,

    I need to copy the content of a table from one server to another server.The table exists in two servers.In one server the table has 527 rows and in another server the same table has 428 rows.How can i perform this task?is that through DTS??is so can anypne please explain this task?

  • March 14, 2009 at 4:18 am

    #959661

    There are a lot of ways to transfer data from one source to another.

    1. Import-Export Wizard

    2. DTS Packages

    3. Linked Servers

    4. OPENROWSET

    --Ramesh

  • March 14, 2009 at 5:32 am

    #959673

    Hi Ramesh,

    Thanks for your reply.I planning to use Data Transformation services.If i import the table in server B from Server A will the data be deleted in the Server B.[The table already exists in Server B as well].

  • March 14, 2009 at 5:56 am

    #959679

    No, the data will not be deleted. The Transform Data task just dumps data from source to destination.

    --Ramesh

  • March 14, 2009 at 8:16 am

    #959704

    Ok..Thanks Ramesh!!! I performed the activity.It has succeeded.

  • March 14, 2009 at 9:36 am

    #959728

    I'm glad that it worked out nicely.

    --Ramesh

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

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