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 |
|
roykauf
Starting Member
36 Posts |
 Posted - 2008-11-25 : 07:28:23
|
| Hi all,How can I copy DB to a new DB with different collation?The problem:I have a DB with mixed collations. the DB collations is Arabic_CI_AS_WS but inside it tables with columns's collation: Hebrew_CI_AI_KS. I tried Backup and restore; DB- Genearete script and Export data;I tried Export Data alone - but this was bad, because tables structure was changed: for example - no Identity seed for Columns that had Identity and so on.Does someone knows what it the solution for this?Roy |
|
|
|
|
|
Copy DB to a new DB with different collation