June 7, 2008 at 12:00 am
Hi all,
I am having an .Net application with its back end as SQL Server.
Now we want to work with multi DB support such that the application will also work with ORACLE.
Now I have to convert all the SQL scripts to ORACLE scripts.
Is there any easy method in order to perform this operation?
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
June 9, 2008 at 4:21 am
Usually such questions are better to ask on target platforms, because they like converts to them much more than converts from them 🙂
One of the tools is Migration workbench.
And here is the forum for questions.
However you should start with the fact that all databases are different as outlined a bit in this very forum thread and understand that direct translation not always is possible and hardly ever lead to optimal results and performance.
Gints Plivna
Gints Plivna
http://www.gplivna.eu
June 26, 2008 at 2:21 pm
If you intend to completely re-engineer or modify your .NET application so that it uses Oracle instead of SQL Server as back end then you need to modify the .NET code too in addition to just converting the T-SQL to PL/SQL
Check the .NET Developer Center on Oracle site. It may help you.
http://www.oracle.com/technology/tech/dotnet/index.html
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
June 26, 2008 at 10:13 pm
Dear Friend,
The link is broken and unable to get into the site.
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
June 27, 2008 at 1:12 am
If you look closer at it you'll find that it contains <br>, which obviously is redundant.
Gints Plivna
Gints Plivna
http://www.gplivna.eu
June 27, 2008 at 1:17 am
Dear Gints,
Thanks for your information.
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
June 27, 2008 at 9:09 am
This is written from the other perspective, but you still might find it useful:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorcle.mspx#EWBAI
Mike
July 1, 2008 at 12:44 am
U can have a look at such links
http://www.programurl.com/swissql-sql-server-to-oracle-migration-tool.htm
NOTHING IS IMPOSSIBLE WITH SMART WORK🙂
July 3, 2008 at 2:08 pm
HI
My best advice is to use one of the following options to migrate data between SQL Server and Oracle:
Migration Workbench
You can use Oracle Warehouse Builder (OWB) or any ETL toolset to move data between non-Oracle and Oracle databases.
Unload data into CSV flat files from the non-Oracle source and load it into Oracle using SQL*Load, the Oracle external table feature or any ETL toolset (like OWB, Informatica, etc.).
Thanks -- Vj
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply