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.