Solved

to migrate the collations of a database

Posted on 2009-03-29
2
197 Views
Last Modified: 2012-05-06
i have a server with SQL_Latin1_General_CP1_CI_AS collations and other server with chinese collations.i want to transfer the database from  SQL_Latin1_General_CP1_CI_AS server to chinese collation server and i want the transfered database with chinese collations
0
Comment
Question by:vijay11
  • 2
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24014585
This will help you out:

http://support.microsoft.com/kb/325335

Kindly note in the topic, it is mentioned that it is for SQL 2000 and 7.0 but it is also applicable for SQL Server 2005.
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 500 total points
ID: 24014596
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Insert statement is inserting duplicate records 15 61
Record open by another user 6 60
Following an example - removing duplicate strings 4 57
Query to Add Late Tolerance 10 70
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question