November 16, 2007 at 9:17 am
Hello all,
I have to migrate the user database from sql 2000 to sql 2005. The collation sequence is not setup as the default colaltion in the exisiting environment od sql 2000. The database colaltion is
But going forward to SQL 2005 I have to keep the default collaion sequence.
I know I will run into issues? Can anyone tell me which kind of issues I migth face and how to resolve those?
We have the collation specified at column level also on some tables. How do I find that and if there would be any issues then how to resolve.
Even the system databases have the same problem.
I would appreciate your help.
Thanks,
-P
November 16, 2007 at 8:10 pm
Any issues with migration should be flagged by the Microsoft SQL Server 2005 Upgrade Advisor (downloadable from Microsoft). If you haven't run it already, you may want to do so.
With that said, when you say you must keep the default collation, do you mean the default collation for SQL Server 2000 or for SQL Server 2005? Also, you can still specify an alternate collation for databases / columns other than what the master database is set to. Therefore, if you need to retain the collation for the existing user database, you should still be able to do so.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply