Post reply

Synchronizing two Databases in SSIS?

  • January 17, 2012 at 5:24 am

    #143089

    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

  • January 17, 2012 at 8:59 am

    #1434666

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

  • January 17, 2012 at 9:54 am

    #1434710

    Daniel Bowlin (1/17/2012)

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

    how to do replication?

    Thanks,
    Charmer

  • January 17, 2012 at 1:07 pm

    #1434825

    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

  • January 18, 2012 at 3:57 am

    #1435101

    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

  • January 18, 2012 at 5:50 am

    #1435171

    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

  • January 18, 2012 at 5:57 am

    #1435178

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

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

  • January 18, 2012 at 6:27 am

    #1435190

    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

  • January 18, 2012 at 6:51 am

    #1435202

    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

  • January 18, 2012 at 6:57 am

    #1435205

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

  • January 18, 2012 at 9:00 am

    #1435328

    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

  • January 18, 2012 at 11:13 pm

    #1435652

    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.

  • January 19, 2012 at 7:52 am

    #1435867

    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