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
Comments
Post a Comment