bulk insert to all data by dynamic nav

ahmedba

How i make bulk insert to all data in database from dynamic nav 2009(code if possible)

bbrown

Can you explain what you are trying to acomplish in a bit more details. Then maybe people can help guide you to a solution.

ahmedba

What i want to do i have Dynamic nav 2009 have data from 3 branches connected to sql server 2005 as supposed below :
Database A,B,c three database same structure and objects but different in data .
Database A is main database. what i want is transfer data(only) from every branch(Database B,C) to main branch A so that i need to use bulk insert to dynamic nav to file(excel,text file,any format) how i make this meaning how i take data from buffer to text file by nav 2009(by using code)
please help me
thanks

manisharma31

You want data for Consolidation or what in A database ?

bbrown

Two questions come to mind...

1. Is what you are trying to accompish even feasible?

2. Assuming (for a moment) that it is, is Bulk Insert the right solution?

I have my reservations on both of these.

ahmedba

Yes i want data for consolidation meaning merge of Database B,C that specified any branch and put them in main branch so that i want to take all data in database B,C AND PUT them in A(main database . because three branches not connected with others by vpn or any thing so that i want to take all data from every branch and but them in file then import them in main branch(Database A).
thanks

bbrown

Consolidation is not "all data". Consolidation is only at the General Ledger level.

Why aren't the sites connected and running from a single database? Would have saved the cost of the extra two NAV licenses to begin with.

ahmedba

http://msdn.microsoft.com/en-us/library/dd355341.aspx
thanks

bbrown

ahmedba wrote:

http://msdn.microsoft.com/en-us/library/dd355341.aspx
thanks

That has nothing to do with what you are talking about here. That is about how C/Side can write data back to SQL.

ahmedba

Now what i make to solve these problem(connection between three branches because they found in places don't have signal not for cost )
thanks

bbrown

ahmedba wrote:

Now what i make to solve these problem(connection between three branches because they found in places don't have signal not for cost )
thanks

You're saying the sites are not connected because of the cost? Not because of any technical issues. Am I understanding you correct?

Do those cost really outweigh the cost of 3 separate NAV systems (and licenses) plus the development cost of accomplishing what you are contemplating?

davmac1

My impression is he is saying there is not a good enough connection to allow everyone to be connected to the same NAV instance. If this is the case, how are you transferring the data - via media and human transport?
Doesn't LS Retail have an offering that allows merging of data from disconnected sites?
Have you checked with them?

Duplicating this in code will take a huge amount of work plus some rules for handling conflicts (multiple branches updating the same record).
This also means it will take a huge amount of testing.