Viewing 2 posts - 16 through 17 (of 17 total)
I'd still go with synonyms.
Something like:Have table dbo.TargetActive with the current structure and data.Create synonym dbo.Target that points to dbo.TargetActive
Then to perform load...
October 16, 2018 at 12:13 pm
#2009935
You can have multiple publications for the replication, and spread objects across these publications.
Then with deployments, you only have to reinitialize the publications containing the affected tables.While...
October 16, 2018 at 11:39 am
#2009929