How to sync databases using ssis?

• Shriram Chandrasekaran

  Old Hand

  Points: 383

  More actions

  September 28, 2011 at 3:14 am

  #258019

  Hi all,

  i have three databases in my server.i wanna synchronize all the three db's. is it possible to achieve through ssis?

  Thanks & Regards,
  Shriram.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  September 28, 2011 at 3:22 am

  #1387613

  Yes. Now if you give us some more details, we may be able to help you in doing so.

  John

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  September 28, 2011 at 3:25 am

  #1387615

  Shriram R C (9/28/2011)

  ---

  Hi all,

  i have three databases in my server.i wanna synchronize all the three db's. is it possible to achieve through ssis?

  SSIS is not a mirroring tool per se. It allows you to automate the transfer of data and objects from one place to another, but you have to know exactly what you want to achieve and then you'll have to code it.

  ---