asked on

change Collation

Hello

how can i change the collation name of a specific database ?

The rebuildm.exe is changin the Master database while i want to change only a specific database .

is there a way to change it with sql statements like alter ?

What is the common collation name ? (I develop an application with DB with collation of hebrew / arabic ... now i wish to change the collation to english ) how can i do it ?

Thank you
Asi

crescendo

You can use

ALTER DATABASE YourDatabaseName
COLLATE CollationName

But this will only affect tables and columns created subsequently, it won't change existing data. To do that, the easiest way is to generate the database creation script in Enterprise Manager, then find and replace all references to your existing collation with the new collation name.

First, dump all the tables using BCP.
Second, drop the database (back it up first!)
Third, recreate it using the edit script.
Fourth, reload the data using BCP.

asi

ASKER

BCP ?

crescendo

It's a command-line utility to import and export data to text files. Look it up in Books Online.

asi

ASKER

can u be more specific regarding the parametrs of BCP (in need specific sample)

crescendo

To output a table:

bcp pubs..authors2 out authors.txt -w -Sservername -Usa -Ppassword

asi

ASKER