Our company is attempting to install our warehouse automation project
and we are encountering bug after bug (we have caused 4 MS official
bug reports now) with SQL Server 6.5.
We are now at the point where we are seriously thinking about cutting
our losses and moving to Oracle 7.
Any advice would be helpful, but I have some questions in particular:
- How difficult is the migration? We are using quite a few stored
procedures and a few triggers, plenty of constraints etc. How
different is the DB syntax, and Stored procedure syntax/capability?
- we are accessing the DB from C++ using ODBC, how much of our source
is really going to have to change. (I know that the whole point of
ODBC is that we shouldn't have to do rewriting, but life rarely goes
like it's "supposed to")
- What kind of performance increase/decrease can I expect? We have
about 35 client workstations running win95 on 486s. The server is an
IBM Quad PPro166 (128M (soon 256M) RAM, RAID-5, etc.). We do a
grundle of transactions as near to "real time" as we can get.
- Are we going from the frying pan to the fire? What problems with
Oracle can we expect? The problems we are currently experiencing
mostly arise from MS's goofy handling of SMP. (plus a whole lot more
goofiness in the area of tempdb and allocation and handling of temp
tables within stored procedures)
- has anyone else done a fairly large migration like this? If so,
how did it go?
All help is very much appreciated
-Lee
"It can't rain all the time"
Received on Wed May 07 1997 - 00:00:00 CDT
