April 24, 2012 at 5:57 am
[font="Verdana"]Hi Folks,
Do we can list down the basic difference in data types of different DBMS like Oracle, SQL, MySQL and DB2, while keeping in view the migration cost minimum? The prime objective is to write portable N/Hibernate classes on application Front End.
Thank you![/font]
April 24, 2012 at 6:18 am
Abrar Ahmad_ (4/24/2012)
[font="Verdana"]Do we can list down the basic difference in data types of different DBMS like Oracle, SQL, MySQL and DB2, while keeping in view the migration cost minimum? The prime objective is to write portable N/Hibernate classes on application Front End.[/font]
Do you realize this is a project on itself? I would start with a blank Excel document and reviewing the documentation of each rdbms vendor.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 24, 2012 at 6:41 am
PaulB-TheOneAndOnly (4/24/2012)
Abrar Ahmad_ (4/24/2012)
[font="Verdana"]Do we can list down the basic difference in data types of different DBMS like Oracle, SQL, MySQL and DB2, while keeping in view the migration cost minimum? The prime objective is to write portable N/Hibernate classes on application Front End.[/font]Do you realize this is a project on itself? I would start with a blank Excel document and reviewing the documentation of each rdbms vendor.
[font="Verdana"]Good nice comments, Thank you!
We may can utilize different standard migration tools which may can support certain transformations/conversions implicitly, so going for complete list down for all different data types may cannot serve the purpose, what kind u suggest? I had the idea that some geeks may have get their job done already with anyone of the said scenarios, so may they can share their experiences. Do you can share with us? please!
Thank you![/font]
April 24, 2012 at 8:24 am
Here is an MSDN article page on SSIS data types that may help you get started. It lists SQL Server, Oracle, Jet, and DB2 equivalent types.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply