By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,736 Members | 1,982 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,736 IT Pros & Developers. It's quick & easy.

How to upgrade my application

P: 35
Hi all

I need some ideas from you all

My problem is like this

I have a java application in which i use nearly 50 tables and its running perfectly
I have given this application to a customer.

Now i have improved my application by adding some more features
for that i have added few more new tables and in some old tables i have added new fields and some i have removed to improve my performance
of my application

now i have to upgrade my old appplcation with the new one without loosing my old data
how to do this
The main problem is since i have changed the schema of old tables
i am not able to upgrade that . I don't have any problem with the new tables i added.

Please give some ideas...
Jan 12 '07 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
Hi all

I need some ideas from you all

My problem is like this

I have a java application in which i use nearly 50 tables and its running perfectly
I have given this application to a customer.

Now i have improved my application by adding some more features
for that i have added few more new tables and in some old tables i have added new fields and some i have removed to improve my performance
of my application

now i have to upgrade my old appplcation with the new one without loosing my old data
how to do this
The main problem is since i have changed the schema of old tables
i am not able to upgrade that . I don't have any problem with the new tables i added.

Please give some ideas...
Do you have two seperate databases or are all the tables new ones and old ones in one database? Also which database are you using?
Jan 12 '07 #2

P: 35
Do you have two seperate databases or are all the tables new ones and old ones in one database? Also which database are you using?
My applcation supports both mysql 5.0 and postgres 8.2

All the tables are in the same database .
The main thing is data in the database should not be lost.
How i tried is while upgrading my application i'll take a backup of old database base then i'll create a new database with all the new tables and old tables .
after that i'll restore the data from old database to new database .
It worked only when the schema of old tables r not changed.
But in my case i have modified few old tables structure which i need for improving the performance of the application ...
So i am getting the problem
Jan 12 '07 #3

10K+
P: 13,264
My applcation supports both mysql 5.0 and postgres 8.2

All the tables are in the same database .
The main thing is data in the database should not be lost.
How i tried is while upgrading my application i'll take a backup of old database base then i'll create a new database with all the new tables and old tables .
after that i'll restore the data from old database to new database .
It worked only when the schema of old tables r not changed.
But in my case i have modified few old tables structure which i need for improving the performance of the application ...
So i am getting the problem
Sounds to me like it's more convenient doing this the database sql side so I'll copy this thread to the MySQL forum were the experts there will be able to assist.
Jan 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.