none
DATE data type is not replicated to Subscriber in Merge Replication RRS feed

  • Question

  • Hi,

    I have configured Merge Replication on DB. This is SQL Server 2016 ENT 

    What i observered is in one table (Column) DATE and TIME data type is not replacted from Publisher to Subscriber DB instead it is showing as Varchar at subscriber side.

    How to fix this issue? 

    Wednesday, October 9, 2019 10:46 PM

Answers

  • Hi VijayKSQL,

     

    Would you please try to regenerate the snapshot and apply it to the Subscriber?

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by VijayKSQL Thursday, October 24, 2019 4:52 PM
    Thursday, October 10, 2019 8:57 AM

All replies

  • Hi VijayKSQL,

     

    Would you please try to regenerate the snapshot and apply it to the Subscriber?

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by VijayKSQL Thursday, October 24, 2019 4:52 PM
    Thursday, October 10, 2019 8:57 AM
  • I did twice but no use.

    Please help are there any setting i am missing here.


    • Edited by VijayKSQL Monday, October 14, 2019 3:46 AM add
    Thursday, October 10, 2019 2:29 PM