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
