I need to migrate a database server from version 2000 to 2008. I had to rewrite more than 300 stored procedures to reconcile them with the 2008 version
But now, i need to migrate a server.
I thought the following steps:
- Uninstall the 2000 version
- Install the version 2008
- Atachi the database
- Create jobs
- Create the logins and users
- Create other objects (application roles, linked server ...)
- Reindex all the database
- Run sp_recompile for all tables
Can anyone give me a hand? agree? Has another plan?
I need criticism and suggestions.
Thank you very much.