what is the best way for convert VisualFoxPro Database To Sql Server 2008 - Without Damage in Unicode Data?

what is the best way for convert VisualFoxPro Database To Sql Server 2008 - Without Damage in Unicode开发者_如何学C Data ?

thanks in advance

best regards

---

I'd expect the SQL Server Upsizing Wizard to give you the best shot, but maybe I'm being unreasonably optimistic today.

Should that fail, you'll want to

• Set up your target database with a compatible collation.
• Don't let your data rest in the filesystem before arriving at its destination.
• If the data must rest in the filesystem, make sure all your tools support your variant of Unicode, and that your codepages are compatible.
• Expect things to almost work. (That's a Bad Thing, but it seems to be the rule with Unicode.) Prove your system and processes with fiendish tests beforehand.