Skip to main content
Skip table of contents

How does Subset communicate with remote MSSQL databases?

Situation

How does DATPROF Subset read the remote database. It seems that this is not always done in 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.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.