guid - Local Data Cache SyncTable Schema not copied, clientSyncProvider _ CreatingSchema does not fire -
i using vs2008 local data cache tool synchronize sqlserver 2008 db local sql ce 3.5. @ server have table pk datatype uniqueidentifier
, defaultvalue newid()
. upon initial synchronization through local data cache db creates not copy default value column (as described here: http://msdn.microsoft.com/en-us/library/bb726037%28v=sql.105%29.aspx, see "..the following constraints not copied client: foreign key constraints, unique constraints, , default constraints...")
i have found similar question here: ms sync framework: table schema not copied local db.
but when tried implement solution, found creatingschema event clientsyncprovider of local data cache partial class not fire.
how come? how change schema local data cache?
thanks ideas can come with.
what tablecreation option settings client database? if sdf , initial schema has been created local database cache wizard, subsequent syncs no longer create schema not unless specify via tablecreation option existing tables dropped , replaced new schema.
Comments
Post a Comment