Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Collation Issue

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2007-01-17 : 04:55:33
Was wondering if anybody can help me on this issue.

I have a sql 2000 server which has a database roughly around 30gb and collation of SQL_Latin1_General_CP1_CI_AS.

Now i have a new server with sql 2005 and what i want to do is restore if from the 2000 server and put it on the 2005 server.

But i also want to change the collation to Latin1_General_CI_AS.

Can anybody help me.

Lee

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-17 : 05:07:52
Create an empty database and BCP all old data out, and import with bulk insert.
Or, try the methods described here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46915
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36707
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36979
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16378


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -