Code Page issue??

Hi, I have a table in SQL Server 7.00.961 with
charset=cp850 sort_order=noaccents_850 charset_num=2
sort_order_num=44 collation sequence, I want to transfer
this data without losing accents or special characters to
a SQL Server 2000 - 8.00.534 with the same collation
sequence. Does anybody knows if there is an issue when
doing this (I know that both databases have the same
codepage, etc, but maybe we can have problems because they
have different server versions)?
By the way, is there any special procedure (or help) to
deal with the migration of data between differente
codepage databases?. Suggestions?
Thanks a lot!!!Hi.
In sql 7, the code page was all the server, in sql 2000 de code page only is a database the same that collation. but perhaps you have problems with SPs because SQL 7 is more than "friendly" sql 2000. The best procedure for migration is Backup and restore, thus it maintains cod page, collation and other propierties, then Yoy may use dts to transfer logins, and jobs for especific database.
I hope help you
Carlos Augusto
Bogot=E1 Colombia.
>--Original Message--
>Hi, I have a table in SQL Server 7.00.961 with >charset=3Dcp850 sort_order=3Dnoaccents_850 charset_num=3D2 >sort_order_num=3D44 collation sequence, I want to transfer >this data without losing accents or special characters to >a SQL Server 2000 - 8.00.534 with the same collation >sequence. Does anybody knows if there is an issue when >doing this (I know that both databases have the same >codepage, etc, but maybe we can have problems because they >have different server versions)? >By the way, is there any special procedure (or help) to >deal with the migration of data between differente >codepage databases?. Suggestions?
>Thanks a lot!!!
>.
>|||Hi.
In sql 7, the code page was all the server, in sql 2000 de code page only is a database the same that collation. but perhaps you have problems with SPs because SQL 7 is more than "friendly" sql 2000. The best procedure for migration is Backup and restore, thus it maintains cod page, collation and other propierties, then Yoy may use dts to transfer logins, and jobs for especific database.
I hope help you
Carlos Augusto
Bogot=E1 Colombia.
>--Original Message--
>Hi, I have a table in SQL Server 7.00.961 with >charset=3Dcp850 sort_order=3Dnoaccents_850 charset_num=3D2 >sort_order_num=3D44 collation sequence, I want to transfer >this data without losing accents or special characters to >a SQL Server 2000 - 8.00.534 with the same collation >sequence. Does anybody knows if there is an issue when >doing this (I know that both databases have the same >codepage, etc, but maybe we can have problems because they >have different server versions)? >By the way, is there any special procedure (or help) to >deal with the migration of data between differente >codepage databases?. Suggestions?
>Thanks a lot!!!
>.
>