question

Instead of changing it in the default project settings, just make the modification in the project settings, that is **Tools** -> **Project Settings** -> **Type Mapping** -> **Select a Type Mapping** Option ***changed*** to **Columns type mapping** -> **number** and also do not forget the number with precision and scale (number [\*..\*] and number [\*..\*][\*..\*]). One thing which is worth mentioning is that when you change the mapping from number to numeric, choose the scale and precision wisely and beware that sometimes it might give you a small problem if the precisions of the number columns referencing some other columns in Oracle tables do not match each other. For example, suppose you have a parent table in Oracle which has a column of NUMBER(15) data type and this column is referenced in the other (child) table, but sadly the child table's column is of NUMBER type not NUMBER(15) because whoever created the child table did not bother to match the type exactly. So, if you map the NUMBER to some default precision and zero scale but borrow the actual precision when mapping number [\*..\*], you will run into trouble. In Oracle, you can still create a foreign key relationship even though the sizes don't match, but you will get an error when the SSMA tool will try to create a foreign key in SQL Server table (because it does not allow type mismatch between PK and FK). Hope this helps, Oleg