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 |
|
govthamb
Starting Member
27 Posts |
 Posted - 2009-08-17 : 05:28:37
|
| Hi,I am in the process of migrating the 2000 database to 2005.In 2000, collation is defined at the server level as 'SQL_Latin1_General_CP850_BIN' and Case sensitive also.When I install the 2005, the default collation is 'SQL_Latin1_General_CP1_CI_AS'. Will there be any problem if I continue with the process?(Or)Do I need to change the collation as 'SQL_Latin1_General_CP850_BIN' in 2005 server?In 2005, data should be case sensitive only and no problem should occur while executing procedures or sql statements.Please suggest me.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-17 : 11:11:18
|
| how are you migrating it? collation shouldn't change. |
 |
|
|
govthamb
Starting Member
27 Posts |
Posted - 2009-08-18 : 02:13:05
|
| Actually I will migrate using the Back up and Restore method.Already 2005 server is already installed in the box with collation 'SQL_Latin1_General_CP1_CI_AS'. If I restore the 2000 DB back up file, then the DB collation would be 'SQL_Latin1_General_CP850_BIN', but the server collation will not be the same. (I presume)As per requirement, after migration, collation for server and DB should be the same and it should be 'SQL_Latin1_General_CP850_BIN' in 2005 also.I want to know if we maintain the same collation in 2005, will there be any problems? (or) Can I suggest the client to maintain 'SQL_Latin1_General_CP1_CI_AS' in 2005 at server and DB levels.Please suggest me. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 08:11:07
|
| Changing from _Latin1_General_CP850_BIN to SQL_Latin1_General_CP1_CI_AS should be fine. |
|
|
|
govthamb
Starting Member
27 Posts |
Posted - 2009-08-18 : 09:38:21
|
| Thank you Russell. |
|
|
|
govthamb
Starting Member
27 Posts |
|
|
|
|
|
Collation Change in 2005 server