C/AL Coding between 2 database

karl

Hi all,

I'm a newbie here. I have some question regarding C/AL Programming between 2 Database (NAV4). Is it possible to do this kind of programming :?: If it is possible, how to make it? Please help, any suggestion really appreciate.

Regards,

Karel

selece28

What do you mean? Could you be more specific?

tinoruijs

:-k
If you're a newbie I wouldn't take this kind of job.
You could create files from 1 db and import it in the other.

karl

Hi, thanks for the replies.

What I mean here is to make some C/AL programming between databases. Here is the illustration, I have two NAV databases (with SQL Server option),let say DB1 and DB2. Then, I'm login to Navision in DB1 and want to make some C/AL programming to access some tables in DB2. Why? because I want to automatically migrate some data in DB2's table into DB1's table (with some validation). It is for data consolidation purpose. Is it possible? or Am I just Daydreaming? :-k . Please let me know your thought.
I know it can be done through DataPort or XMLPort, but just like we all know that in SQL Server we can do some programming betweeen databases. So, I just think that the same concept can be used in Nav programming.


Regards,

Karel

jonsan21

As far as i know, you can't do what you literally mentioned here. If you want to stretch it, maybe with some automation. But then again, there're thousand and one ways to do what you want to achieve, but in any way, you have to have an 'intermediate' party here.

If what you're talking is to do company consolidation, check on the finance training material, there's a propert method on how to do a company consolidation there.

bbrown

Beyond the technical issues, having 2 databases also violates the end-user license agreement. The license agreement permits running 1 production database. If you are going to run multiple databases thne you must have a seperate valid license for each one.

kine

Base way is to use Application servers to "talk" from one NAV into another. You can use MSMQ, TCP Sockets, SQL server reading/writing etc.

imurphy

There is a section on this in the Nav 5 documentation, I'm not sure if this is something new or not.

Training manual 'Finance in Microsoft Dynamics in NAV 5.0'
Chapter 9 'Multi company operations - consolidations'
Chapter 10 - 'Multicompany operations - intercompany'

bbrown

imurphy wrote:

There is a section on this in the Nav 5 documentation, I'm not sure if this is something new or not.

Training manual 'Finance in Microsoft Dynamics in NAV 5.0'
Chapter 9 'Multi company operations - consolidations'
Chapter 10 - 'Multicompany operations - intercompany'

Note the term "Multi Company" not "Multi Database"

imurphy

bbrown, You are correct in so far as the titles, however the docs do cover exporting to a file for reconcilation between two companies in separate dbs.

I don't know what the situation is with karls setup, but what he wants to do may well be covered by standard nav functionality... assuming he has licenses.

David_Singleton

bbrown wrote:

Beyond the technical issues, having 2 databases also violates the end-user license agreement. The license agreement permits running 1 production database. If you are going to run multiple databases thne you must have a seperate valid license for each one.

Also don't forget that licensing rules are different country to country, also there are a lot of companies that have grandfathered an old agreement they may have had.

In any case how do we know that they don't already have two licenses? I agree fully with what you are saying here, just not the way you are saying it. I think its better to assume "innocent before proven guilty".

karl

Hi all,

Many thanks for all replies. Regarding license, I think our company can have multiple database with only one license as long as it is on one server machine. So, I think license is not an issue here (at least in my company).

By the way, regarding 'data consolidation' purpose that i've been said, it is not some function that can use navision standard. There are some modification tables that need to be transferred between database with some validation. Well, at my wits end, my conclusion here is to use XML Port (if only I have more time, I'll try Kine's suggestion). Again, thanks for all your opinion and suggestion.

Regards,

Karel

David_Singleton

karl wrote:

Hi all,

Many thanks for all replies. Regarding license, I think our company can have multiple database with only one license as long as it is on one server machine. So, I think license is not an issue here (at least in my company).

By the way, regarding 'data consolidation' purpose that i've been said, it is not some function that can use navision standard. There are some modification tables that need to be transferred between database with some validation. Well, at my wits end, my conclusion here is to use XML Port (if only I have more time, I'll try Kine's suggestion). Again, thanks for all your opinion and suggestion.

Regards,

Karel

Also Karel, if you would give us some basic information about WHAT you are trying to do, and not HOW you are trying to do it you would get a lot more people wanting to help you.