To migrate data and database schema from a My SQL database use SQLines Data tool.

First, some conventions: Tip For performance reasons, it is often a good idea to set BLOB and CLOB columns as lazy Loaded.

A resultset containing one of more very large columns takes time to transit between the database and the PHP server, so you want to make sure this only happen when you actually need it.

With SQL Server we have the following options based on the size required. The Oracle equivalent of these datatypes would be the NUMBER datatype specifying a precision based on the size required and a scale of 0.

Specifying precision and scale should ring a bell for SQL Server DBAs when it comes to the decimal and numeric datatypes we use in SQL Server.

DECIMAL[(p[,s])] and NUMERIC[(p[,s])] in SQL Server can be represented by NUMBER(p,s) in Oracle.

The only difference to note with the two technologies is that in SQL Server the scale must be between 0 and the precision, i.e..For this comparison we are going to focus on SQL Server 2012 and Oracle 11g Release 2.Full descriptions of all the datatypes for each technology can be found using the following links: When it comes to exact numeric the most often used datatype would probably be the integer datatype. When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.That information, along with your comments, will be governed by DISQUS’ privacy policy.SCALE might appear to be truncating data, but Oracle does still store the entire number as typed. If a column is defined like : For NUMBER data types: precision p = Number of Digits For FLOAT data types: precision p = Binary Precision (multiply by 0.30103 to convert) So FLOAT = FLOAT (126) = 126 x 0.30103 = approx 37.9 digits of precision.