We want to install applications that will have an accompanying database that has very large local lookup tables. We want to fill them at install time from an oData (web service) source instead of using SQL scripts because the installer can't handle SQL scripts this large (and if we broke them up into the size the installer could handle, we would need to maintain several hundred scripts or more).
Having the installer call an oData web service would simplify this so that we would not need to maintain any data-related SQL scripts, just a master database with the correct values in it. The users would always have access to the most up-to-date values from the master database.
Has anyone done something like this? ...or, is there already a facility in Advanced Installer for doing this? A generic facility (not needing to write new code for each table being populated - just recording configuration information) would be best.
Thanks,
Rob