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.