How does DATPROF Subset read the remote database. It seems it is not always done the same way.
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>
- The table is classified "Full": OPENROWSET is used. Then the table is
- The table is classified "Subset:" : OPENDATASOURCE. is used.