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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-04-21 : 06:34:58
|
| Hi,I have a sql 2005 instance with all system database with one collation.We restored a backup that was provided to us is of different collation.We do not know if the application can handle this OR NOT?would like to know if we can switch the collation on the databaseAfter changing the collation(if it can be done) what kind of impact does have for the existing and upcoming data?Say for example, i have 10 records and if i chnge the collation what happenns to existing and newly inserted records?Any help would be greatly appreciated.Thanks in advance |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-21 : 07:31:55
|
| You can change the collation of the database but that won't affect the columns or the data in it. The columns will still retain the old collation and would need to be updated.You would probably find it easier to create a new database and copy the data across (that's assuming that the colation change doesn't end up with invalid data)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2011-04-21 : 20:21:13
|
| Hi,What you said is correct but how much in reality it is feasible to create a new empty database and dumping data into it.Is there any other alternative?How much will be the impact would be from App perspective, if it is accessing data from an instance whose server collation is different and database collation is different ??Thanks, |
|
|
|
|
|
|
Collation