07:DML

[Alain Stouder]

We are also moving to postgresql, away from datafiles, primarly  
because i
we have to write/maintain the repair tools ourselves instead of having  
Omnis do the job (the default tools are not smart enough at least in  
O7).

The added advantage with postgresql is the Oracle compatibilty.

---
Learn something new everyday!

On 14 janv. 2010, at 18:47, "John Hosmer" <john.hosmer at lyonscars.com>  
wrote:

> My experience has been that if you experience a problem with a df1  
> (df2,
> etc, and nearly any data related problem not obviously code  
> induced), that
> the only reliable method of fixing this problem is to export (tab or  
> comma)
> delimited, and re-import.  There may exist problems that omnis  
> diagnostics
> are not finding.
>
> I have over the years tried many different things, including omnis's  
> own
> repair processes, but only to find that later, problems continued to  
> arise,
> and thus wasting valuable time.
>
> For our application we at one time had nearly 40 df1's, and many  
> df2's etc.
> In each case of corruption in the last 20 years or so, ultimately,  
> we did an
> export, created new df1's, 2's, etc, expanded them to appropriate  
> size, and
> then import (07 application only, we are not in studio yet).
>
> Over the last 5 years we have been migrating to postgres, and have  
> had no
> corruption there, though there have been odbc issues to resolve.   
> But for
> the most part, it is worth the effort.
>
> john
>
> -----Original Message-----
> From: omnisdev-en-bounces at lists.omnis-dev.com
> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of
> wizardcompserv at aol.com
> Sent: Thursday, January 14, 2010 11:29 AM
> To: omnisdev-en at lists.omnis-dev.com
> Subject: 07:DML
>
> hi all
>
> I am hoping someone can help me.
>
> I have a customer with a 6 segment database - they have been having  
> some
> problems so I have today got a copy of the database.
>
> By going through the software I can see the data and get at the  
> information
> but ..... if I do a Check data or Examine data file some of the file
> names  are repeated many times and a lot of the names are missing -  
> is there
> a
> way out  of this - or am I in for a complete export and import?
>
> Many thanks for your help
>
> Regards
> Wendy Osbaldestin
> Wizard Computer Services
> Tel:  01260271647
> Mobile: 07740541021
> Web Site: _www.wizardcompserv.co.uk_ (http:// 
> www.wizardcompserv.co.uk/)
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.432 / Virus Database: 270.14.137/2617 - Release Date:  
> 01/14/10
> 07:35:00
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com