l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
April 21: Google Glass
Next Installfest:
TBD
Latest News:
Mar. 18: Google Glass at LUGOD's April meeting
Page last updated:
2003 Aug 01 20:12

The following is an archive of a post made to our 'vox mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox] [OT] Solaris, Oracle, and other painful subjects
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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




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

_______________________________________________
vox mailing list
vox@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.