Synchronizing two Databases in SSIS?

  • Hi Friends,

    How to synchronize two database (having same table structure)? one is Live DB and another one is the back up of the Live DB..so i want to insert all the updated records from the Live DB into the Back Up DB .... How to do this through SSIS?

    Help Me Friends....

    Thanks,
    Charmer

  • I think it would be better to just set up replication.

  • Daniel Bowlin (1/17/2012)


    I think it would be better to just set up replication.

    how to do replication?

    Thanks,
    Charmer

  • I would use transactional replication, its pretty easy to set up from the GUI. Also this article explains the entire replication process in detail, http://msdn.microsoft.com/en-us/library/ms151198.aspx

  • Pankaj Shere (1/17/2012)


    I would use transactional replication, its pretty easy to set up from the GUI. Also this article explains the entire replication process in detail, http://msdn.microsoft.com/en-us/library/ms151198.aspx%5B/quote%5D

    Hi,

    my need is to synchronize from 192.168.15 server to same server database and to 192.168.14 server database...

    so same as well as different server synchronization....which replication will be useful?

    but i would like to know whether synchronization is possible or not? if yes..how ?

    Thanks,
    Charmer

  • Hi friends

    i used Transactional Replication and it worked on my local machine...but when i tried to do on another machine as a subscriber..it is not working...it creates the database but does not contain the respective tables...

    i need help friends...

    Thanks,
    Charmer

  • using replication we can transfer all the records from live database to Backup Database..

    please find stairways in our website...clear information provided .

  • ramu.a (1/18/2012)


    using replication we can transfer all the records from live database to Backup Database..

    please find stairways in our website...clear information provided .

    Thanks Buddy..it was very help full....but the objects are not creating...as the stairway says..it takes some time to create objects...let me wait for some time.....

    Thanks,
    Charmer

  • is it possible synchronizing database from one server to another server....like client to my machine...because stairway explains with the local machine...so my doubt is whether it is possible for different server?

    Thanks,
    Charmer

  • if u have two different server with public IP u can synchronize that database...is possible...i did transaction replication.now its running successfully....

  • ramu.a (1/18/2012)


    if u have two different server with public IP u can synchronize that database...is possible...i did transaction replication.now its running successfully....

    oh..but i tried with one of my colleague machine..but its not getting the objects.....why is it so? where do i make mistake?

    Thanks,
    Charmer

  • hello but you tried with your colleague machine..That machine have local IP not for public IP. that is one mistake .

    take copy of original database Backup(having public IP),restore in another server(having public IP) now you can try it.

  • ramu.a (1/18/2012)


    hello but you tried with your colleague machine..That machine have local IP not for public IP. that is one mistake .

    take copy of original database Backup(having public IP),restore in another server(having public IP) now you can try it.

    is that possible in doing with SSIS?

    Thanks,
    Charmer

Viewing 13 posts - 1 through 12 (of 12 total)

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