I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.
I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times. Something like the following:
ODBC CONNECT32 To [<connection string 1>];
$(Include=script.txt);
ODBC CONNECT32 To [<connection string 2>];
$(Include=script.txt);
ODBC CONNECT32 To [<connection string 3>];
$(Include=script.txt);
Is this a sensible approach? Is there any best practice for handling this situation?