December 13, 2011 at 1:20 am
Hi,
we are planning to apply ERP system (ORACLE). Currently we are running on SQL Server 2005.
Actually I have no idea about risks might happen after migration.
Are there any suggestions or questions that I should ask the implementer before migration.
thanks in advance.
December 13, 2011 at 3:17 am
Do you guys have any plan / budget to hire a consultant? Depending on the complexity of ERP application & data volume (and many more) it would be a good idea.
December 13, 2011 at 3:24 am
If you really want to go down that route, you'll need to verify the T-SQL code can actually be migrated into Oracle (will be "fun stuff" if you're using Service Broker and/or CLR, for instance).
Other than that, there are tools available claiming to be able to convert in that direction.
<SET SARCASM ON>
If it's the same function, why migrate? Can you afford to run Oracle (budget-wise)?
Since it sounds like a business critical system, you might need to get an Oracle consultant involved. The minimum effect: you'll get used to the rates they charge and the quality of service some of them provide... 😉
As a side note: you know you're giving up the help from a supporting community like SSC? AFAIK, there's nothing similar for Oracle (might be for a reason though...).
<SET SARCASM OFF>
December 13, 2011 at 4:37 am
yes, we do have plan to hire a consultant to re-engineer our business process. Not for technical purpose.
so If you know any technical issues (in database) that we might face after migration. please in-light me to write them in my technical report.
December 13, 2011 at 4:47 am
Nobody can guess the potential issues & their complexities unless they analyze your source database. For this simple reason, I asked you to hire a technical consultant.
Just to give you an example. If the stored procedures (SQL Server) have ‘SELECT GETDATE()’ statements, it will fail in Oracle. There may be N Stored Procedure performing this operation so all those modules will fail in Oracle. I can give X more parameters which we should check.
December 13, 2011 at 5:08 am
Like I stated before:
There are tools available claiming to be able to convert in that direction (SQL Server to Oracle).
A google search should help.
Will those tools help you to find potential issues? Most probably.
Is there any tool available that'll guarantee to find all issues? Most probably not.
Can every code be migrated to Oracle automagically? Definitely not.
It becomes even more complicated, if your current solution is heavily bound to SQL Server BIDS.
I second Dev: hire a technical consultant to analyze your current system.
Question aside: Why do you want to move to Oracle anyway?
December 13, 2011 at 5:22 am
LutzM (12/13/2011)
Like I stated before:There are tools available claiming to be able to convert in that direction (SQL Server to Oracle).
A google search should help.
Will those tools help you to find potential issues? Most probably.
Is there any tool available that'll guarantee to find all issues? Most probably not.
Can every code be migrated to Oracle automagically? Definitely not.
It becomes even more complicated, if your current solution is heavily bound to SQL Server BIDS.
I second Dev: hire a technical consultant to analyze your current system.
Question aside: Why do you want to move to Oracle anyway?
‘Tools without Technician’ and ‘Weapons without soldier’, aren’t you suggesting the same? :w00t:
December 13, 2011 at 5:40 am
Dev (12/13/2011)
...‘Tools with Technician’ and ‘Weapons without soldier’, aren’t you suggesting the same? :w00t:
Not sure about the latter, but definitely the former 😀
December 13, 2011 at 5:42 am
we have an app here which supports either Oracle and SQL Server as the behind the scenes DBMS.
I'll be the first to say I do not know how to tune Oracle for performance, but my client, with an Oracle DBA, doesn't appear to be able to either;
the same app, same sample database running with SQL server is at least an order of magnitude faster than Oracle.
There's no direct porting of any procedures or functions to Oracle; even if the procedure is doing a simple select, in Oracle it's going to require a ref cursor....well maybe a simple DELETE procedure might be auto-scriptable , but i'd doubt event hat.
the conversion of all procs and functions is going to take a real DBA a lot of time. the things I know for some things we take for granted, bitwise operations,and built in functions like DATEADD and DATEDIFF,YEAR(), etc , you will need to add your own custom package to use the near identical syntax. that makes porting of some code a LOt easier.
I'm not saying Oracle is bad, as i get to fiddle with it on a daily basis, and it's expanded my skill set, but i am saying that in my experience most agencies would benefit form the other direction...Oracle to SQL instead.
Lowell
December 13, 2011 at 5:48 am
LutzM (12/13/2011)
...Not sure about the latter, but definitely the former 😀
Corrected the TYPO... ‘Tools without Technician’ and ‘Weapons without soldier’... Very Dangerous
December 13, 2011 at 5:52 am
Lowell (12/13/2011)
we have an app here which supports either Oracle and SQL Server as the behind the scenes DBMS.I'll be the first to say I do not know how to tune Oracle for performance, but my client, with an Oracle DBA, doesn't appear to be able to either;
the same app, same sample database running with SQL server is at least an order of magnitude faster than Oracle.
There's no direct porting of any procedures or functions to Oracle; even if the procedure is doing a simple select, in Oracle it's going to require a ref cursor....well maybe a simple DELETE procedure might be auto-scriptable , but i'd doubt event hat.
the conversion of all procs and functions is going to take a real DBA a lot of time. the things I know for some things we take for granted, bitwise operations,and built in functions like DATEADD and DATEDIFF,YEAR(), etc , you will need to add your own custom package to use the near identical syntax. that makes porting of some code a LOt easier.
I'm not saying Oracle is bad, as i get to fiddle with it on a daily basis, and it's expanded my skill set, but i am saying that in my experience most agencies would benefit form the other direction...Oracle to SQL instead.
+100
All agreed except direction 😉
December 13, 2011 at 8:25 am
Oracle is just a whole different world with a different set of capabilities and problems. If you don't know Oracle now, time to learn. You're going to have to change your whole approach to support Oracle. It's just not the same. I'm not knocking it. It's a very functional piece of software. It just functions differently.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 13, 2011 at 11:28 pm
Thanx everybody.
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply