This topic is locked

MSSQL Server - PHPRunner Tables Interpretation

2/14/2022 3:43:23 PM
PHPRunner General questions
S
salus2 author

Hello,
I recently configured a test MSSQL server with both NortwindTraders and AdventureWorks example databases and now have a question regarding how PHPRunner determines table structure.

If you look at the NorthWind screenshot it shows both SQL Server Management Studio (SSMS) and PHPrunner table and view interpretations match...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=28926&image=1&table=forumtopics

If you look at the AdventureWorks screenshot you can see that very few tables or views match between SSMS and PHPRunner interpretations...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=28926&image=2&table=forumtopics

Sorry if this is a dumb question but what's up with that? Thanks for any assistance.

Sergey Kornilov admin 2/14/2022

No there is no such thing as "interpretation". PHPRunner simply reads the list of tables from the database. My guess is that you are pointing PHPRunner to a wrong database.

S
salus2 author 2/14/2022

Interpretation may not be the right word but there is definitely a difference in the way SSMS and PHPRunner list tables.

This third screenshot, from the WorldWideImporters example database, shows differences between SSMS and PHPRunner table lists...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=95794&image=1&table=forumreplies

If you look at these screenshots you can see from the connection details that both SSMS and PHPRunner are connecting to the same databases.

Sergey Kornilov admin 2/15/2022

I see no differences here. What exactly is different?

S
salus2 author 2/15/2022

I see minimal differences in the NorthWind table lists...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=95800&image=1&table=forumreplies

I see a number of differences in the WorldWideImporters table lists...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=95800&image=2&table=forumreplies

I see tons of differences in the AdventureWorks table lists...
https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=95800&image=3&table=forumreplies

Was just wondering if anyone else had observed this and could provide an explanation.