Re: Which Version?

Having done this on several occasions,
there are really several problems here.

1. Data Volumes (record counts) from SQL into Oracle; 5G on SQL is probably not 5G on Oracle (may be more)
2. "BITS" and other "funny" datatypes don't convert directly --> schema revisions
3. Platform on which to move the data.
4. Conversion of stored procedures/triggers, etc into PL/SQL. SQL's "language" is by no means rich.
5. Platform on which to "develop" the conversion.
6. Performance. (Oracle "like" considerably more "workspace" [temporary tablespace, index tablespace] than SQL)

Don't waste your time with Personal Edition or the likes.

If you are converting a small volume of data and a few procedures, consider MS-Access as go-between to move the data.

If you are converting a large volume of data and many procedures, then obviously its valuable, go get a decent NT box, get plenty of extra disk (you'll want to transform the data in chunks rather than one "swell foop") and get a decent backup strategy (25G IDE's are pretty cheap)

...luck to ya

Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:380F0FB9.D7F11A93_at_edcmail.cr.usgs.gov...
> Oracle Personal Edition is for one workstation. It lets you have a
> database on your workstation that you can access. But it doesn't work
> (or work well) for more than one user.
>
> Oracle Lite is for small computers like Palm pilots. It's a scaled down
> version that fits into a small footprint. This is ideal for someone in
> the "field" who needs a database. They come back to the office and move
> data to there bigger database. For instance, someone from the gas
> company can come by your house and read your meter. She can put your
> meter reading into her Oracle Lite database. When she gets back to the
> office, she can download the data to the company's bigger database
> system.
>
> I doubt that these are the products you want to use. But I don't know
> exactly how you want to use an Oracle database. Since the application
> was written for MS SQL Server, you'll probably want Oracle Server or
> Oracle Enterprise Edition. Enterprise Edition is a bigger version of the
> Server product. Which one you'll need can probably be best determined by
> an Oracle sales person. With Oracle Server residing on your company's
> server, you'll just need to install the client products so that your
> developers can connect to the database.
>
> HTH,
> Brian
>
>
> Paul wrote:
> >
> > I wonder if anybody can help me .. a company I am working for has just
won a
> > contract to port a database application written in SQL Server 6.5/7.0 to
> > Oracle. Unfortunately, we do not have any Oracle software at all and we
need
> > to purchase some! Our working arrangements (2 developers working from
home)
> > mean that we do not require large amounts of connections. However, the
> > software should be able to operate on Windows NT 4.0 and hopefully
Windows
> > 98 laptops. Does such an animal exist? I have heard conflicting reports
> > about what we require (Oracle lite / Oracle Standard Personal edition
etc)
> > and was wondering if you knowledgeable people knew a definitive
answer...
> >
> > Thanks in advance!
> >
> > Paul prowen_at_bigfoot.com
Received on Thu Oct 21 1999 - 17:47:11 CDT