OraFAQ Forum: Server Administration » Migrating MS SQL into Oracle database

Home » RDBMS Server » Server Administration » Migrating MS SQL into Oracle database (Oracle 11gr2 , Linux 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migrating MS SQL into Oracle database [message #601696]

Sun, 24 November 2013 10:58

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

We are in process of migrating MS SQL database with Oracle database server.How to verify DB requirements are compatible with existing Oracle servers ?

MS SQL database is a reporting database where all reports will be generated.All Oracle DB servers are running with OLAP option.

Can we create a seperate database environment for reporting database or merge with same existing oracle server .Also can you suggest which option (OLTP or OLAP)
is suitable for reporting database ?

Thanks

[Updated on: Sun, 24 November 2013 10:58]

Report message to a moderator

Re: Migrating MS SQL into Oracle database [message #601778 is a reply to message #601696]

Mon, 25 November 2013 10:39

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Guys,

Can you please reponds ?

Report message to a moderator

Re: Migrating MS SQL into Oracle database [message #601779 is a reply to message #601778]

Mon, 25 November 2013 10:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post SQL & results that show the difference between OLTP & OLAP databases

Report message to a moderator

Re: Migrating MS SQL into Oracle database [message #601823 is a reply to message #601696]

Tue, 26 November 2013 02:57

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Benchmark. Testing is your only option.

HTH
-g

Report message to a moderator

Re: Migrating MS SQL into Oracle database [message #601961 is a reply to message #601823]

Wed, 27 November 2013 19:30

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi Blackswan & Swan,

Sorry for the delay in reponds.I was out of station and did not have access to emails.Once i am back to office i will post the SQL results.

I will do the testing as well.

Thanks

Report message to a moderator

Re: Migrating MS SQL into Oracle database [message #602180 is a reply to message #601961]

Sat, 30 November 2013 21:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Jack14 wrote on Wed, 27 November 2013 17:30

Hi Blackswan & Swan,

Sorry for the delay in reponds.I was out of station and did not have access to emails.Once i am back to office i will post the SQL results.

I will do the testing as well.

Thanks

post SQL & results that show the difference between oltp & OLAP databases

Report message to a moderator

Previous Topic:	Table compression
Next Topic:	Quota assigned to user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:22:07 CST 2025