Which tables can be cached?
Updated: July 2008
Some tables that are in the database (the database listed as the Server connection) do not appear in the Configure Tables for Offline Use dialog box.
After you set the Server connection in the Configure Data Synchronization dialog box, the server is queried for a list of tables. The list will sometimes not include all the tables the current user has access to in the database.
This list does not include tables that:
Are not in the user’s default schema. (Starting in Visual Studio 2008 SP1, tables in all schemas are available for caching and are represented in the list.)
To determine which schema is being displayed, inspect the text above the list of tables. The text appears in the following format: Tables on 'DatabaseName.SchemaName'. The SchemaName listed is the current default schema. For information about default schemas, see User-Schema Separation in SQL Server 2005 Books Online.
Do not have a primary key defined.
Have names longer than 118 characters.
Contain columns with data types that are not supported by SQL Server Compact 3.5.