Hi. I have a DB2 database containing productive data. Now during the development process i have changed the schema in a test database. so the new test schema has additional colunms, some columns are removed and some are renamed. Is there a way to update the productive schema to the new one? Maybe a tool that generated a script or something like that?
Most people that are modifying the schema of a database write scripts to do the changes to a development/test system. Then when the testing is complete, they use those same scripts to modify the production systems. If you did not do this, then you will need to generate the scripts yourself based on the differences from the test system versus the production system.
Oh really? Well, i use NHibernate to create the database. I just create entities in my Visual Studio and NHibernate creates the database. but unfortunately the Schema Updateing process doesn't work, because DB2 is noch able to do this right. So i need another way. Something like a diff script would be ok. Do you know a tool that can compare two databases and create a diff script that synchronizes both?