Method to change collation sequence: existing databases 1

[SantaMufasa]

I've already reviewed thread962-1142975 that touches upon my issue. I have about 8 existing databases, each containing 1500+ tables, each table containing 5-35 columns, each table containing 20 - 15M+ rows.

We understand the method of going through each column in each table and issuing the command to modify the collation definition.

Our product managers are asking, however, if there is some alternate method such as exporting the tables, then importing them anew into databases that have the desired collation definition.

Is this a prospect for us, or must we follow the column-by-column, table-by-table collation-redfinition method?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[ptheriault]

Dave,
Here is a really good link with some scripts.

http://www.dbforums.com/archive/index.php/t-998397.html

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SantaMufasa]

Thanks, Paul, for the link. Yes, the scripts appear to be high quality and my product manager anticipating the collation change seemed very pleased with the code.

Hava

for pointing us in the right directions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]