Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Accessing another NAV database on different SQL Server
DRB
Member Posts: 105
Hi,
I want to access a NAV database on different SQL Server from within a NAV database, can this be done?
For example: I have two SQL Srver A &B placed at diffrent locations. Each SQL Server has one NAV database and each database further has 3 companies in each.Item master (Item No. only) of these databases & companies are same (common). Now I want to display in a report (or form) Item Availability by database, means it should display the items in the other database also (if accessing in SQL Server A, then it should get the data from database in SQL Server B also or visa-versa).
How can this be done? Any ideas will be appreciated.
I want to access a NAV database on different SQL Server from within a NAV database, can this be done?
For example: I have two SQL Srver A &B placed at diffrent locations. Each SQL Server has one NAV database and each database further has 3 companies in each.Item master (Item No. only) of these databases & companies are same (common). Now I want to display in a report (or form) Item Availability by database, means it should display the items in the other database also (if accessing in SQL Server A, then it should get the data from database in SQL Server B also or visa-versa).
How can this be done? Any ideas will be appreciated.
-Dhan Raj Bansal
Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal
Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal
0
Comments