2

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.

Paul Roub
  • 36,322
  • 27
  • 84
  • 93
iamcelineugat
  • 23
  • 3

1 Answers1

1

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
Paul Roub
  • 36,322
  • 27
  • 84
  • 93
ErikEJ
  • 40,951
  • 5
  • 75
  • 115
  • @PaulRoub Hmm I was under impression that this is MSSQL or alike system question, which parse schema name if provided, and use default schema if not. This way there should be no need just dropping schema part from table reference, and this won't work. (Good thing there was no downvote accompanied.) – Vesper May 21 '14 at 13:39
  • @Vesper No, OP is having trouble selecting at the other end of the sync, from SQLite. The MSSQL schema will not have come along. – Paul Roub May 21 '14 at 13:40