Situation

How does DATPROF Subset read the remote database. It seems it is not always done the same way.


Explanation

True, DATPROF Subset uses several methods reading the Source database.

  • When 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.
  • The table is classified "Subset:" : OPENDATASOURCE. is used.