Results 1 to 6 of 6

Thread: Updating Deployment

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Updating Deployment

    VDF 12 Windows App.

    Made some changes including adding new columns to existing embedded databases. When I update the client machine, besides the .exe file which files do I need to update on the client machine? Very new to VDF so assume I know next to nothing. I have made changes to the program before and to reports but this is the first time changing tables.

    Thanks,

  2. #2
    Join Date
    Feb 2009
    Location
    South Florida
    Posts
    3,861

    Default Re: Updating Deployment

    Obviously you need to make all the same changes to the deployed database, either manually or automated
    Michael Salzlechner
    StarZen Technologies, Inc
    http.://www.starzen.com

    Development Blog
    http://www.salzlechner.com/dev

    DataFlex Package Manager (aka Nuget for DataFlex)
    http://windowsdeveloper.com/dfPackage

  3. #3

    Default Re: Updating Deployment

    Quote Originally Posted by starzen View Post
    Obviously you need to make all the same changes to the deployed database, either manually or automated

    I wish it was obvious. So grab the client data folder, insert into my build, change the tables and reinsert into the customers build?

  4. #4
    Join Date
    Sep 2016
    Location
    São Paulo - Brazil
    Posts
    294

    Default Re: Updating Deployment

    Hi Tremain,

    Not quite. . .

    I will be wary of the answer because, I don't want you to lose information from your production base:

    The best is that you understand well and I hope that google does a good job of translating:

    If your base is
    embedded
    DATAFLEX:

    When you change the structure the following files are involved:
    *.DAT (Data Mass)
    *.HDR (This depends on one setting. The default should be YES and refers to Header integrity)
    *.VLD (This depends on a setting if the file is working in compressed mode, ie the large mass of * .Dat data comes to a halt here.)
    *.K* (These are the search indexes)
    *.TAG (This contains the name of the fields)
    Filelist.CFG (Contains list of Bases and Descriptors)

    If you use another type of database, SQL, DB2, etc., disregard the above and another colleague will help you.

    I use the
    embedded
    database DATAFLEX.

    I'm guessing that you have distinct areas, namely:

    - One is development.

    - Another is production.

    Given this scenario, you CANNOT COPY the development bank (which may be, out of date) for production,unless you made a copy of this production for development.In the meantime, no one should be using the production environment and this is a terrible procedure, so I don't imagine that you did it!

    So once you have tested everything in development, I usually do:

    1) Put the system up for maintenance (This is a flag, which I control in Sysfile), because I don't want anyone to use or try to use the system while I'm trying to change something.
    If you do not have similar control, then you rename the production .EXE by making sure no one is using the system / database or removing permissions from the network (this can be complex), or you will be deploying out of time.

    2) Make a general backup of the production area, because if something goes wrong it can save you.

    3) Similarly, as you made the development base change through DBBuilder, you must repeat the same procedures in the production area (unless you have made a conversion program).

    4) Finally, copy your new .EXE program

    If you got it. . . good luck !

    Best Regards

    Edgard L. Paneque

  5. #5
    Join Date
    Feb 2009
    Location
    South Florida
    Posts
    3,861

    Default Re: Updating Deployment

    no you either have to do the same updates top the data files manually the same way you did it on your dev system or write code to update the database or use an automated tool to update the database
    Michael Salzlechner
    StarZen Technologies, Inc
    http.://www.starzen.com

    Development Blog
    http://www.salzlechner.com/dev

    DataFlex Package Manager (aka Nuget for DataFlex)
    http://windowsdeveloper.com/dfPackage

  6. #6
    Join Date
    Feb 2009
    Location
    Goteborg, Sweden
    Posts
    2,922

    Default Re: Updating Deployment

    Maybe this could be useful for you?

    https://www.rdctools.com/the-database-update-framework/
    Nils Svedmyr
    RDC Tools International
    www.rdctools.com

    "One morning I shot an elephant in my pyjamas. How he got into my pyjamas I'll never know"
    Groucho Marx

Posting Permissions

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