The purpose is that I want to change collation (database, table, column) from Chinese_Taiwan_Stroke_CS_AS to SQL_Latin1_General_CP1_CI_AS.
There is the way that I change the collation on database.
First, I use the old_db tasks --> General scripts... and set the script collation false with schema only.
Then, I renew the scripts database name to new_db and set the collation = SQL_Latin1_General_CP1_CI_AS.
There is no error to here.
Finally, I want to import the data from old_db to the new_db by export data from old_db to destination new_db, but it will show the error 0xc02020f4.
I think that this error is related to collation issue, but I want to change collation so the old_db and new_db must be different. How can I solve it?
By the way I have viewed other topics about change collation but it's still not work for me due to the error:
Incorrect syntax near the keyword 'CONVERT'
so I try another way to do.
Changing the collation at any level has no effect on actual data stored. You need to move externally or internally the data from a column to another or a table to another or all the table of the database to another database after allways having precisely specified the correct collation in the ALTER or CREATE statement