469,326 Members | 1,541 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

How to upgrade my application

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
4 1096
r035198x
13,262 8TB
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
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
r035198x
13,262 8TB
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
ronverdonk
4,258 Expert 4TB
An important question here is: are the new columns you defined DEFAULTed? If not, you must fill them almost one by one. If so, you don't have to worry (yet) and can fill them later.
It would be better to first categorize the type of new table you have defined. The following shows the actions you have to take for each type of new table.
Expand|Select|Wrap|Line Numbers
  1. STATUS NEW TABLE         |
  2. VS. OLD TABLE            | ACTION(S)
  3. -------------------------+------------------------------------------
  4. columns unchanged        | copy all data via INSERT SELECT
  5.                          |
  6. columns added            | copy all data via INSERT SELECT
  7.                          | and fill or default new columns???
  8.                     |
  9. columns removed          | copy selected columns via INSERT SELECT 
  10.                          |
  11. column added and removed | copy selected columns via INSERT SELECT
  12.                          | and fill or let default the new columns???
  13.                          |
  14. -------------------------+------------------------------------------
Ronald :cool:
Jan 12 '07 #5

Post your reply

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

Similar topics

6 posts views Thread by Joseph Geretz | last post: by
1 post views Thread by LEE | last post: by
3 posts views Thread by Randy Harris | last post: by
3 posts views Thread by Bob Altman | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.