search

wwevo / guildhome

Day to day guild management tool and community hub for Guild Wars 2
0 stars 2 forks source link

keep database-structure up-to-date #65

Open wwevo opened 7 years ago

wwevo commented 7 years ago

As we are entering a phase where we have to tinker with the database a lot and have to change some fields and such, I really need to find a way to effect these changes to the production system and other test systems as well. How does one set up a testing database? and how could I transfer the fields and all to the production system but leave the data there intact? Any Database Pro here who can explain how this is done? :) right now we have to alter each table manually and then migrate the data manually. which can take quite a while and we might even forget a field or two in the first go ^^ is there like a tool that can compare databases and migrate them? like GIT does for example? Is there a GIT for databases?? ^^

AniOnGit commented 7 years ago

Maybe I can care about that topic as I often could need it too.