I have server1\database1 (production) being replicated to server2\database1 (reporting) running on SQL Server 2016. In both databases, there are objects (table, sp, function, ...) created by the user. In the beginning, the user objects were synchronizing correctly, but over the time they failed to fix the issues (it's their responsibility).
Now I have to migrate to new servers (SQL Server 2022) but having difficulties with user objects.
I was thinking about moving all these objects to a new database (server2\database2) (only keep the tables) and use synonyms. Is it a good idea? Any other ideas? Pros / cons
Otherwise I'll need to drop and recreate most of them to fix the replication issues.
