Daily backup by navision(only record transaction) not all da

ahmedba
Member Posts: 424
Hi guys i want to take daily backup of dynamic navision can any one told me how.
because in my case I work in company have three branches meaning i have three database
A is main
B is branch
C is branch
that i want to take daily transaction(records) that happen in B and C then put in A
these three databases have same structures and tables and colmun meaning if i make 20
record daily in database B and MAKE 30 record in database c that meaning i need 50 record
daily must added to database A.
are this possible to take daily backup by dynamic navision or by sql or text files to all
tables in database.
please help me
thanks
because in my case I work in company have three branches meaning i have three database
A is main
B is branch
C is branch
that i want to take daily transaction(records) that happen in B and C then put in A
these three databases have same structures and tables and colmun meaning if i make 20
record daily in database B and MAKE 30 record in database c that meaning i need 50 record
daily must added to database A.
are this possible to take daily backup by dynamic navision or by sql or text files to all
tables in database.
please help me
thanks
0
Comments
-
Why does three branches mean three databases? Wouldn't it be simpler to run them all in the same database?There are no bugs - only undocumented features.0
-
Three branches meaning three databases because every branch have one database have his transaction but all A,B,C is same structures and tables meaning B,C is coping from A
but data only different from branch to branch.
thanks0 -
I understand how you have it configured. That's not what I am asking. I am asking why did you configure it this way. If you want all the data in one database, wouldn't it have been easier (and cheaper) to put it all in one database to begin with. Then you would have only needed to purchase one NAV license.
What you are talking about, while not technically impossible, would be a rather difficult and expensive task.There are no bugs - only undocumented features.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions