What is the proper technique to update the schema of a database on a Standby server, when you make schema changes to a database on the Primary server?
How about this: delete the database on the standby server, replace it with a recent backup copy from the primary server (one which does contain your schema changes) ?
Does one have to go through the whole song-and-dance setup again on both servers after doing that? In which case it's not a good solution, because the whole song-and-danceinvolves taking the primary offline for a little while, which is not a solution.
Seems like there is likely a better way. Any input appreciated, thank you.