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

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -