January 15, 2008 at 8:34 am
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?
January 15, 2008 at 8:39 am
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
January 15, 2008 at 8:41 am
Did you use RedGate tools? If so i have them as well.
January 15, 2008 at 8:59 am
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
January 15, 2008 at 9:04 am
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?
January 15, 2008 at 9:07 am
First post, caught it after I sent it thanks for the feedback
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply