J
James Palmer
Guest
Hi Rob, As you're doing a platform change and a version upgrade at the same time you are going to likely find some interesting issues. To do the platform change you will need to do a binary dump and load of your data. There is no other way. I'm pretty sure you can dump and load across versions, but you'd be best waiting for someone to confirm this. Whilst you're in the process of upgrading you will want to look into Type II storage areas. All of your data should be in Type II areas after the move as this will provide significant performance benefits. I don't mean to teach you to suck eggs, so I apologise if you've heard this before. You should analyse your table based on similarity in mean record size (you can get this from a DBANALYS), and not business use. Your top 2 or 3 tables (usually) based on usage should be in their own areas too. I'm not expressing myself too well, so have a look at community.progress.com/.../3616.aspx Before doing anything you should take a full backup of the database. After you have finished you should take a full backup of the database too. As for the Language Reference, I'm not sure that is produced any more. The help files are a lot more useful now though so the reference is probably pretty obsolete. There's a starter for ten. Others will likely be along with more in depth advice. I'm just a beginner with DBA tasks 
Continue reading...
Continue reading...