Automatic backup of application objects

sh
sh Member Posts: 24
edited 2006-10-24 in NAV/Navision Classic Client
Hello there,

we have trouble with our regular backup of our development server (~200 Navision DB servers (native) and over 1,5 TB of databases).
Until now, the backup is scheduled on a daily basis (direct backup of all databases on tape). Unfortunately this is very time consuming and the backup is still running in the morning.
As this is only a development environment, we don't need the whole database (companies etc), but only the application objects.
Now we are searching for a tool/way to extract/backup the application objects of each database automatically. Anyone have done this before?
Btw, we are searching for a similar solution for our SQL development databases, too :-)

Any help would be appreciated.

Comments

  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    What you can do is do all development on SQL and only backup the Object table.
  • sh
    sh Member Posts: 24
    Miklos Hollender wrote:
    What you can do is do all development on SQL and only backup the Object table.

    Not possible because the dev environment for each database has to match the customer's installation. :-(
  • garak
    garak Member Posts: 3,263
    For this case i've written an application (it was in vb, vbscript or c# i must search it) that starts the client, open the object designer, markes all modif. objects an export this objects to an special folder. Afte export, it closed the navision application.

    But the "problem" was: it must an user loged on in windows. No screensaver should be activated and the windowssession should not be blocked (Strg + Alt + Entf).

    I must take a look to find the application. When i found it, submit it.

    Regards
    Do you make it right, it works too!

Categories