It allows me to easily backup the schema (regardless of the number of tables). I can move several tables into that schema, and back up the schema.
Really just to help me organize my own processes.
Joe.
On Fri, May 30, 2025 at 7:45 AM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
> On May 30, 2025, at 7:39 AM, Joe Tailleur <joe.tailleur@xxxxxxxxx> wrote:
>
> Using table partitioning works well for me. I detach and move the partition to an archive schema; which I can then backup and restore into a separate database, and once that is complete, remove the table from the archive schema on the live database.
What's the purpose of the archive schema?
