• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Different collation on Dev and prod Servers

I have 2 servers,
When SQl Server was installed on them the collation was somehow set to be diiferent...
As the production server uses the stuff developed in developement server ..when i try to copy stuff it gives collation error..
Can i change the collation of the server by any means...?
Is there a solution to fix the problem..?

Thanks
0
mostym
Asked:
mostym
2 Solutions
 
SjoerdVerweijCommented:
- Create a new database with the correct collation.
- Use DTS to copy everything to the new database.
- Rename/delete the old database.
- Rename the new database.
0
 
winzigCommented:
Unfortunately, it isn't so easy. As you can see in the following question:


http://www.experts-exchange.com/Databases/Q_21092551.html
 

there is a Houbart faintbru@btinternet.com which changing collation in all fields (I made same improvements to this  script)
But because I bypass same limitation of SQL server (You cannot use alter table on text fields) there is a problem with encrypted Stored procedures and with encrypted triggers.

But if you can recreate those structures in your target database there will not be problem wit this script.

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now