MS SQL Server - SQL Server 7.0 to SQl Server 2005

Author

SQL Server 7.0 to SQl Server 2005

Srikanth

2006-02-04, 8:23 pm

We just upgraded SQL Server 7.0 databases to 2005. Backed up 7.0 database and
restored in 2005 Server.
when we migrating the data from new sql server 2005 database(that is just
converted) to spred sheet we are getiing an error messages

"can not convert nicode and nonunicode string datatypes.
I verified the sort order in 7.0 is 52
and 2005 also 52.
any one any idia what is wrong with these tables.

Thanks

--
SQL serer DBA

John Bell

2006-02-06, 3:23 am

Hi

It seems that somewhere there is a conversion between unicode and
non-unicode data! If you have a unicode column try converting this explicitly
by using a query as the datasource.

John

"Srikanth" wrote:

> We just upgraded SQL Server 7.0 databases to 2005. Backed up 7.0 database and
> restored in 2005 Server.
> when we migrating the data from new sql server 2005 database(that is just
> converted) to spred sheet we are getiing an error messages
>
> "can not convert nicode and nonunicode string datatypes.
> I verified the sort order in 7.0 is 52
> and 2005 also 52.
> any one any idia what is wrong with these tables.
>
>
> Thanks
>
>
>
> --
> SQL serer DBA

Sponsored Links