September 10, 2003 at 4:34 pm
I want to change the sort order of a SQL 7.0 database from case sensitive (51) to default case insensitive (52). I also want to migrate it to a new SQL 2000 server installed with default sort order.
SQL 7.0 will not allow a backup of a database with a different sort order than the system databases to be restored. However, on my test 2000 server (installed with default sort order = 52) I was able to restore the 7.0 database, which appears to have both upgraded it as well as changed the sort order. Is this a legitimate operation?
Thanks,
Neil
September 10, 2003 at 4:44 pm
To change the sort order in 7.0 you have to reinstall and I don't believe that will update the current databases. Research this because I am not 100% on this.
When you get to the 2000 installation you can change the collation / sort order on the database and tables which will help. Beware because when you change the collation on the database it does not update existing objects only new objects. The only way to get a full collation change to match the server is to recreate database and structures on the 2000 installation and then import the data.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 10, 2003 at 5:29 pm
Here is a couple of articles that might help regarding collation and changing the collation settings.
http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp
http://www.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply