Обсуждение: Re: restore overwrite?
On Wednesday, September 7, 2022, Anne Wainwright <anotheranne@fables.co.za> wrote:
Hi,
I want to do a restore to write over the top of existing data.
The unique key prevents this. Should I rather TRUNCATE the tables
concerned before the restore? That is a bit scary if the restore does
not work. Is there a better way.
(This data on v.8.4.4 which is being moved to latest version 14).
Thanks for answer in advance
Anne
If you cannot just do a simple restore into an empty v14 database you are probably better off not thinking of this as a restore operation but instead an ETL operation and write ETL code to extract data from the v8 database, do any necessary transforms (possibly within the v14 database but within a staging table), then merge the transformed data into the real v14 tables.
David J.