Migrate Navision Native Database to SQL

Navision Articles

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 2 Replies | 2 Followers

Not Ranked
1 Posts
10 Points
Joined: Apr 2, 2009
Last Online:
Apr 22, 2009 8:48
Location: sri lanka
isuru posted on Apr 2, 2009 6:23
How helpful was this post/question? Please rate here:
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.

All Replies

Top 25 Contributor
690 Posts
8,805 Points
Joined: Nov 17, 2003
Last Online:
Mar 19, 2010 11:26
jsrark replied on Apr 2, 2009 7:01
How helpful was this comment/solution? Please rate here:

Why do you want to use SQL collation 54?

What problems do you see?

 

Jonathan.

Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Top 25 Contributor
Male
1,102 Posts
14,400 Points
Joined: Dec 18, 2000
Last Online:
Mar 21, 2010 19:03
Location: Nürnberg/Germany
DynamicsNAVMVP
Moderator
Jörg A. Stryk replied on Apr 2, 2009 7:55
How helpful was this comment/solution? Please rate here:

Hi "isuru",

welcome to the "Dynamics User Group"

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

Joerg A. Stryk
STRYK System Improvement
NAV/SQL Performance Optimization


Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Page 1 of 1 (3 items) | Get this RSS feed | Bookmark and Share