Hi there.

I am currently looking at ways of migrating databases to a SAN / SQL Server Cluster environment and you guessed it, the collation on the new Virtual Server is different from the original.

I tried this script out and it works very well with one exception.  On scripting the 'xxxx_Old' database the scripted views were in the wrong order of creation and had to be re-arranged before running and creating the 'xxxx' database.

I have also had a look at DTS copy sqlserver objects task which also seems to do the job.

Any comments on which method is better to use?

Many Thanks for sharing your ideas.

Aardvark