How to upgrade my application

[123456prakash]

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...

[r035198x]

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?

[123456prakash]

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

[r035198x]

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.

[ronverdonk]

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.

STATUS NEW TABLE         |
VS. OLD TABLE            | ACTION(S)
-------------------------+------------------------------------------
columns unchanged        | copy all data via INSERT SELECT
                         |
columns added            | copy all data via INSERT SELECT
                         | and fill or default new columns???
                    |
columns removed          | copy selected columns via INSERT SELECT 
                         |
column added and removed | copy selected columns via INSERT SELECT
                         | and fill or let default the new columns???
                         |
-------------------------+------------------------------------------

Ronald :cool: