General discussion

Locked

Changing Sort order on SQL 7.0

By don ·
Can you change the sort order on a SQL 7.0 from Binary to DOCI without data loss easily?
I have a SQL loaded in binary and need to convert to DOCI to allow another application to use the same server. is this possible

Don McNulty

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Changing Sort order on SQL 7.0

by Bill_H In reply to Changing Sort order on SQ ...

You *can* change the collation sequence for an instance of SQL Server 7.0...but I'm not sure I would categorize the process as *easy*. This topic is covered in the SQL Server Books Online, under the topic of "Changing the Character Set, Sort Order,or Unicode Collation" (go to Installing SQL Server/Running SQL Server Setup/After Installing). I've pasted the text below in case you don't have SQLBOL.Chm handy...

Changing the Character Set, Sort Order, or Unicode Collation

The character set, sort order, and Unicode collation are fundamental to the structure of all Microsoft? SQL Server? databases. In order to change one or more of these settings, you must rebuild the master and user databases.

Follow these steps to rebuild the databases and maintain their contents.

1. Back up the definitions of objects you want to preserve.
Use SQL Server Enterprise Manager to create scripts for all of the objects in the user databases and master database.

2. Export data from the user tables.
Use Microsoft Data Transformation Services (DTS) or the bcp bulk copy utility to unload the user data.

3. Rebuild the master database.
Run the Rebuildm.exe command prompt utility. You can select new character set, sort order, and Unicode values and rebuild the master database with these new settings.

4. Create new user databases.
Use SQL Server Enterprise Manager or the CREATE DATABASE statement to re-create the user databases.

5. Create objects using the scripts created earlier.
Use SQL Server Query Analyzer to run the scripts you created earlier.

6. Import data into the user tables.
Use DTS or BCP to load data back into the user tables.

See Also
Creating a Database
Overview of Data Transformation Services
Documenting and Scripting Databases
Rebuild Master Utility
Importing and Exporting Data

(c) 1988-98 Microsoft Corporation. All Rights Reserved.

Hope this helps...

Collapse -

Changing Sort order on SQL 7.0

by don In reply to Changing Sort order on SQ ...

Poster rated this answer

Collapse -

Changing Sort order on SQL 7.0

by don In reply to Changing Sort order on SQ ...

This question was closed by the author

Back to Desktop Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums