Problem with fix the collation of a Microsoft SQL Server Confluence database

[Pavel_Junek__MoroSystems_]

Hello,

I preparing upgrade Confluence to a newer version, but I have a problem with bad set collation in the old DB. We using Windows Server 2008 R2 and Microsoft SQL Management Studio 2012.

I create new database based on manual [Database Setup for SQL Server|https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html]. I followed the instructions on [How to fix the collation of a Microsoft SQL Server Confluence database|https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-microsoft-sql-server-confluence-database-687216725.html]. My problem now is:

- Validating (Error)
Messages
Error 0xc02020f4: Data Flow Task 1: The column "CATEGORY" 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 "CUSTOM_ICON_CLASS" 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 "CUSTOM_TITLE" 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 "HARDCODED_URL" 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 "SPACE_KEY" 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 "TYPE" 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 "WEB_ITEM_KEY" 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 - AO_187CCC_SIDEBAR_LINK" 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 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)

Can you please advise how to bypass this error when you export / import data?

sql_studio.png

Than you very much

Best Regards

Pavel Junek

[nrukavkov]

+1