I have been asked to look into porting an ASP system to an Oracle DB.
Currently, they are using SQL Server and retrieving data via stored procs. I
know how to migrate the DB, but what work will have to be done to the ASP code
to be able to access the Oracle DB as well as the SQL Server DB?
--
Michael Rothwell

"Michael Rothwell" <marothwell@yahoo.com> wrote in message
news:bf4pv1$b8d13$1@ID-131223.news.uni-berlin.de...
> I have been asked to look into porting an ASP system to an Oracle DB.
> Currently, they are using SQL Server and retrieving data via stored procs.
I
> know how to migrate the DB, but what work will have to be done to the ASP
code
> to be able to access the Oracle DB as well as the SQL Server DB?

It depends

You will presumably need to rewrite the stored procs with Oracle equivalents
return a ref cursor for a recordset and at the very least change the oledb
provider and install an Oracle client on the web server.


--
Niall Litchfield
Oracle DBA
Audit Commission UK

Hello, After reading the other 2 replies, I was thinking about the
autonumbering in SQL Server and the Sequences in Oracle. I had to chg a
fair amount of ASP code for this conversion. Please review that possibility.
for me in 2002, it was a little bit of a challenge. For more if requested.

PS: the 2 other replies are excellent ideas.

Michael Vick

"Niall Litchfield" <n-litchfield@audit-commission.gov.uk> wrote in message
news:3f1680b7$0$15037$ed9e5944@reading.news.pipex. net...
> "Michael Rothwell" <marothwell@yahoo.com> wrote in message
> news:bf4pv1$b8d13$1@ID-131223.news.uni-berlin.de...
> > I have been asked to look into porting an ASP system to an Oracle DB.
> > Currently, they are using SQL Server and retrieving data via stored
procs.
> I
> > know how to migrate the DB, but what work will have to be done to the
ASP
> code
> > to be able to access the Oracle DB as well as the SQL Server DB?
>
> It depends
>
> You will presumably need to rewrite the stored procs with Oracle
equivalents
> return a ref cursor for a recordset and at the very least change the oledb
> provider and install an Oracle client on the web server.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>

Daniel Morgan wrote:

> Michael Rothwell wrote:
>
>
>>I have been asked to look into porting an ASP system to an Oracle DB.
>>Currently, they are using SQL Server and retrieving data via stored procs. I
>>know how to migrate the DB, but what work will have to be done to the ASP code
>>to be able to access the Oracle DB as well as the SQL Server DB?
>>--
>>Michael Rothwell
>
>
> You do understand you will need to rewrite every proc to have a REF CURSOR as an
> OUT parameter?
>
> If connecting via ODBC and all SQL is in the procs ... essentially nothing need be
> changed. If the SQL is being
> passed through ... everything needs to be rewritten.

Yes, I am aware that I would have to re-write all the procs, and I had counted
on that.

All SQL is in the procs, so what I dont know is how ASP is written to make these
calls. After I change the procs and the ODBC connection, what needs to be done
to the ASP code?

>
> And if you don't take multi-versioning and the Oracle transaction model into
> account you will just make a huge,
> unscalable poorly performing mess.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/e...ad/oad_crs.asp
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>

--
Michael Rothwell
Oracle/Sql Server DBA/Developer/Web Enabled DB's
HTTP://www.bdbinc.com/