Howdy, Stranger!
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
- 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
- 310 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Navision 5.0 SQL Source Compare via Excel
Administrator
Member, Moderator, Administrator Posts: 2,500
Navision 5.0 SQL Source Compare via Excel
Simple Excel 2000 spreadsheet using VBA to connect to up to 4 SQL 2005 Servers and compare Navision 5.0 (probably others) Object table. Source across all servers are highlighted to quickly identify differences. Does not write anything to SQL...all information is written to the spreadsheet.
1. Tested using Excel 2000 (for us who like to use the oldest possible version forever....) on Windows XP and Windows 7. VBA module uses reference to ADO 2.8 to open/scan SQL tables.
2. When opening, ensure you enable macros so the VBA code will run when you are ready.
3. Parameter tab: Set your server name/IP address, authentication information and database name. Leave authentication blank if you want to use Windows authentication. Press the process button to regenerate the Compared tab with your source code information. Make sure you have SQL permissions to SELECT from the Object table.
4. I left a bunch of information on the Compared tab for example info. This will get cleaned up and replaced when the VBA module runs.
5. Didn't have a lot of time for error checking, but it definitely saves me a bunch of time when trying to locate those out of date modules.
Have fun and tweak the VBA code as you wish.
http://www.mibuso.com/dlinfo.asp?FileID=1423
Discuss this download here.
Simple Excel 2000 spreadsheet using VBA to connect to up to 4 SQL 2005 Servers and compare Navision 5.0 (probably others) Object table. Source across all servers are highlighted to quickly identify differences. Does not write anything to SQL...all information is written to the spreadsheet.
1. Tested using Excel 2000 (for us who like to use the oldest possible version forever....) on Windows XP and Windows 7. VBA module uses reference to ADO 2.8 to open/scan SQL tables.
2. When opening, ensure you enable macros so the VBA code will run when you are ready.
3. Parameter tab: Set your server name/IP address, authentication information and database name. Leave authentication blank if you want to use Windows authentication. Press the process button to regenerate the Compared tab with your source code information. Make sure you have SQL permissions to SELECT from the Object table.
4. I left a bunch of information on the Compared tab for example info. This will get cleaned up and replaced when the VBA module runs.
5. Didn't have a lot of time for error checking, but it definitely saves me a bunch of time when trying to locate those out of date modules.
Have fun and tweak the VBA code as you wish.
http://www.mibuso.com/dlinfo.asp?FileID=1423
Discuss this download here.
0