migrating data from dataflex 2.3b
Ive have seen some other posts for migrating from old version of dataflex but I'm none-the-wiser.
is there a utility that allows me to export dataflex database to CSV or output file?
I can't find any recent documentation on utilities like dfquery to understand if they can be used?
or can I write a simple dataflex script to dump files?
any help would be appreciated.
Re: migrating data from dataflex 2.3b
PwAct,
DFQuery is the tool to be used to extract the data to CSV. It works pretty easy, point to a table and select all columns you want to have (to export) and save the output as file (not as source).
Another way it to use DataPump, this can convert DataFlex data to MSSQL (once or at a scheduled date and time)
A third way would be to purchase DataFlex Reports and use this to export to CSV or Excel
An export can be programmed as well. In fact I have a DataFlex application (not in 2.3!) which can write a small application to export all tables listed in the filelist. You would need to have a newer version of DataFlex to compile and run this.
Re: migrating data from dataflex 2.3b
@ pwact:
Or you can hire it done.
IF you send me an email to mwpmullan at gmail.com we can talk and I'll give you a quote, or some directions.
MM.
(oops replied to wrong post! )
Re: migrating data from dataflex 2.3b
Thanks for the reply, is there a simple guide for the dfquery syntax, when I execute it flashes something and quits.
ie how do I perform a simple query and export?
Re: migrating data from dataflex 2.3b
Something is wrong with your install - as it should come up with a list of tables. Is it installed in the folder where your DAT files reside?
It's pretty straightforward - choose the file, choose the fields, choose method for output.
Re: migrating data from dataflex 2.3b
Are you trying to convert the 2.3 tables to the later 3.0 version so that they'll work with Visual DF? If so you don't need to do anything, just open them in dbBldr or the Studio and they'll automagically convert. I didn't see anything here about needing to convert to SQL so am not sure why you want to dump your files -- could be for some other totally valid reason but you didn't say.
Re: migrating data from dataflex 2.3b
PwAct,
Are you trying to run DFQUERY from Windows Explorer? If so, that won't work. And starting CMD does not help you either on a 64bit OS. You would need a shell like [URL="https://www.dosbox.com/"]DOSBOX[/URL] or [URL="https://www.vdos.info/"]vDOS[/URL].
Re: migrating data from dataflex 2.3b
If they are really old 2.3 data tables you might even need to run Conv2000 I remember I had to do this for a project. And as Vincent says you will need DOSBOX or vDOS to run it.
Re: migrating data from dataflex 2.3b
That was specifically for date conversion wasn't it? Maybe that's no longer necessary