SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Change Collation for a server
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

the1gadget
Yak Posting Veteran

55 Posts

Posted - 09/21/2005 :  11:05:11  Show Profile
Hi All

Is it posible to change the server collation after it has been installed?

--
David

ravilobo
Flowing Fount of Yak Knowledge

India
1184 Posts

Posted - 09/21/2005 :  11:56:55  Show Profile
NO. As far as i know this is not possible. Atleast there is no easy way to do it....

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/21/2005 :  15:02:45  Show Profile
Definitely no easy way to do it. I did it once and vowed never again. Reinstall is much easier IMHO. Make sure all databases are Backed Up ("just in case"), detach all the databases, reinstall, re-attach (or if that fails Restore).

Kristen
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 09/21/2005 :  15:14:55  Show Profile
What good are the backups? He won't be able to restore them after the reinstall

They'll have to migrate all the data out, script the database, reinstall, then reload...

Unless I'm mistaken



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/21/2005 :  15:50:58  Show Profile
"What good are the backups"

I was assuming that the User DBs had explicit COLLATE defined per-column. But maybe not ...

Kristen
Go to Top of Page

the1gadget
Yak Posting Veteran

55 Posts

Posted - 09/22/2005 :  06:04:54  Show Profile
Hi All

Thanks.

As it is a development server and there is no real working database so I will be doing a reinstall.

I will then have all the usual fun of restoring a DB from a different server.

--
David
Go to Top of Page

homebrew
Posting Yak Master

114 Posts

Posted - 09/23/2005 :  14:20:42  Show Profile
Just FYI .... Each Database can have it's own collation, so even if your Server is Collation_A, you can create databases with Collation_B on that server.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/23/2005 :  14:38:33  Show Profile
... and Columns with Collation_C

Kristen
Go to Top of Page

testsql
Starting Member

1 Posts

Posted - 09/23/2005 :  18:36:56  Show Profile
test
Go to Top of Page

wagan
Starting Member

Australia
3 Posts

Posted - 08/31/2006 :  08:23:18  Show Profile

Is ok to change the collation name of the tempdb?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37142 Posts

Posted - 08/31/2006 :  12:30:01  Show Profile  Visit tkizer's Homepage
quote:
Originally posted by wagan


Is ok to change the collation name of the tempdb?



Why would you want to do this?

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/01/2006 :  17:05:18  Show Profile
wagan, Welcome to SQL Team!

Reinstall your server. I realise that is seemingly a simplistic answer. It avoids loads of other collateral damage over the next few months. If you haven't been in this situation before its hard to gauge what the impact is, so I can only suggest you take the advice of an Old Grey Haired Bloke! If it turns out that you need a different collation for your server my advice is: Cut&Run, and reinstall.

Kristen
Go to Top of Page

CorpDirect
Yak Posting Veteran

USA
92 Posts

Posted - 09/20/2006 :  10:03:21  Show Profile
Hi folks,

I posted a topic asking about migrating databases to a new collation using DTS (though other suggestions are welcome!) here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72229

Since the topic is somewhat related to this one, I hope those of you who responded here will be able to offer suggestions.

Thanks for any help!

Daniel
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000