AnsweredAssumed Answered

Updating schema on Standby server?

Question asked by triac on May 24, 2018
Latest reply on May 25, 2018 by triac

Folks

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.

Outcomes