sql 2005 to oracle11g database upgrade

Question

sql 2005 to oracle11g database upgrade

ramshali83

SSC Rookie

Points: 35
More actions
November 10, 2016 at 4:27 am

#331860

sql 2005 to oracle11g database upgrade can u any else please send the step by step process

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

That's not an upgrade, that's a complete re-write on the new platform.

All tables will need to be re-done with Oracle's data types, all stored procedures, functions and views will need to be rewritten. Application code that accesses the DB will need t o be rewritten.

Good luck.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ramshali83 SSC Rookie Points: 35 More actions · Answer 2

HI SIR,

THANKS FOR REPLY ,

WE ARE USING SAP APPLICATION WITH SQL DATABASE 2005, NOW WE R GOING TO UPGRADE THE DATBASE LEVEL WE HAVE PLAN TO UPGRADE ORACLE DB IT IS POSSIBLE OTHER WISE WE HAVE TO INSTALL FRESHLY, KINDLY GIVE US SOME VALUABLE SOLUTION PLEASE , WE HAVE TO START THE PROCESS.

REGARDS,

K RAMAMMOORTHY

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

To start with, fix that broken caps lock.

I'd start by speaking with SAP, they'll have more insight on what's required to port one of their applications to a different DB engine than anyone here.

This is not a quick process, don't think that it'll be finished this week.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 4

ramshali83 (11/10/2016)
HI SIR,
THANKS FOR REPLY ,
WE ARE USING SAP APPLICATION WITH SQL DATABASE 2005, NOW WE R GOING TO UPGRADE THE DATBASE LEVEL WE HAVE PLAN TO UPGRADE ORACLE DB IT IS POSSIBLE OTHER WISE WE HAVE TO INSTALL FRESHLY, KINDLY GIVE US SOME VALUABLE SOLUTION PLEASE , WE HAVE TO START THE PROCESS.
REGARDS,
K RAMAMMOORTHY

Out of pure curiosity, what is the reason for using Oracle and not SQL Server?

😎

This is not a simple database upgrade task, it is a fresh installation and migration project which can easily take weeks or even months depending on the level of customisation and custom code in the SAP, installations this old normally have quite a lot of those. Suggest contracting an SAP migration expert for the project.

ramshali83 SSC Rookie Points: 35 More actions · Answer 5

ramshali83

SSC Rookie

Points: 35

November 10, 2016 at 9:45 pm

#1911823

dear all,

thanks for reply

kevaburg SSCoach Points: 18131 More actions · Answer 6

Eirikur Eiriksson (11/10/2016)
ramshali83 (11/10/2016)
HI SIR,
THANKS FOR REPLY ,
WE ARE USING SAP APPLICATION WITH SQL DATABASE 2005, NOW WE R GOING TO UPGRADE THE DATBASE LEVEL WE HAVE PLAN TO UPGRADE ORACLE DB IT IS POSSIBLE OTHER WISE WE HAVE TO INSTALL FRESHLY, KINDLY GIVE US SOME VALUABLE SOLUTION PLEASE , WE HAVE TO START THE PROCESS.
REGARDS,
K RAMAMMOORTHY
Out of pure curiosity, what is the reason for using Oracle and not SQL Server?
😎
This is not a simple database upgrade task, it is a fresh installation and migration project which can easily take weeks or even months depending on the level of customisation and custom code in the SAP, installations this old normally have quite a lot of those. Suggest contracting an SAP migration expert for the project.

I would like to ask the question as well about why the move away form SQL Server.

If you want to upgrade to SQL Server 2016 you would Need to do two migrations, the first to 2014 (for example) and then to 2016.......

https://msdn.microsoft.com/en-us/library/ms143393.aspx

Alternatively migrate directly into 2014 and leave it there.....

My advice would be to stay with SQL Server. It will be a much more cost effective solution than moving to Oracle especially if you don't have the Oracle DBAs to administer it.....