Q
Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server datatypes and their Oracle equivalents

We have taken delivery of a SQL Server 2000 system, which nightly pumps out data to text files using iSQL. In our data warehouse I am trying to design staging tables for that data to be SQL*Loaded. However I cannot seem to find a definitive list of SQL Server datatypes and their Oracle 8i equivalents. Can you help at all?

I come from an Oracle background and have recently been working on some SQL Server databases. So I needed a document that would map my Oracle concepts with SQL Server concepts to get me up and running quickly. Microsoft has nicely provided such a document titled "Migrating Oracle Databases to SQL Server 2000". This document works going the other way as well. You can find a copy of this document at the following URL:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlorcle.asp

There is a small section on contrasting SQL Server datatypes with Oracle datatypes.

For More Information


This was last published in August 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close