The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will support. Then you would use an ETL and there are a wide variety of ETL tools from open source tools with community and enterprise editions such as Pentaho Data Integration or Talend Integrator Suite to commercial ETL tools like Informatica PowerCenter, Oracle Data Integrator, Business Objects Data Integration.
Well, I have a database specific features in my case.
And actually i am in the middle road either to migrate data or update current working DB structure and keeping data.
any help is very much welcomed
thanks a lot