How does Subset communicate with remote MSSQL databases?
Situation
How does DATPROF Subset read the remote database. It seems it is not always done the same way.
Explanation
DATPROF Subset uses several methods reading the Source database.
- When the Server + Port + Username are the same for Source and Target the tables are read using 3-part-name or 4-part-name convention <Server>.<Source_DB>.<schema>.<table_name>
ELSE - The table is classified "Full": OPENROWSET is used. Then the table is
- The table is classified "Subset:" : OPENDATASOURCE. is used.