View Single Post
Old 28th September 2009, 07:51
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
part check list

Some of the points to take care off
1. Separate harddisks for logs and dbf files to ensure good performance
2. Good memory for sql server
3. Jobs to create online backups and create /update stats
4. Mapping baan users to sQL,db creation ,assognment of tables to database
5. Installation as per baan guide like sort mode , db ownership /roles
6. Configuration of msql parameters
7. Proper table sharing across companies to avoid extra table creations
8. If possible , leave archive companies in Oracle only to keep SQL lean and mean
9. Availability of msql commercial function in baan license else re-validate the same .
Reply With Quote