DTS between SQL 7 and SQL 2000

#1

Hi!!!

I am a newbie and need know how can I use the DTS to transfer one DB from
SQL 7 which has CP850 as a code page to a SQL 2000 which has the collation
SQL_Latin1_General_CI_AS.

What I need to check during DTS operation to preserve SQL 7 code page in
order to avoid weird characters in SQL 2000?

Thanks for any information.

#2

It was/is my understanding that DTS would do the conversion for you.
Have you tried?

"Héberson Sette de Almeida" <hesa (AT) hotmail (DOT) com> wrote

Quote:

Hi!!!

I am a newbie and need know how can I use the DTS to transfer one DB
from
SQL 7 which has CP850 as a code page to a SQL 2000 which has the
collation
SQL_Latin1_General_CI_AS.

What I need to check during DTS operation to preserve SQL 7 code page in

order to avoid weird characters in SQL 2000?

Thanks for any information.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS between SQL 7 and SQL 2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS between SQL 7 and SQL 2000 - 02-02-2005 , 01:15 PM

Re: DTS between SQL 7 and SQL 2000 - 02-02-2005 , 01:38 PM