public string DefiningScopeAndProvisioningServer(string conSQL, string tableName, string type)
    {
        try
        {
            string[] splitString = null;
            splitString = tableName.Split('|');

            SqlConnection con = new SqlConnection(conSQL);
            foreach (string _tableName in splitString)
            {


                DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription(_tableName + "_Scope");
                //definisikan scope table
                DbSyncTableDescription tabDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable(_tableName, con);
                //tambahkan table ke scope definisi
                scopeDesc.Tables.Add(tabDesc);
                switch (type)
                {
                    case "Provisioning":
                        SqlSyncScopeProvisioning srvProvision = new SqlSyncScopeProvisioning(con, scopeDesc);
                        srvProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
                        //SyncTracer.Verbose("")
                        srvProvision.Apply();
                        break;
                    case "Deprovisioning":
                        SqlSyncScopeDeprovisioning srvDeProvision = new SqlSyncScopeDeprovisioning(con);
                        srvDeProvision.DeprovisionScope(_tableName + "_Scope");
                        srvDeProvision.DeprovisionStore();
                        break;
                }



            }
            return null;
        }
        catch (SyncException ex)
        {
            StringBuilder sb = new StringBuilder();
            //sb.Append("n Error Number : " + ex.ErrorNumber.ToString());
            sb.Append("n Message : " + ex.Message);
            sb.Append("n Stack Trace :" + ex.StackTrace);
            return sb.ToString();
        }
    }