Post reply

Regarding data transfer ?

  • February 19, 2013 at 3:15 am

    #394213

    Hi

    i have a requriement

    i have 3 sql servers instances

    in 1st i have data in 3 to 4 tables

    i need to transfer data from ser01 to ser02 and then ser03

    for any updates in ser01 on those tables should update in ser02 and ser03

    can any suggest the better way to do this

    thanks

    with best regrads

    pradeep

  • February 19, 2013 at 3:30 am

    #1589095

    1 time transfer or continuous transfer?

    1 time, use import export data wizard, SSIS, BCP etc

    continuous I would look at replication

  • February 19, 2013 at 4:11 am

    #1589112

    continous data transfer should move data every 3 min to 1/2 hour

  • February 19, 2013 at 4:12 am

    #1589114

    then look at replication, logshipping, creating your own ssis packages, merge commands etc etc etc

  • February 19, 2013 at 4:21 am

    #1589117

    in SSIS Package can i get data from muitiple table in single data flow task

    and can we pass connection string and tables name

    thanks

  • February 19, 2013 at 4:21 am

    #1589118

    connection string yes, table name no

    you can have as many source and destinations in 1 DFT as you wish

  • February 19, 2013 at 4:55 am

    #1589135

    if many dft is that affect the performance are not

  • February 19, 2013 at 4:56 am

    #1589136

    Depends on your server hardware, load, network etc.

    Could be 1 at a time could be 100000000.

Viewing 8 posts - 1 through 7 (of 7 total)

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