Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I need to change database and or table and or server collation in SQL2005. Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2008 8:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 8:15 AM
Points: 7, Visits: 242
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
Posted Tuesday, January 15, 2008 8:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Tuesday, January 15, 2008 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 8:15 AM
Points: 7, Visits: 242
Did you use RedGate tools? If so i have them as well.
Post #443066
Posted Tuesday, January 15, 2008 8:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Tuesday, January 15, 2008 9:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 30, 2014 5:24 PM
Points: 7,139, Visits: 15,191
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.....


----------------------------------------------------------------------------------
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
Posted Tuesday, January 15, 2008 9:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 8:15 AM
Points: 7, Visits: 242
First post, caught it after I sent it thanks for the feedback
Post #443088
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse