Results 1 to 9 of 9

Thread: migrating data from dataflex 2.3b

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Aug 2019
    Posts
    3

    Default 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.

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default 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.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Feb 2009
    Location
    Queens, NY, NY
    Posts
    7,429

    Default 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! )
    Last edited by Michael Mullan; 19-Aug-2019 at 08:24 AM. Reason: OOps
    Michael Mullan.
    Danes Bridge Enterprises.

    ++++++++++++++++++++++++++++
    There is just today. Tomorrow is a concept
    that is mostly theoretical. -- GM Wylie
    ++++++++++++++++++++++++++++

  4. #4
    Join Date
    Aug 2019
    Posts
    3

    Default 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?

  5. #5
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default 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.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  6. #6
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default 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 DOSBOX or vDOS.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  7. #7
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default 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.
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  8. #8
    Join Date
    Feb 2009
    Location
    Peoria, IL
    Posts
    5,491

    Default 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.
    Chuck Atkinson

    "No matter how confounding the case, Bob Worsley always finds the quaesitum."

  9. #9
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: migrating data from dataflex 2.3b

    That was specifically for date conversion wasn't it? Maybe that's no longer necessary
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •