Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Database in the SQL Server
njaiku
Member Posts: 116
Hi,
Two database A and B resides in the SQL Server 2005.
A is the database which holds the Dot Net application data and B is the database which holds the Navision database data.
Now the requirement is
a) I have to get the data from A database and needs to be reflected in the B database
ie) Suppose a new user is created in the A database that needs to be inserted in the B database
ie) If any modification done in the A database that needs to be reflected in the B database(Navision database)
b) As any records inserted in the B database that needs to be reflected in the A database.
Data has to be shifted from one database to nav database through batch process. Is it possible?
Looking forward for your valuable response.
Two database A and B resides in the SQL Server 2005.
A is the database which holds the Dot Net application data and B is the database which holds the Navision database data.
Now the requirement is
a) I have to get the data from A database and needs to be reflected in the B database
ie) Suppose a new user is created in the A database that needs to be inserted in the B database
ie) If any modification done in the A database that needs to be reflected in the B database(Navision database)
b) As any records inserted in the B database that needs to be reflected in the A database.
Data has to be shifted from one database to nav database through batch process. Is it possible?
Looking forward for your valuable response.
Jai
0
Comments
I understand 'Getting' the data as reading, so if you need to insert into database B everything what was *read* from database A then you need to upgrade to SQL2008, which allows you to audit database reads. Technically it is possible but only in SQL2008. Another matter is if this makes sense, and/or if I understood correctly your requirements.
Anyway - you will need to hire SQL *expert* do achieve this or read tons on documentation.
Regards,
Slawek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
This can be acheived and we have done in the past couple of times. You can use a SSIS Package or cutom build an application which will perform this operation for you.
For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
To answer your question:
YES.
If you have more questions, please ask away.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Don't forgett in both cases, that NAV doesn't allow NULL values.
Do you has some more questions?
Watch out for spammers like this. Some are hard to spot.
This guy has a lot of spam out there.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Because he is posting on many forums on the internet. basically he posts a one line generic reply. Then comes bac a month later and changes his signature to spam. Hoping at that point that he is under the radar.
http://www.google.com/search?source=ig&hl=en&rlz=&=&q=%22Thanks+for+taking+the+time+to+help%2C+I+really+apprciate+it%22&btnG=Google+Search&aq=f&oq=&aqi=