Using the Test Client, I get a "No Such Table" error when trying to select some data from my database - sync was successful.
Here's my query: select * from schema.TableName
.
Try with:
SELECT * FROM TableName
i.e. without the schema name in front
Or, if the table was from a schema other than dbo
, it will be prefixed by the schema name + _
(see SQL Server Schemas in the ZSS Manager docs). So if the original table was MySchema.TableName, you'd use:
SELECT * from MySchema_TableName