Post reply

Question on AWS DMS

  • May 7, 2019 at 2:31 pm

    #3637167

    Good morning Experts,

    Primary keys are mandatory for transactional replication. If table has no primary key, it will not be replicated. How is it in AWS DMS? Are primary keys mandatory and If table has no primary key, it will not be replicated?

  • May 7, 2019 at 11:11 pm

    #3637748

    No it's not required. The steps, setup you use are different depending on if you have primary keys or not. You setup MS-CDC if you don't have primary keys.  This documentation explains the differences, process when having keys or not having keys:

    Using a Microsoft SQL Server Database as a Source for AWS DMS

     

    Sue

     

     

  • December 14, 2021 at 6:21 am

    This was removed by the editor as SPAM

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

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