Good morning everyone,
I am curious to see how other developers handle this.
A client wants a significant modification to a system. Something that include adding new tables, relationships, and Layout. I have three options:
1. Work on the live system.
2. Work on a copy and and then transfer all the changes to the live system.
3. Work on a copy and then sync the live copy
#1 is dangerous
#2. Since you can not import or copy and paste layouts and relationships you will have to manually redo this work and therefore you still need to test everything which means messing with their data.
#3. Extremely tedious (this client solution has 90 tables)
So as I say, I am curious how you do it.