Home » RDBMS Server » Server Administration » Migrating MS SQL into Oracle database (Oracle 11gr2 , Linux 6)
Migrating MS SQL into Oracle database [message #601696] Sun, 24 November 2013 10:58 Go to next message
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 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Guys,

Can you please reponds ?
Re: Migrating MS SQL into Oracle database [message #601779 is a reply to message #601778] Mon, 25 November 2013 10:42 Go to previous messageGo to next message
BlackSwan
Messages: 22693
Registered: January 2009
Senior Member
post SQL & results that show the difference between OLTP & OLAP databases
Re: Migrating MS SQL into Oracle database [message #601823 is a reply to message #601696] Tue, 26 November 2013 02:57 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member
Benchmark. Testing is your only option.

HTH
-g
Re: Migrating MS SQL into Oracle database [message #601961 is a reply to message #601823] Wed, 27 November 2013 19:30 Go to previous messageGo to next message
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
Re: Migrating MS SQL into Oracle database [message #602180 is a reply to message #601961] Sat, 30 November 2013 21:54 Go to previous message
BlackSwan
Messages: 22693
Registered: January 2009
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
Previous Topic: Table compression
Next Topic: Quota assigned to user
Goto Forum:
  


Current Time: Sat Aug 23 13:07:06 CDT 2014

Total time taken to generate the page: 0.06085 seconds