Post reply

Replication problems

  • August 26, 2009 at 12:33 pm

    #133258

    Hello All,

    I have a problem with the replication.

    I am trying to replicate a table with 5 columns in table A on Production server to a table with 6 columns table B on test server. So, my question is: Can this be done???

    Is it possible to replacate tables with different number of columns?? I am trying to add a datetime column on table B.

    Can this be done?? If yes, then how to proceed with the process?

    Thanks

    Chitanya Chitturi :-)

  • August 26, 2009 at 1:13 pm

    #1045116

    The column in the destination server that does not exist needs to have a default so it is populated by the insert statement.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • August 27, 2009 at 8:03 am

    #1045549

    Hi Steve,

    I have added an additional column in the destination server and set a default for it. Then i have tried the replication but of No use :(. How do we use an insert column as it is a datetime column?

    Can you explain me where am i going wrong?

    Thanks

    Chitanya Chitturi :-)

Viewing 3 posts - 1 through 2 (of 2 total)

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