August 7, 2009 at 7:05 am
didnt, 'just' google. That was one of the resources i used.
If you actually read all the doc you would see that the KVS doc actually references that article.
And besides which my last post was addressed to Lucky.
Adam Zacks-------------------------------------------Be Nice, Or Leave
August 7, 2009 at 7:56 am
If you change the collation of a database only NEW data will be effected by that change. (Interesting!) You must move the data from DBa to DBb for a whole scale change. I had to do this in a Dynamics GP 10 upgrade and it was terrible.
August 13, 2009 at 1:54 pm
Hi there
been there done that
As I understand it, you have a database that your client wants changed so that it's collation matches his server collation.
Steps to follow
1. Change Database collation using the step mentioned above
2. Generate a script of all your primary Key, Foreign Key and default constraints.
3. Drop all your primary keys, foreign keys and defaults
4. Change the collation of every (n)char, (n)varchar, (n)text column in every table to the new collation
5. load your default, primary key and foreign key constraints (in that order)
Voila your database is now in the collation requested
Enjoy 😀
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply