Pervasive
Sign in | Join | Help
in

create datafiles by DDF

Last post 05-27-2008 9:16 AM by BtrieveBill. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 05-26-2008 7:39 AM

    create datafiles by DDF

    Is there a possibility to create matching datafiles if have nothing more than the DDF?

  • 05-26-2008 4:44 PM In reply to

    Re: create datafiles by DDF

     Sure.  With PSQLv10, right-click the table, then click Edit.  Select the SQL tab, and copy off the SQL text.  If the PCC doesn't allow you to do this, then use the DDF Builder -- I know that one of them does.

    When you have the SQL text, run the CREATE scripts to create the table.  (You may need to drop the table first.)

    Caveat: Not all DDF definitions can be created via this method, especially tables that use LSTRING or NOTE data types.
     

    Bill Bach
    Goldstar Software Inc.
    www.goldstarsoftware.com
  • 05-27-2008 1:16 AM In reply to

    Re: create datafiles by DDF

    Thanks Bill. This will be a possibility. But it is a bigger DB with about 100 tables, so it will be a mass of work.

    Do you know any tool which can create all tables for existing DDF in one process?

  • 05-27-2008 9:16 AM In reply to

    Re: create datafiles by DDF

    There is no tool available that *I* am aware of.  I've written a LOT of tools over the years, but creating Btrieve files from DDF's has never been one of them.  In 99.99% of cases, either the Btrieve files existed before the DDF's, or the Btrieve files and DDF's are created at the same time.

    I suppose it would be possible to create a tool to do so, but it would likely take some time to build one.  If you REALLY need it, let me know via EM, and we'll see if we can come up with a reasonable cost... 

    Bill Bach
    Goldstar Software Inc.
    www.goldstarsoftware.com
Page 1 of 1 (4 items)
© 2008 Pervasive Software Inc. All Rights Reserved.