Migrate Navision Native Database to SQL

Hi Guys, i am trying to migrate my navision native database to sql. But there is a conflict between those two database collations.I can migrate my native database to sql 2008 with windows collation and it works without any problem. but i am unable to use sql collation no 54 for western europe. How can I handle this?? Please give me a quick reply. Thanx in advance.

Why do you want to use SQL collation 54?

What problems do you see?

Hi “isuru”,

welcome to the “Dynamics User Group” [<:o)]

Actually your question is a somewhat frequently asked & discussed issue; f you search the forum - e.g. “collation” or “migration” - you will find plenty of advices, etc… Here is one of the recent threads: http://dynamicsuser.net/forums/p/26196/142024.aspx#142024

Kind regards,
Jörg