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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-26 : 11:03:47
|
| Shire writes "I have a SQL 7.0 sp3 server (NT4.0)that was setup to use binary sort order and unicode collation. The client now wants the server to be 'non-unicode' because it is not compatable with our other servers. How do I backup the databases so that they can be reloaded into the new installation of our SQL 7.0 Binary sort order 'non-unicode' server? Our experience with unicode to 'non-unicode' database restores have not been favorable. What are we doing wrong ?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-27 : 13:25:42
|
| They have not been favorable, because you can't do it.You have to DTS or BCP your data into a text file, rebuild master to the correct sort order, then DTS the data back in.-Chad |
 |
|
|
|
|
|
Unicode to non-unicode database move