I would chime in that if you haven't changed rules for constraints where applicable, you should do that ASAP. Your life will be less complicated. My internal database is not huge, but my rules table has only 5 rows.
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Javier > Valencia > Sent: Saturday, January 04, 2014 12:38 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Converting Rules > > Ronald, > > > > I would strongly suggest that you also do and UNLOAD ALL and rebuild of > your database BEFORE you start the conversion and fix all the problems > BEFORE the conversion. > > If you have clean database, chances are the conversion will go > smoothly; if you have problems, the conversion will only magnify them. > > > > Javier, > > > > Javier Valencia, PE > > O: 913-829-0888 > > H: 913-397-9605 > > C: 913-915-3137 > > > > From: [email protected] [mailto:[email protected]] On Behalf Of Ronald > C Peterson > Sent: Friday, January 03, 2014 6:41 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Converting Rules > > > > This was all my fault. I failed to do the unload and reload after the > conversion. Thanks for taking the time to check this out. I was in to > much of hurry and hadn't read the full conversion guide. > > Ron > > > > > > On Fri, Jan 3, 2014 at 6:25 PM, Javier Valencia > <[email protected]> wrote: > > What procedure are you using? > > Before I convert I normally run: > > OUTPUT All.bu > > UNLOAD ALL > > OUTPUT SCREEN > > And then recreate the database making sure that there are no error or > conflicts. > > If I recall correctly, when rebuilding the database, the file created > above creates the tables first, loads the data and then recreates the > rules. If you are using this process, it is possible that your data has > conflicts and hence the rule(s) cannot be created. > > For example if you are creating a unique index but the column has > duplicates, the rule will not be created. > > The procedure above should allow you to clean your database and once > you can rebuilt it without any errors, then your conversion will likely > go through without any problems. > > > > Javier, > > > > Javier Valencia, PE > > O: 913-829-0888 > > H: 913-397-9605 > > C: 913-915-3137 > > > > From: [email protected] [mailto:[email protected]] On Behalf Of Ronald > C Peterson > Sent: Friday, January 03, 2014 3:55 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Converting Rules > > > > I am converting a 6.5++ database to 9.5 32 bit and the rules are not > converting properly. The tables referenced in the 9.5 rules are not > correct. Can I unload the sys_rules table from the 6.5 version and then > reload them into the 9.5 after deleting the improperly converted ones? > > Ron Peterson > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
