Regarding data transfer ?

  • 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

  • 1 time transfer or continuous transfer?

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

    continuous I would look at replication

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

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

  • 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

  • connection string yes, table name no

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

  • if many dft is that affect the performance are not

  • 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