Making changes from Dev to Live
I used the stabdard installer and installed 2 copies of the server, one on my PC for development work, and one on the eventual server with full internet access, ports enabled etc. After a bit of effort i eventually got it all working.
I have now made lots of changes to several tables on the "dev" database and want to commit them to live.
But now I run into problems.
The live server connectts to eqemulator and downloads the updates the team have worked on since I last did an install. Checking these I find they don't conflict with anything I have done.
I tried just copying over my peq DB to live, hoping it would connect, update and then work with all the new changes I have made. But the update would not run properly.
Eventually I had to reinstall the live server and had to think again.
I exported the table I had changed into SQL format (using navicat) but can't get them import into the new database.
Obvioulsy I am doing something very stupid.
How can I make changes to a dev version of the peq database, then commit those changes to a live server?
Can someone please help me out?
Andrew
|