If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Other PC Databases > DBMS migration - help needed.

View Poll Results: Is this effort worhwhile?
Yes 2 100.00%
No 0 0%
Donno 0 0%
Multiple Choice Poll. Voters: 2. You may not vote on this poll

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-11, 13:19
logamuthu logamuthu is offline
Registered User
 
Join Date: Oct 2011
Posts: 5
Question DBMS migration - help needed.

This may be an unusual request.

I need help to migrate

from my old DBMS - MSDOS based 16 bit Foxpro for DOS v.2.5 a supported by Microsoft Qbasic 1.1 for Data Entry Operator's Interface running on 8086 from 20 years ago to the more recent P3 and P4

to my recently acquired Dell Alienware Aurora ALX running Windows 7 Ultimate 64 bit.

My requirements are simple - I do not need sophistications like web publication, networking and servers, multiuser, relational DBMS etc.,

I need only a flat-file DB to create simple data tables, browse, display, edit, append, delete, pack records and fields whose value will be mostly date,
character and numeric with facility for simple querying within the table - no cross-querying - no maths inside the cells, no forms,images,multimedi etc., - data addition etc., happening in very small volumes (number of fields in a record will not exceed 100 and number of records per table less than 200.) and additions about ten records per day -by only one person - me - in only one PC.,

I have lots of Foxpro 2.5a apps to export data from .dbf files to .dat (?CSV)files usable in qbasic 1.1 and data entered in qbasic to be imported into .dbf files of Foxpro.

I need to interface with a Printer (controllable from within the DBMS -like set printer on/off) to print reports generated.

The new software configuration should work seamlessly in my Dell Alienware Aurora ALX running Windows 7 Ultimate 64 bit and/or an assembled PC with P4running Windows XP Professional - without my having to do lot of recoding of apps/programs.

In summary, I need guidance for selection of a currently available DBMS to effect a simple migration from Foxpro 2.5 a to a newer 32/64 bit DBMS without being an overkill by way of cost, work involved etc.,

I can give more details and even screenshots of my current work (this form has provision for that).
Reply With Quote
  #2 (permalink)  
Old 10-27-11, 16:04
jrbbldr jrbbldr is offline
Registered User
 
Join Date: Nov 2002
Posts: 49
"In summary, I need guidance for selection of a currently available DBMS to effect a simple migration from Foxpro 2.5a"

The primary question which comes to mind, is - Do you want to migrate the applications or just the data?

If the applications then, for the most simple and expedient migration, I'd recommend one of the Visual Foxpro versions (VFP9 would be preferred, but you can look for the older versions on eBay or elsewhere) since the majority of the existing application code and the existing data could be used basically "as is" in the updated VFP language. And they run fine in XP Pro and in Win7 (albeit configured as a 32-bit application).

"I need to interface with a Printer"
In VFP, 'talking' to printers is handled easily through the Windows OS.

Note - in OLD FP report code methodology using @Row,Col SAY <something> this sometimes leads to orientation problems as new printers may have different configurations. However this can be resolved with changing the reporting code methodology (not too difficult).

If you only want to migrate the data for use with some other application(s), then there are a variety of ways to export the data into other formats (e.g. CSV, XLS, TXT, etc.) using the Foxpro COPY TO command and the appropriate options so that the data could be read into other MDBS systems where the applications would have to be re-created from scratch as needed.

Good Luck
Reply With Quote
  #3 (permalink)  
Old 10-27-11, 18:20
logamuthu logamuthu is offline
Registered User
 
Join Date: Oct 2011
Posts: 5
DBMS migration - help needed

Thanq jrbbldr!
Shall revert to you for more help!
Reply With Quote
  #4 (permalink)  
Old 10-28-11, 17:15
kitaman kitaman is offline
Papabi's friend
 
Join Date: Sep 2009
Location: Ontario
Posts: 629
I added the following lines to a Foxpro 2.6 Unix (DOS) program to run it on Visual Foxpro version 6.
Code:
set procedure to visa06  *(this prg)  
#define window one from 0,0 to 50,220 font 'Courier', 16
#activate window one 
#set color to +W/R
do mainmnu
#deactivate window one
return
procedure mainmnu
......
New lines are marked with # which is not part of the code.
Depending on your screen resolution you may want to adjust the font size; 16 works well with 1024x768.
By setting the font to Courier, the original column row settings remain.
*******************
I voted yes in your poll because I believe in evolution not revolution.

Last edited by kitaman; 10-28-11 at 17:20.
Reply With Quote
Reply

Tags
database conversion

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On