SQL Server Performance

Sync tables between two servers

Discussion in 'Getting Started' started by Rabani, Dec 19, 2008.

  1. Rabani New Member

    Hi,
    Can anybody give me an idea that how can i move data from a table in one server to another server into the same table which doesn't have any data on it or it is truncated. Please, help me.
    Thanks ,
    Rabani
    Rabani, Dec 19, 2008
    #2

  2. Elisabeth Redei New Member

    Hi,
    Did you have a look at the Import and Export Wizard? You will find it SQL Server Management Studio, right-click the database and choose Tasks/Import (or Export) data.
    /Elisabeth
    Elisabeth Redei, Dec 20, 2008
    #3

  3. Rabani New Member

    Hi Elizabeth ,
    Thanks a lot . It was really the easiest and fast one.
    Thanks,
    Rabani
    Rabani, Jan 6, 2009
    #4

  4. satya Moderator

    Import/Export wizard uses the underlying SSIS components to perform the tasks, if it is an ongoing task you could even schedule this as a job.
    satya, Jan 7, 2009
    #5

  5. satya Moderator

    Is this an ongoing operation or just one-off task?
    satya, Dec 20, 2008
    #6

  6. Rabani New Member

    Hi Saty
    Actually it is only one time task. I need to sync of the data between those two tables. Some are in same servers but different database and some are in different servers. I have to sync them up. Please, show me an easy way to do that.
    Thanks,
    Rabani, Dec 21, 2008
    #7

  7. satya Moderator

    satya, Dec 22, 2008
    #8

Share This Page