I need to change database and or table and or server collation in SQL2005.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » I need to change database and or table and or...

I need to change database and or table and or server collation in SQL2005.

Rate Topic

Display Mode

Topic Options

Author

Message

RRIOS42

Posted Tuesday, January 15, 2008 8:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:54 AM
Points: 7, Visits: 225

Have read most of the postings with regards to this but can seem to get it, currently unable to change DB collation because of the following error: Server: Msg 5075, Level 16, State 1, Line 1
The object ' ' is dependent on database collation. I have lots of objects, triggers, FK, PK, etc...
Not only do I need for the DB to change going forward but the data that is there as well.

Goal would be to:

Disable all objects
change db collation
change table collation

Is it possible?

Post #443054

Andras Belokosztolszki

Posted Tuesday, January 15, 2008 8:39 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

An alternative could be is to use a third party tool to script the whole schema, modify the creation script to include the right collation, create the new database, use tool to migrate all the data. There may be a better approach, but this is what I used :)

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Post #443062

RRIOS42

Posted Tuesday, January 15, 2008 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:54 AM
Points: 7, Visits: 225

Did you use RedGate tools? If so i have them as well.

Post #443066

Andras Belokosztolszki

Posted Tuesday, January 15, 2008 8:59 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

Ray (1/15/2008)

Did you use RedGate tools? If so i have them as well.

Yep :) (in this case, to script a db you can just compare it against an empty database, and save the synchronization script :)

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Post #443081

Matt Miller (#4)

Posted Tuesday, January 15, 2008 9:03 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,997, Visits: 13,941

Ray (1/15/2008)

Did you use RedGate tools? If so i have them as well.

Ray - take a little closer look at Andras' signature....:D

I'd say it's a fair bet that he has RedGate Tools..... Cool

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Post #443084

RRIOS42

Posted Tuesday, January 15, 2008 9:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 7:54 AM
Points: 7, Visits: 225

First post, caught it after I sent it thanks for the feedback

Post #443088

« Prev Topic | Next Topic »

Permissions