I've set up replication in my SQL 2019 environment in attempt to migrate SQL databases individually from one datacenter to another. in my testing of one database several issues were found and any advice would be appreciated.
1. There several missing indexes
2. very large tables cannot be filtered on for transaction replication(post snapshot migration)
3. it takes 1-2 minutes for the transaction to publish (even if there were no database changes) but the subscriber takes the publication near instantly.
4. every publication generates a large data file that's the same size regardless of any data changes.