Issue with syncing database changes
Development and Programming
Im working locally on my company’s EE site. Once Ive made changes they need to go to a dev version for testing, and are then migrated to our live site.
The problem is that our live site is being used and content is constantly being added. So while I can copy over my template file changes, I can’t just import my database from the local or dev environment. Currently I have to remember all the changes I made in the admin interface and repeat them.
Is their a way around this? Can you separate a databse into 2 so one is for content and the other configuration?
Thanks
JamesBrighton,
Dealing with the database is the booger of multi-staged development. There is no easy way to do it. You might look into using some some SQL tools that can mange the differences. Separating the databases in two would not be recommended as we would be unable to support that configuration. I will move this into Development and Programming so that Community can provide some insight.
Cheers,