c# - Microsoft sync The default schema does not exist -

c# - Microsoft sync The default schema does not exist -

i utilize microsoft sync framework sync info between remote , local info base, face error "the default schema not exist" when applying provisioning on remote server.

sqlsyncprovider sqlproviderlocal = new sqlsyncprovider(scopename, sqlconnlocal); sqlsyncprovider sqlproviderremote = new sqlsyncprovider(scopename, sqlconnremote);

sqlsyncscopeprovisioning scopeprovisionlocal = new sqlsyncscopeprovisioning(sqlconnlocal); scopeprovisionlocal.objectschema = ".dbo"; if (!scopeprovisionlocal.scopeexists(scopename)) { dbsyncscopedescription scopedesc = new dbsyncscopedescription(scopename); foreach (var item in tables) { scopedesc.tables.add(sqlsyncdescriptionbuilder.getdescriptionfortable(item, sqlconnlocal)); } scopeprovisionlocal.populatefromscopedescription(scopedesc); scopeprovisionlocal.setcreatetabledefault(dbsynccreationoption.skip); scopeprovisionlocal.apply(); } sqlsyncscopeprovisioning scopeprovisionremote = new sqlsyncscopeprovisioning(sqlconnremote); scopeprovisionremote.objectschema = ".dbo"; if (!scopeprovisionremote.scopeexists(scopename)) { dbsyncscopedescription scopedesc = sqlsyncdescriptionbuilder.getdescriptionforscope(scopename, sqlconnlocal); scopeprovisionremote.populatefromscopedescription(scopedesc); scopeprovisionremote.apply(); } agent.localprovider = sqlproviderlocal; agent.remoteprovider = sqlproviderremote; syncoperationstatistics stats = agent.synchronize(); result = clearextras(); sqlconnlocal.close(); sqlconnremote.close();

c# microsoft-sync-framework