Foxbase to Oracle
Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle
Not sure if Oracle provides one, but another solution is available here: http://www.kumaran.com/xbaseconverter.asp If it is such a small app though - why not just stick it in (dare I say this) something like Access or SQLServer.. -Original Message- [EMAIL PROTECTED] Sent: 30 July 2002 17:09 To: Multiple recipients of list ORACLE-L Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle
Thanks all who replied. I agree that for this app SQL Server might be more suitable. My main concern is the application code that enforces business logic. How do we migrate the source code into the new application without re-rewriting? I will definitely look into the tool recommended by Mike. But if we are to go with SQL Server or Access, what do we do with the application code? Thanks again Dennis Meng Database Administrator Focal Communications Corp. Mark Leith mark@cool-tools To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .co.uk cc: Sent by: Subject: RE: Foxbase to Oracle [EMAIL PROTECTED] 07/30/02 11:28 AM Please respond to ORACLE-L Not sure if Oracle provides one, but another solution is available here: http://www.kumaran.com/xbaseconverter.asp If it is such a small app though - why not just stick it in (dare I say this) something like Access or SQLServer.. -Original Message- [EMAIL PROTECTED] Sent: 30 July 2002 17:09 To: Multiple recipients of list ORACLE-L Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
RE: Foxbase to Oracle
Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:Foxbase to Oracle Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle
Dennis, While I hate doing this on an Oracle list, you might want to consider SAP DB considering your limited budget and requirements. The general product details are here: http://www.sapdb.org/ and you can request a free CD here: http://www.sapdb.org/sap_db_cd.htm. Quite impressive and under-rated if you ask me. ; Good luck. Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farrell, Thomas M.Mr. NGB-ARNG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle
Visual FoxPro has an upsize wizard that can go directly to Oracle. It would still be a lot cheaper to keep it in FoxPro over the cost of Oracle. -Original Message- Sent: Tuesday, July 30, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:Foxbase to Oracle Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle - Thanks
Looks like most of the replies point to VFP. I will present this to my manager. Thanks to all who replied! Dennis Meng Database Administrator Focal Communications Corp. Karniotis, Stephen Stephen_Karniotis@com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] puware.comcc: Sent by: Subject: RE: Foxbase to Oracle [EMAIL PROTECTED] 07/30/02 12:44 PM Please respond to ORACLE-L Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct:(248) 865-4350 Mobile:(248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Foxbase to Oracle
On Tom Kyte's site asktom.oracle.com he had a question about the cost of Oracle vs. SQL Server. The upshot was that Oracle offers some fairly inexpensive options for small applications. Oracle SE with small numbers of users is very inexpensive. You are looking at $1,500 USD for 5 named users. The topic generated quite a bit of discussion and comparison of the two databases. I -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).