Numeric Data Conversion from Oracle to SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Numeric Data Conversion from Oracle to SQL Server

Author

Topic

rajbir
Starting Member

1 Post

Posted - 2009-08-10 : 16:20:18

Hi Forum

I am replicating from Oracle to SQL server with streams. There is a problem with Numeric colums.
Sql server require data with exact precision, but oracle has flexible precision. Is there any datatype available in SQL server for flexible precision.

The Cast function doesnt work in my case due to handling of some third party tools.

Please advice.

Thanks in advance,
Raj.

timmyms290
Starting Member

3 Posts

Posted - 2009-09-08 : 10:17:53

Do you need to use numerics? Can't you use bigint, tinyint, etc? They seem to be a lot more flexible.

melina386
Starting Member

7 Posts

Posted - 2009-11-16 : 00:08:39

http://www.docs.hp.com/en/36216-90216/ch08s04.html
check with this link for cast function
----------------------------------------------
[url=http://www.e-datapro.net]Data entry india[/url]

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-11-16 : 04:47:05

Float and real are the only data types in sql server that supports flexible precision. Check out this link for the official documentation: http://msdn.microsoft.com/en-us/library/ms173773.aspx

- Lumbago
http://xkcd.com/327/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources