Transfer prblem - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Transfer prblem

Author

Topic

gorlanda
Starting Member

5 Posts

Posted - 2008-12-13 : 16:43:47

I want to transfer Database from old application to new application. but i have this msg every time when i use script transfer.
Where is the prblem? Help me pls.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 468, Level 16, State 9, Line 129
Cannot resolve the collation conflict between "Romanian_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Line 133
Cannot resolve the collation conflict between "Romanian_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Line 137
Cannot resolve the collation conflict between "Romanian_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
...................................

Gabriel

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-13 : 21:11:33

it seems like the collations of dbs are different.thats why the collation conflicts occur.Can you check collations of two servers? Then you should use ALTER DATABASE command to change collation of your database.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186718,00.html

gorlanda
Starting Member

5 Posts

Posted - 2008-12-14 : 10:24:38

i did what u say, but same problem, i do not know why :( i think the problem is somewhere at REGIONAL AND LANGUAGE OPTIONS ,I'm not sure... or? i use "windows vista ultimate with sp1"...where i working it's works at windows XP professional.

Thanks for help!

ALTER TABLE name.DBO.col1
ALTER COLUMN FCS3 VARCHAR(100) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS
ALTER TABLE name.DBO.col2
ALTER COLUMN col5 VARCHAR(100) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS

problem is here

Msg 468, Level 16, State 9, Line 129
Cannot resolve the collation conflict between "Romanian_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-14 : 12:34:03

but initial post said you get error on db transfer. did you changed collation of db before doing alter column?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources