I have 2 database servers, one for production and the other for development. What I want to update the development data with the production.
The issue is that, in development maybe I have tables that do not yet exist in production, so, I have to discard the 'delete and create'.
I have tried to create a backup file and do restore in development, but error errors appear in duplicate ids.
Does anyone know how it can be transferred?