Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Upgrading from 6.5 to 7.0 with different sort orders.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-29 : 21:44:58
Daniel Benevides writes "Hi there...

I'm trying to upgrade a SQL Server 6.5 database that's using dictionary order, case insensitive sort order to a SQL Server 7.0 that will be using dictionary order, case insensitive, accent insensitive sort order, under the same codepage.
The Upgrade Wizard alerts that the data migration may get corrupted if this is done.
It is not just a matter of migrating and reindexing the database??? This is not already done by the Upgrade Wizard?

Thanks for your help,

Best Regards,

Daniel Benevides."
   

- Advertisement -