[dba-SQLServer] What have I done?

Just a note: There is a real demand for Oracle DBAs. If you have experience
as well in Oracle the amount that can be demanded for wage/contract work can
go over the moon. A local Oracle instructor teaches 3 months a years and
works on contract the rest. He contracts out, states side, at $200.00 per
hour plus bed, board and transportation. A good Oracle DBA can be an
expensive investment.... but as I understand it well worth it.

Just a comment
Jim    

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Monday, May 14, 2007 7:03 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] What have I done?

I second and third that emotion about having Oracle DBAs. If your firm has
not budgeted for this, they are in for a rude shock. It is much more
necessary on Oracle to have a DBA than on SQL Server, where it is also
necessary but less so in the sense of life-or-death.

That aside, Oracle has a wizard that can migrate Access data to Oracle and
it ought to handle almost every data-type transformation required. I have
used it a few times, not tested it exhaustively with trick questions, but it
worked just fine for me.

Arthur


On 5/13/07, Gary Kjos <garykjos at gmail.com> wrote:
>
> I'm hoping your company either already has or will be hiring one or
> more database administrators for this Oracle database?  Or is that to
> be your baby too?  If so, I would get yourself into Oracle DBA classes
> asap. Lots and lots of information is available at Oracle.com website.
> Lots of downloadable software and documentation in pdf format. If you
> do have DBA's you need to get to know them. They are your friend.
>
> Good luck. You can do it!
>
> GK
>
> On 5/13/07, Elizabeth.J.Doering at wellsfargo.com
> <Elizabeth.J.Doering at wellsfargo.com> wrote:
> > Help!  This has been making my stomach upset all weekend.
> >
> > In a meeting on Friday afternoon, I apparently agreed to do the
> > following:
> >
> >        Plan is to have Elizabeth Doering to build the initial analytic
> > data load then we move it into production in the new shared Oracle
> > database.
> >
> > What the heck did I agree to?  This won't go into production until early
> > next year, so I have time to learn something about Oracle in the
> > meantime.  I have built what will be the production database, no
> > problems there, thanks to the help of this list, but the fact of moving
> > the data to Oracle is freaking me out just a bit.  I can build a script
> > that would move the data from one SQL Server 2005 database to another,
> > but what changes when the destination is Oracle?
> >
> >
> > Thanks,
> >
> >
> > Liz
> >
> >
> > Liz Doering
> > elizabeth.j.doering at wellsfargo.com
> > 612.667.2447
> >
> >
> > "This message may contain confidential and/or privileged information. If
> > you are not the addressee or authorized to receive this for the
> > addressee, you must not use, copy, disclose, or take any action based on
> > this message or any information herein. If you have received this
> > message in error, please advise the sender immediately by reply e-mail
> > and delete this message. Thank you for your cooperation"
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
>
> --
> Gary Kjos
> garykjos at gmail.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com