Home » RDBMS Server » Networking and Gateways » SQL Server && Oracle 10g
SQL Server && Oracle 10g [message #192153] Mon, 11 September 2006 05:01 Go to next message
Claud
Messages: 17
Registered: July 2006
Junior Member
hi...
I am planning my Data Warehouse.
First i should have an operational Database,
so i take sample data from SQL Server.

How can i move the operational database in the SQL Server to Oracle Database?

May be someone can help me with the other alternative for my operational database to being simple.

Thanks...
Re: SQL Server && Oracle 10g [message #192250 is a reply to message #192153] Mon, 11 September 2006 09:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> so i take sample data from SQL Server.
Is this a real time data you are sampling
or
Just some organized data to facilitate the the learning process in oracle?
If so, oracle has its own database schemas to help with that.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14198/toc.htm
Re: SQL Server && Oracle 10g [message #194088 is a reply to message #192250] Wed, 20 September 2006 14:32 Go to previous message
Claud
Messages: 17
Registered: July 2006
Junior Member
Thanks for your help Mahesh Rajendran.
I want to build my demo software to showing Data Warehouse Features on Oracle 10g.
so i need an operational database like sales, it later can become fact & dimension tables.
I will explore that link, and i will reply you soon =)

[Updated on: Wed, 20 September 2006 14:39]

Report message to a moderator

Previous Topic: ORA 12203:TNS:unable to connect to destination
Next Topic: Oracle 10g Express for Windows on a USB key
Goto Forum:
  


Current Time: Fri Nov 29 01:11:59 CST 2024