February 15, 2002 at 7:55 am
Hi
I am looking at upgrading some SQL 6.5 servers to SQL 2000. The 6.5 servers run a mixture of code page 850 & ISO 8890 and sort orders of 42 & 52.
We want to ensure all the 6.5 databases are migrated to 2000 BUT want to future proof the SQL 2000 databases by supporting unicode characters, as the SQL 2000 databases will be avialable world wide to all languages. That said, we want to ensure the existing table structures are preserved and run at 6.5 compatibility level. I am a little concerned as I am unsure if unicode support will alter table structures and require a re-write of the database schema or table structures.
Can someone help by giving me a straight forward explanation of the implications of my plans please?
Many thanks,
JB
February 15, 2002 at 7:59 am
My suggestion would be to migrate to SQL2K first using the compatibility mode. Then as quickly as possible work to get OUT of compatibility mode. Whether schema changes will be necessary I guess depends on what you have now?
Andy
February 15, 2002 at 10:28 am
I agree with Andy. There is much more flexibility in SS2K. If you upgrade, then you will find it easier to make other changes.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply