RE: Oracle Vs Sybase
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: Grant.Allen@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 21 Sep 2004 22:39:06 -0700
Why i asked because in one of the assignments we did we had this problem
with quotes. We tested for all spl.chrs and had problem with quotes. I
wanted to get this one clarified. The first suggestion you gave
(regarding db level parameter) is quite useful.
GovindanK
On Wed, 22 Sep 2004 14:36:03 +1000, "Grant Allen"
<Grant.Allen@xxxxxxxxxxxxxxxx> said:
> > -----Original Message-----
> > From: GovindanK [mailto:gkatteri@xxxxxxxxxxx]
> > Sent: Wednesday, 22 September 2004 13:13
> > To: Grant Allen; DGUPTA@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> > Subject: RE: Oracle Vs Sybase
> >
> > > Ciao
> > > Fuzzy
> > > :-)
> > >=20
> >=20
> > Have you tried converting / transporting data from other=20
> > databases which
> > have single / double quotes in them?=20
> >
>
> Govindan,
>
> Yes, we provide migration facilities to our clients that allow them to =
> move their data freely between Oracle, Sybase, SQL Server and DB2. I'd =
> say we've performed a few thousand migrations like these over the years.
> =
> Once you understand the basic bulk data movement / ETL tools =
> (SQL*Loader, bcp, LOAD), it's easy to programmatically handle things =
> like quotes, ascii control characters, etc. Definitely a case of effort
> =
> up front paying off later.
>
> Ciao
> Fuzzy
> :-)
>
> ----------------------------------
> "Everything you think, do, and say
> was in the pill you took today."
> -- Zager and Evans
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
