[vox] [OT] Solaris, Oracle, and other painful subjects

[Tim Riley]

Richard Crawford wrote:

> Now that we have successfully upgraded our website from WindowsNT/IIS to
> Solaris9/Apache, we're facing the much more daunting task of upgrading our
> database from MS-SQL Server 2000 in WindowsNT to Oracle9i on Solaris 9.
>

Good news!

>
> Has anyone out there done something like this?

Export MS-SQL tables to delimited files, then use Oracle's sqlload to import
them.

You'll have load problems if there are any characters
in any of the tables that are the delimiter character. So, I recommend
using the '^' as the delimiter if MS-SQL allows.

Sqlload defaults to expecting quote-comma- delimited
files. This might load special characters OK, but I'm not sure. For example,
this might not load:
'Tim','O'Riley'
but this probably will:
Tim^O'Riley

>  Does anyone have any tips
> or suggestions for resources I could be looking at or reading?  Favorite
> booze that I could be chugging while trying to pull this off?
>
> Thanks in advance.
>
> Sliante,
> Richard S. Crawford
>
> http://www.mossroot.com
> AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford
> MSN: underpope@hotmail.com
> Howard Dean for America:  http://www.deanforamerica.com
> "It is only with the heart that we see rightly; what is essential is
> invisible to the eye." --Antoine de Saint Exupéry
>
> _______________________________________________
> vox mailing list
> vox@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox