What about the connections in Subset and MS Sql Server

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.