I can say what I*m trying to do, and it’s to integrate Navision with Umbraco, the open source CMS software I’m using to run http://DynamicsExperts.net. I’m trying to import the members into the CRM section of Navision, to make it much easier for us to handle replies and emails etc. to the candidates.
I am sorry its linked server. You probably know it. It allows connection from one sql database to other database residing on other server and then you can write sql queries to import the data or do what ever you want. This was just a suggestion. But in these case if you will import data directly to navision tables in sql , it may cause problem during upgrade of navision. This was just one suggestion.
Erik so far i have seen a lot of post and yours happen to be more and you have a load of experince too, still you have doubts? sorry if i am being rude, i just wanted to know. Because i am not from Dynamics Background, i Just Found this field very interesting. so How long do i have to go before i can solve errors and query without others guides?
You are right about it may not help as you have special requirement. I just suggested it as i have been using it and it is flexible too. Well longer than 250 string wont fit in the NAV table, i didnt know that you were having problems with long text which is longer than 250. Just i had a suggestion thats all.
Badly, of course… But, as you know the structure of “linked” tables --I suppose you yourself have designed them-- and thus know possible problematic fields, you can create a View, which cuts longer fields and remaps them to a bunch of allowed 250. Then in the importing code you can manipulate the View, not linked table, further to gain what you need without fair to get overflow error.
Rather weird method, of course, and would not help with BLOBs, but Ntext theoretically could be managed that way… The question is, that MS almost in every next SQL version extends Ntext - it was 4096 Unicode (double-byte) chars, now AFAIK its already twice as long, so it’s not a “clean” method.