question

salilsingh-9961 avatar image
0 Votes"
salilsingh-9961 asked NavtejSaini-MSFT answered

transactional replication/publication - limitations

Hi Team,

Could you please reply on below questions -

  1. In order to apply SQL Server transactional replication/publication, is it mandatory that all the tables selected in publisher to have a primary key ?

  2. Incase primary key consists of 2 columns, will transactional replication/publication work for that table?

  3. While applying transactional replication/publication what is the maximum no. of tables that could be selected as articles for publishing?

  4. Could you please provide me with limitations of transactional replication/publication?



Please note in I am trying to implement replication between an on-premises SQL Server db to Azure SQL Server db

Thanks,
Salil





sql-server-generalsql-server-transact-sqlazure-sql-databasesql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered

@salilsingh-9961

You will find the answer in few of the document1, Document2:

1) In order to apply SQL Server transactional replication/publication, is it mandatory that all the tables selected in publisher to have a primary key ? Yes it is mandatory

87146-image.png

2) Incase primary key consists of 2 columns, will transactional replication/publication work for that table? Yes the composite primary key is okay but the table should have a declared primary key

3) While applying transactional replication/publication what is the maximum no. of tables that could be selected as articles for publishing?
87216-image.png

4) Could you please provide me with limitations of transactional replication/publication? The documents have some remarks and limitations. Please check.

Please let us know if you have any questions.

Regards
Navtej S


image.png (51.3 KiB)
image.png (59.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.