Regarding Pervasive.SQL, as a Pervasive Software Partner, I have customers who have huge mission critical financial applications running on it. One customer has a large production system with some tables over 16 GB each. I am happy to help with additional information regarding Pervasive.SQL and their DataJunction tools offline. My contact information is available on the Witango website.
Sri Amudhanar
Maxys Corporation
703 729 0600
Mike wrote:
Message Hi Jamileh,I've had a lot of success with the Firebird database, which was know as Borland Interbase in its former life before it was open-sourced. It includes more features than MySQL, such as views, stored procedures, triggers, and sequences, and runs on most common platforms. It also includes a JDBC driver that is coming along quite nicely. I've only used this database with my Java application programming, so I can't really speak to its Witango usefulness.PostgreSQL is great, but until recently it was only available for UNIXes unless you used the Cygwin stuff in windows. I think they now have a beta version which installs in Windows natively, and this could potentially work for you as it matures.There's also SAPDB, which I never personally used but which was built to originally support the SAP enterprise applications.All of these are open source.Some Links:Best of luck,Mike
From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 12, 2004 9:48 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: [ot] Databases
Primarily $$$. We run some serious data-crunching apps and need to upgrade our server hardware. We bought new servers, but just discovered that to go over 2G of memory on a SQL server, you must upgrade to SQL Enterprise server at $12K per processor. With 4 CPUs, that's a large chunk o' change that we haven't budgeted for.So we're looking at other db options as one possible solution.-----Original Message-----
From: McElhinny, Greg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 11, 2004 8:55 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: [ot] Databases
Wondering why you are getting away from MS SQL 2000?
From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED]]
Sent: Wed 8/11/2004 6:09 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: [ot] Databases
We run all of our databases on MS-SQL2000 or MS Access. (I've been slowly working towards moving all the Access databases to SQL.)
We're considering changing database servers. Under discussion so far are Oracle and MySQL. The campus has a site license for Oracle, so purchase cost isn't much of a factor. I've been researching MySQL and it looks a bit limited (no stored procs yet, no scheduler/jobs/etc.), but the new version due out next year has a several of those features added (although I'm not sure *when* in 2005 it'll be available).
How difficult is it to switch to MySQL or Oracle from MS-SQL? I realize there will be some conversion issues in any db migration (i.e., SQL language variations, datatype variations, etc.), but there appear to be tools available to assist with that. I'm mostly concerned about the learning curve and how long it would take to come up to speed on a new db.
Does anyone have experience with such a migration, or experience with using more than one of these dbs? Any info or advice would be most appreciated!
Thanks.
jamileh
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
-- ****************** Internet Email Confidentiality ***********************
Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Maxys Corporation or its affiliates shall be understood as neither given nor endorsed by it. **************************************************************************
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
