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.