I have two different database (on two different hosts). One database is transactional and another database is reporting. Let us say, it stores information about departments and their employees.
Transactional Database has one department table which stores employee data of all departments. This table has foreign and primary keys. This table has no partitions. Disk size is above 250 gb.
Reporting Database has one department table which is partitioned by department id. This table has no primary or foreign keys. Otherwise, structurally this table is same as transactional one.
Is there any way to replicate the department table between transactional and reporting.