Skip to main content
Skip table of contents

How does Subset communicate with remote MSSQL databases?


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.

JavaScript errors detected

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

If this problem persists, please contact our support.