Hi All, I am recently new to replication (few years as DBA though) and I am supporting an application which uses repl to maintain 'historical + current' data for SSRS purposes only (I know... one of those situations).
- First question is if there is an upgrade of the app which changes table structures and adds new tables, does this fact "immediately" implies the need for a new Snapshot?
- Does it make sense to even try to re-sync REPL after the upgrade?
- Is it 'possible/safe' to just drop the changed articles and add new ones without reinitializing?
- I've heard/read about initializing from backups, but I understand that it is done from a backup of Publisher to Subscriber therefore negating the intention of the developers to maintain a repository like DB for reporting purposes only, is this correct?
Thanks so much in advance to anyone that can comment on these questions as it not easy to find info with this app design.