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 |
|
free2bcbugandme
Starting Member
1 Post |
 Posted - 2009-03-09 : 14:39:43
|
| I have the following situation.DB1 is in SQL Server 2000, and is case-INsensitive.This database needs to be transferred to a SQL Server 2005 that has been installed as case-Sensitive.If I export DB1 and import it into the 2005 instance will it pick up the new collation or will it tranfer the collation as it was in SSrvr 2000. |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-09 : 18:53:42
|
| If you are using the import/export wizard then it should keep the collation in 2005. But that requires that the database in 2005 is created there; you cannot restore 2000 database on to 2005. Then it will use the old collation. Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
|
|
|
converting from case sensitive to case insensitive