Sign in

Microsoft.com

Microsoft

Remove From My Forums

Changing the database collation

Question
0

Sign in to vote

Is it possible to change the database collation when upgrading from Dynamics CRM V4 to 2011 onprem? Has anyone tried this?

Jo Savidge

Pythagoras.

Friday, April 8, 2011 11:02 AM

Answers

0

Sign in to vote
Download the implementation guide and take a look.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9886AB96-3571-420F-83AD-246899482FB4

I poked through it and it makes recommendation, but doesn't seem to say it's not. It also shows what types of collation sorts are supported. Just do a search in the .CHM file included for collation and you find all you need to know.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!
- Proposed as answer by Jamie MileyModerator Friday, April 8, 2011 2:37 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 9:29 PM
Friday, April 8, 2011 2:37 PM

Moderator
0

Sign in to vote
For your information : When it is possible to change the required SQL collation, but by default the SQL collation is set on the basis of the base language installed thereby it is also advisable to see through how it behaves when changed, here is a nice article which explains SQL collations in and out.
Cheers, Edwin Follow me on http://twitter.com/astutecrm
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 9:29 PM
Saturday, April 9, 2011 1:22 PM

All replies

0

Sign in to vote
Download the implementation guide and take a look.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9886AB96-3571-420F-83AD-246899482FB4

I poked through it and it makes recommendation, but doesn't seem to say it's not. It also shows what types of collation sorts are supported. Just do a search in the .CHM file included for collation and you find all you need to know.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!
- Proposed as answer by Jamie MileyModerator Friday, April 8, 2011 2:37 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 9:29 PM
Friday, April 8, 2011 2:37 PM

Moderator
0

Sign in to vote
For your information : When it is possible to change the required SQL collation, but by default the SQL collation is set on the basis of the base language installed thereby it is also advisable to see through how it behaves when changed, here is a nice article which explains SQL collations in and out.
Cheers, Edwin Follow me on http://twitter.com/astutecrm
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 9:29 PM
Saturday, April 9, 2011 1:22 PM
0

Sign in to vote

Did you find the answer you needed?

Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!

Saturday, June 4, 2011 2:39 AM

Moderator