mitra.zaimi (7/1/2010)
would you send me a link to show how to script against master database ( in sql 2000 ) to collect data and then restore it to sql 2005 or sql 2008
Errrr... Links to script? Script data?
To script most objects in SQL 2000 you can Use Enterprise Manager, Right Click and select generate script.
However if you are asking questions like this I would seriously consider asking someone with more experience to migrate the system from SQL 2000 to SQL 2005 or 2008. This is not really a task for the faint hearted. A number of features are being depricated and you could end up with serious issues.
Have you at least used the Upgrade Advisor to check that the databases can actually be upgraded?
Also do you want objects or data? Besides things like logins, linked servers and the like, you shouldn't have anything in Master that you need to migrate to the new server.
Leo Miller
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.