Arthur Fuller
fuller.artful at gmail.com
Mon May 14 09:02:47 CDT 2007
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 > >