Can anybody discuss about data migration process from SQL 2000 to SQL 2008??
There are many considerations and the fact that you are migrating the data(base) to 2008 probably also means a server move. This is a good opportunity to review the database schema, permissions, code, maintenance and recovery plans. Here are a few ideas to get your thought process started.
The point is there are many new feature in 2005 and 2008 which affects the way you design, secure and administer a database. Don't just "bring over" the old database and call it good because it's on a 2008 instance. This is the perfect opportunity to do (or redo) it right.
No one has followed this question yet.