We want to re-design a warehouse database that has too much redundant and unused data and also excessive amount of inefficient stored procs (many using cursors).(it is causing high refresh times and also more disk space usage)
The current DB is in SQL 2000. Is it best
1)try to redesign the database in the current schema, and rewrite the procs
2)or migrate to SQL 2005/8 and design afresh and write procs from scratch, after the schema changes are done.?
which one would you recommend? which would take more time to program and test? any other options?