I'm trying to copy data from one database to another with built-in export tool.
but I get this error:
Error 0xc02020f4: Data Flow Task 1: The column "Name" cannot be processed because more than one code page (1250 and 1252) are specified for it.
(SQL Server Import and Export Wizard)
Error 0xc02020f4: Data Flow Task 1: The column "CatalogNo" cannot be processed because more than one code page (1250 and 1252) are specified for it.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task 1: "Destination - Device" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task 1: "Destination - Device" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Ok. I change It manually in Design
->Collation
->Restore default
after that I copied all the data.