How cast collation when inserting data with different collation?

Question

I want to copy data from a table to another which has a different collation.

But when I execute my query, it returns an error.

INSERT INTO [des].[dbo].TableDes
    SELECT *
    FROM [src].[dbo].TableSrc

Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

Solution

we have to define COLLATION when we move data one COLLATION to another

INSERT  INTO [des].[dbo].TableDes 
SELECT  col1,col2,... COLLATE Arabic_CI_AS
FROM    [src].[dbo].TableSrc 

COLLATION