Post reply

Tables not shown in articles window of new publication wizard

  • May 26, 2015 at 5:22 am

    #317742

    We have restored a database on new server without keeping replication settings. Now while creating the publication no tables are shown in new publication wizard window. In fact we have hundred of tables in database and included in replication on source server from where backup was taken.

    What may be the reason that tables are not appearing?

    Regards

    DBDigger Microsoft Data Platform Consultancy.

  • May 26, 2015 at 11:31 am

    #1800660

    Issue is solved. CDC was enabled on newly restored database and it was preventing the replication wizard to pick the tables for display. Publication wizard excludes the tables if CDC is enabled on database.

    DBDigger Microsoft Data Platform Consultancy.

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

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