I am waiting for project in whcih I need to upgrade sql server 2000 to 2008R2. The main thing is collation going to be changed.
It will be a side by side migration. Apart from this, I do not have any more details).
I plan to do scripting source objects and bcp them to destination.
Can anyone please advise how to do (better option) this upgrade with collation change?